DB2 inserts data using Stored Procedures

DB2 needs to insert data using stored procedures: insert three fields (ID, GROUPID [Group id], USERID [user ID]) in a table (TESTMV). To generate multiple groups, the following code is used to calculate the number of persons in each group based on the data of multiple persons in each group:

[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 ();