RE: SQL Result Sets From Multiple Procedures

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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