Calling Stored Procedure with in Stroed procedure

IBM's flagship relational database management system
gauravfrankly
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Skillset: COBOL, JCL, DB2, REXX
Referer: google

Calling Stored Procedure with in Stroed procedure

Postby gauravfrankly » Thu Sep 03, 2015 6:45 pm

Hi All,
I have following case:
Team A will call the Stored procedure SP1.
SP1 will call the SP2.
In SP2 will OPEN a cursor and want resultset of this cursor to send to TEAMA as response to their call made to SP1.
SP1 and SP2 are Native DB2 Stored Procedures.

Please suggest approch to do this.

  • Similar Topics
    Replies
    Views
    Last post