MVSFORUMS.com

[kkmsmail]

How to I convert the DB2 stored procedure into an atomic script? The stored procedure is given below.

CREATE PROCEDURE ABCD.NEWINSERT()
LANGUAGE SQL
P1:BEGIN

DECLARE < few variables >

DECLARE C1 CURSOR FOR < select stmt with where
condition>

OPEN C1;

ins_loop: LOOP

FETCH C1 INTO < variables>

<SKIP LOOP LOGIC>

INSERT INTO functionname(list of columns) values (list of values)

END LOOP

CLOSE C1;
END P1