insert into "T_RP_GY_DMBXX"("BBDM","TBNAME","DM_BH","SJDM_BH","MC","MS","CPBH","XY_BJ","LR_SJ","XG_SJ") values ('RP003','SYNSYHZBCZLQKB','@DB_MH',null,null,null,null,'1',null,null);
如上语句要求是DB_MH从1查到45 其他不需要改 如何循环插入45次且每次加1
------解决方案--------------------------------------------------------
把下面的代码写到一个文件中，比如tmp.sql，然后用 db2 -td -f tmp.sql 执行。
- SQL code
begin atomicdeclare i integer;set i=1;while i<=45 do insert into "T_RP_GY_DMBXX"("BBDM","TBNAME","DM_BH","SJDM_BH","MC","MS","CPBH","XY_BJ","LR_SJ","XG_SJ") values ('RP003','SYNSYHZBCZLQKB',trim(char(i)),null,null,null,null,'1',null,null); set i=i+1;end while;end@