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

How to Display statements in SQL DB2 stored procedure


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vsunilvarma

New User


Joined: 24 Mar 2009
Posts: 1
Location: Columbus

PostPosted: Wed Mar 25, 2009 10:43 pm
Reply with quote

Hi all,

I have a DB2 SQL stored procedure which has 10 cursors defined in it.
I execute this SP using a QMF batch job using JCL.Can get the activity log of the SP after I execute the SP using JCL .
The DD statement 'DSQDEBUG' only gives me the high level description of the process.

Please help me on this query
Back to top
View user's profile Send private message
anv2005

New User


Joined: 14 Jul 2005
Posts: 44
Location: US

PostPosted: Mon Mar 30, 2009 11:08 pm
Reply with quote

We offer a DB2 attachment product, that prints out all SQL statements, with all host variables defined. Follow the product link for details: www.relarc.com/smartrrsaf.

Also, please take a look at our Stored Procedure Manager (
forum.relarc.com/phpbb3/viewforum.php?f=6) with which you can develop, test, deploy and manage routines such as Stored Procedures (SP), User Defined Function (UDF) and Distinct Data Types (DDT) directly on z/OS platform.

Best regards,
Alex.
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts How to display the leading zeros of a... DB2 7
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
No new posts Relate COBOL statements to EGL statement All Other Mainframe Topics 0
Search our Forums:

Back to Top