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
 

 

Test JCL for testing Stored Procedure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Santoshkumar Sala

New User


Joined: 18 Jul 2010
Posts: 12
Location: Mumbai

PostPosted: Fri Jun 01, 2012 10:40 pm    Post subject: Test JCL for testing Stored Procedure
Reply with quote

Hi All,
Can anyone tell me what will be the test JCL to execute Stored Procedure through XPEDITOR.

Please let me know the steps / suggestions for same.
Back to top
View user's profile Send private message

Prakash J

New User


Joined: 23 May 2012
Posts: 14
Location: India

PostPosted: Fri Jun 01, 2012 11:11 pm    Post subject: Reply to: Test JCL for testing Stored Procedure
Reply with quote

Hi Santhosh,

Are you talking about Db2 stored procedure?

I am not able to understand why you want to execute it through Xpediter.

Can you please provide some more information about your requirement?

Thanks,
Prakash
Back to top
View user's profile Send private message
Santoshkumar Sala

New User


Joined: 18 Jul 2010
Posts: 12
Location: Mumbai

PostPosted: Sat Jun 02, 2012 4:07 pm    Post subject:
Reply with quote

Hi Prakash,
Have some issue in my DB2- Stored Procedure (written in COBOL). So i want to debug the issue so planning to use XPEDITOR. To execute the SP using XPEDITOR need a Test JCL. If anyone has any idea related to this then please share.
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 662
Location: Pennsylvania

PostPosted: Mon Jun 04, 2012 5:54 pm    Post subject:
Reply with quote

What we have done in our shop is write a COBOL 'stub' program.

This program gets its input from a input parameter or reading from an input file. It then calls the Stored Procedures as a regular Cobol subroutine.

This way you can execute your SP from a batch JCL.

Sorry I can not locate any examples, but the concept is the important part.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 647
Location: Whitby, ON, Canada

PostPosted: Mon Jun 04, 2012 10:04 pm    Post subject:
Reply with quote

Stored Procedures run in their own address space, so I suspect you would need to ask your Systems Programmers to modify the JCL that runs that address space to accommodate Xpediter. They may not want to do this because it might result in you monopolizing the address space while you are sitting at an Xpeditor breakpoint.

I would recommend using daveporcelan's approach.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Jun 05, 2012 2:11 pm    Post subject:
Reply with quote

This link does not talk about the JCL, however tells about other perspective of testing the DB2 SPs: http://publib.boulder.ibm.com/infocenter/idm/v2r1/index.jsp?topic=/com.ibm.datatools.routines.tutorial.doc/topics/routines_introduction.html
Back to top
View user's profile Send private message
chandan.inst

Active User


Joined: 03 Nov 2005
Posts: 269
Location: Mumbai

PostPosted: Tue Jun 05, 2012 3:01 pm    Post subject:
Reply with quote

Hi Santosh,

You can debug the stored procedure by putting Display in your stored proc.

below link might help for display's in stored proc

http://ibmmainframes.com/about53279.html

Also if you mention
Code:
PROCESS OUTDD(<DD Name>)
at the beginning of your stored proc (before ID division) you can see the display's in spool under DD name provided by you

Hope it helps

Regards,
Chandan
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 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
No new posts COOLGEN - TSO TEST FACILITY indianrajput CA Products 4 Wed Nov 02, 2016 9:28 pm


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