RE: SQL Delete question - Finished

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

Dennis,

<snip>
> Richard & Tom mentioned the CPYF process & that would have been my next
> attempt if the SQL would not have worked out.  I do have to run the CPYF
to
> get rid of the deleted records but I will wait until month-end & get rid
of
> the deleted records.
<snip>

You might try RGZPFM instead of the double cpyf, now that you have the
records you want gone deleted.  I don't know for sure that it is faster,
but that IS exactly what RGZPFM is for - removing deleted records, and
optionally, physically sorting the file on disk by it's (or one of it's
logicals) access path.

good luck!

Rick