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?

 

Proc1 

CREATE PROCEDURE xxx.PROC1
RESULT SETS 1

BEGIN

DECLARE C1 CURSOR FOR...;

OPEN C1 ;

                SET RESULT SETS CURSOR C1;

END

                

Proc2 

CREATE PROCEDURE xxx.PROC2
RESULT SETS 1

BEGIN

DECLARE C1 CURSOR FOR...;

OPEN C1 ;

                SET RESULT SETS CURSOR C1;

END

 

Proc3

CREATE PROCEDURE xxx.PROC3
RESULT SETS 1

BEGIN

DECLARE C1 CURSOR FOR...;

OPEN C1 ;

                SET RESULT SETS CURSOR C1;

END

 

Proc4?????? How do I get the result sets back from the called procedure
and pass them back from this procedure when called?

CREATE PROCEDURE xxx.PROC3
RESULT SETS 3

BEGIN

CALL xxx.PROC1;

CALL xxx.PROC2;

CALL xxx.PROC3;

END

 

 

David Smith

IT Consultant

Tri-State Hospital Supply Corporation

(517) 546-5400  Ext. 1359