MVSFORUMS.com

[KOUSIK]

Hi,

We have two tables TAB_STD and TAB_ACT, wherein the table TAB_STD will hold expected result on an operation and TAB_ACT will contain the actual results of the operation. Now, I am trying to DELETE the old expected results from the table TAB_STD and replacing it with TAB_ACT info.

To achieve the above I have prepared two set of queries one to delete the info from TAB_STD and the other set to load TAB_STD with TAB_ACT data. I am executing this query through a JCL using the DSNTIAUL program.

The JCL is running fine but I want to compare the number of rows deleted from the TAB_STD with the number the rows inserted in TAB_STD from TAB_ACT which I am unable to do because, the SYSPRINT is not displaying the number of rows affected information after executing the queries. Is there a way to achieve this???