DB2使用存储过程插入数据   要求：插入一张表（TESTMV）中三个字段（ID, GROUPID【组id】, USERID【用户id】），为了产生多个组，每个组多个人的数据，进行统计每个组多少人数据用   代码如下：  

[html]delete testmv;
create procdedure insertdb() language SQL begin declare v_num int;
declare v_num1 int;
declare v_num2 varchar(12);
set v_num=0;
set v_num1=1;
loop1: LOOP if(v_num<100) then set v_num = v_num +1;
set v_num1=1;
loop2: LOOP if(v_num1<=100) then insert into testmv(ID, GROUPID, USERID) VALUES('
id'
||v_num||v_num1, '
groupid'
||v_num, '
userid'
||v_num||v_num1);
set v_num1=v_num1+1;
else leave loop2;
end if;
end loop loop2;
else leave loop1;
end if;
end loop loop1;
end;
call insertdb();
drop procedure insertdb();