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.
Calling Stored Procedure with in Stroed procedure
-
- Posts: 39
- Joined: Fri Aug 07, 2015 3:30 pm
- Skillset: COBOL, JCL, DB2, REXX
- Referer: google
-
- Similar Topics
- Replies
- Views
- Last post
-
- 1
- 1771
-
by NicC
View the latest post
Sun Nov 22, 2020 2:09 am
-
- 3
- 2289
-
by NicC
View the latest post
Sat Nov 21, 2020 3:16 am
-
- 2
- 8428
-
by prino
View the latest post
Sat Mar 13, 2021 4:47 am
-
-
Override DD-statements of an in-stream procedure
by aldencarr123 » Sun Nov 15, 2020 3:40 am » in JCL - 4
- 2587
-
by willy jensen
View the latest post
Mon Nov 16, 2020 1:53 pm
-
-
- 0
- 1530
-
by rogerstrycova
View the latest post
Fri Oct 22, 2021 12:41 pm