帮我看看DB2中怎么循环插入语句
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@