Frank,
RUNSQLSTM (not RUNSQL) will generate an audit of your SQL statements in
a spooled report.
Need a record count of records deleted?
Try command RUNSQLSTM SRCFILE(AMSSRC/QQMQRYSRC) SRCMBR(J55SQLCNTQ)
COMMIT(*NONE)
In the example above, source SRCFILE(AMSSRC/QQMQRYSRC)
SRCMBR(J55SQLCNTQ) has this statement: DELETE FROM CANDTA/F42199
Spooled report shows 12,949,319 rows deleted from F42199 with these
messages shown below:
SQL0088 0 1 Position 1 DELETE applies to entire table.
SQL7955 0 1 Position 1 12949319 rows deleted from F42199 in
CANDTA.
