MIDRANGE dot COM Mailing List Archive



MIDRANGE-L » February 2013

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



Are you by chance journaling the file.

On Wed, Feb 6, 2013 at 2:16 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

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

--
Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







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