Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 the sign only if the value is... useit DFSORT/ICETOOL 3 Wed Oct 04, 2017 5:53 pm
No new posts Binary to display characters Roy Ware SYNCSORT 3 Tue Sep 19, 2017 8:46 pm
No new posts PLI %IF statements Pedro PL/I & Assembler 1 Tue Sep 19, 2017 12:06 am
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us