2 如果你采取导入导出数据export+load的话在导入数据,且668报错后,执行以下脚本,解除完整性暂挂状态with gen(tabname,seql) as (select rtrim(tabschema)||'.'||rtrim(tabname) as tabname,row_number() over (partition by status) as seq from syscat.tables where st...
显示全部2 如果你采取导入导出数据export+load的话
在导入数据,且668报错后,执行以下脚本,解除完整性暂挂状态
with gen(tabname,seql) as (select rtrim(tabschema)||'.'||rtrim(tabname) as tabname,row_number() over (partition by status) as seq from syscat.tables where status='C'),r(a,seq1) as (select cast(tabname as varchar(3900)),seq from gen where seq=1 union all select r.a||'.'||rtrim(gen.tabname),gen.seq from gen, r where (r.seq1+1)=gen.seq),r1 as (select a,seq1 from r) select 'set integrity for'||a||'immediate checked' from r1 where seq1=(select max(seq1) from r1)
收起