IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

XPEDITER question regarding Stored Procedures


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Mr. KnowItNot

New User


Joined: 22 Feb 2006
Posts: 2

PostPosted: Wed Feb 22, 2006 9:30 pm
Reply with quote

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
View user's profile Send private message
bonniem

New User


Joined: 09 Aug 2005
Posts: 67

PostPosted: Thu Feb 23, 2006 10:41 am
Reply with quote

Hi, could you explain how you are doing this? I mean how are you calling an SP as a sub routine?
Back to top
View user's profile Send private message
pnambiar

New User


Joined: 24 Feb 2006
Posts: 3

PostPosted: Fri Feb 24, 2006 11:56 pm
Reply with quote

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
View user's profile Send private message
Mr. KnowItNot

New User


Joined: 22 Feb 2006
Posts: 2

PostPosted: Sat Feb 25, 2006 2:31 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts Sort w/OUTREC Question DFSORT/ICETOOL 2
No new posts Stored procedure cpu utilization DB2 1
No new posts Assembler test under mask question PL/I & Assembler 5
No new posts Question for Cobol Report Writer COBOL Programming 3
No new posts Infoprint AOPPRINT question All Other Mainframe Topics 0
Search our Forums:

Back to Top