XPEDITER question regarding Stored Procedures

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.

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?

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.

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.