MIDRANGE dot COM Mailing List Archive



MIDRANGE-L » February 2013

Re: RUNSQL joblog or stats to report on the number of records deleted



On 06 Feb 2013 09:49, fbocch2595@xxxxxxx wrote:
I'm using RUNSQL to delete records in a batch CLP, is there any way
to get info as to the number of records deleted? <<SNIP>>

If such a generic utility must be used instead of writing the code and using the SQLERRD(3) of the SQLCA to identify the number of rows deleted, then perhaps it would be sufficient also to use the counts from the member against which the DELETE is directed; i.e. RTVMBRD [or an API equivalent] to get the before and after details about the number of deleted rows.?






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact