Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

XPEDITER question regarding Stored Procedures

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
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    Post subject: XPEDITER question regarding Stored Procedures
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    Post subject:
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    Post subject: Re: XPEDITER question regarding Stored Procedures
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    Post subject: Re: XPEDITER question regarding Stored Procedures
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    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us