View previous topic :: View next topic
|
Author |
Message |
Mr. KnowItNot
New User
Joined: 22 Feb 2006 Posts: 2
|
|
|
|
Hi. I'm currently working on a project where we're changing the calling feature in some of our mainframe programs to call stored procedures as subroutines. They will still execute in an SPAS, but will be treated by COBOL as a subroutine. My question is this:
Will XPEDITER treat the stored procedure as a stored procedure (for debugging purposes) even though it is being called as a subroutine? Any help would be greatly appreciated. |
|
Back to top |
|
|
bonniem
New User
Joined: 09 Aug 2005 Posts: 67
|
|
|
|
Hi, could you explain how you are doing this? I mean how are you calling an SP as a sub routine? |
|
Back to top |
|
|
pnambiar
New User
Joined: 24 Feb 2006 Posts: 3
|
|
|
|
Plain cobol subroutine call will not execute in DB2 SPAS. Therefore you should be able to xpedite as a cobol subroutine and not as SP. |
|
Back to top |
|
|
Mr. KnowItNot
New User
Joined: 22 Feb 2006 Posts: 2
|
|
|
|
I misread my information earlier. The COBOL stored procedure, when called from a batch COBOL program, will execute in the address space of the originating call (when called as a subprogram). That being the case, you are correct. Xpediter could be used to debug. Thanks for your help! I appreciate it.
To answer bonniem, I'm going to simply make the call a COBOL call instead of an EXEC SQL call. As long as you're not trying to pass back a result set from the SP, this should work. |
|
Back to top |
|
|
|