SQL Result Sets From Multiple Procedures

Elvis,

Perfect...thank you!

David Smith
IT Consultant

>>from: "Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>
>>subject: RE: SQL Result Sets From Multiple Procedures
>>
>>David, I ran this in iNav's Run Sql Scripts tool and looks like it
works.
>>You should be able to simply paste it in the window and click on
Run->All.
>>
>>/* Start script */
>>
>>CREATE PROCEDURE QGPL.PROC1()
>>RESULT SET 1
>>LANGUAGE SQL
>>BEGIN
>>   DECLARE MYCURSOR1 CURSOR WITH RETURN TO CLIENT FOR
>>     SELECT * FROM SYSIBM.SYSDUMMY1;
>>   OPEN MYCURSOR1;
>>END;
>>
>>CREATE PROCEDURE QGPL.PROC2()
>>RESULT SET 1
>>LANGUAGE SQL
>>BEGIN
>>   DECLARE MYCURSOR2 CURSOR WITH RETURN TO CLIENT FOR
>>     SELECT * FROM SYSIBM.SYSDUMMY1;
>>   OPEN MYCURSOR2;
>>END;
>>
>>CREATE PROCEDURE QGPL.PROC3()
>>RESULT SET 1
>>LANGUAGE SQL
>>BEGIN
>>   DECLARE MYCURSOR3 CURSOR WITH RETURN TO CLIENT FOR
>>     SELECT * FROM SYSIBM.SYSDUMMY1;
>>   OPEN MYCURSOR3;
>>END;
>>
>>CREATE PROCEDURE qgpl.FINALPROC1()
>>RESULT SETS 3
>>LANGUAGE SQL
>>BEGIN
>>  CALL QGPL.PROC1();
>>  CALL QGPL.PROC2();
>>  CALL QGPL.PROC3();
>>END;
>>
>>CALL QGPL.FINALPROC1();
>>
>>/* End script */
>>
>>Hope that helps.
>>
>>Elvis
>>
>>-----Original Message-----
>>Subject: SQL Result Sets From Multiple Procedures
>>
>>If I have three procedures each returning one result set, can I create
a
>>fourth procedure that calls the three and returns all three result
sets?
>>
>>David Smith