DBVisual 中拼凑SQL语句

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)