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
 

 

How to Display statements in SQL DB2 stored procedure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: How to Display statements in SQL DB2 stored procedure
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    Post subject:
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    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 Display ZEDLMSG without Pressing F1 &... anandgbe CLIST & REXX 8 Thu Dec 15, 2016 4:20 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 Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts How to display value of an exit param... lind sh CICS 2 Sun Oct 09, 2016 12:28 pm


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