1. 拼删除语句:
select 'delete from '||table_name||' where ID_>10' from sysibm.tables where TABLE_schema='ODSUSER '
2.拼import语句:
select 'db2 IMPORT FROM '|| a.TABLE_NAME ||'.IXF OF IXF MODIFIED BY FORCECREATE COMMITCOUNT 10000
replace_create INTO ' ||a.TABLE_NAME
from sysibm.TABLES a where a.TABLE_SCHEMA='ODSUSER'
3. db2 删除前多少行
delete from
(select * from CPS_BZ_SZSTAFF fetch first 690 rows only)