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 Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Display FTP Session Count within TSO Yolanda Harvey TSO/ISPF 3 Fri Mar 10, 2017 10:31 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
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


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