I am trying to use GET DIAGNOSTICS statement after an DELETE IN DB2
does not return the # of rows inserted. Below is the code and output
It only returns the # on rows while debugging with datastudio, but not when invoked in command line
here is the proc (DB2 V9.1 FP 9 )
DROP PROCEDURE DB2RPDI.PURGE_S TATS/
CREATE PROCEDURE DB2RPDI.PURGE_S TATS
(IN DATE_PURGE DATE,
...