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.
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.