HI Folks,

i was stuck at my work with this issue :

Created one member i.e, INS_INTF in CDC/SRC_CDC,where this member contains a set of SQL insert statements nearly about 116.I wanted to execute/run this in AS400.

can any body try to find out a solution for me.

My CL program :

 CREATE PROCEDURE CDC/INS_TEST11()
 LANGUAGE SQL
 P1: BEGIN
       INSERT INTO cdc/abc (select * from cdc/xyz);
       INSERT INTO cdc/cde (select * from cdc/qrs);
                         "
                         "
                         :
                     116 inserts
 END P1


Regards,
siva