Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Xpediter: STEP OVER cobol section Auryn Compuware & Other Tools 0 Thu Feb 22, 2018 9:30 pm
No new posts JES2 EXIT 6 QUESTION Randy Horowitz All Other Mainframe Topics 30 Tue Feb 06, 2018 5:47 pm
No new posts CICS web service from DB2 Triggers or... kiranprasad DB2 2 Wed Dec 20, 2017 11:10 am
No new posts question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us