View previous topic :: View next topic
|
Author |
Message |
Santoshkumar Sala
New User
Joined: 18 Jul 2010 Posts: 12 Location: Mumbai
|
|
|
|
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 |
|
|
Prakash J
New User
Joined: 23 May 2012 Posts: 14 Location: India
|
|
|
|
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 |
|
|
Santoshkumar Sala
New User
Joined: 18 Jul 2010 Posts: 12 Location: Mumbai
|
|
|
|
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 |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
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 |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
Back to top |
|
|
chandan.inst
Active User
Joined: 03 Nov 2005 Posts: 275 Location: Mumbai
|
|
|
|
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 |
|
|
|