Re: Fastest way to delete records.

["James W. Kilgore" <qappdsn@xxxxxxxxxxxxx>]

Jim,

Dang it, I've got to start reading the follow-ups before I respond ;)

In this case, I, too, would vote for the one time cost of building a permanent 
index.

Jim Langston wrote:

> James,
>
> It was stated that this would be run monthly or semi monthly.  Yes, for a one 
>time
> shot, I would just go through the records and compare each individually, then 
>copy
> and delete the ones that are needed.
>
> Since he needs to do this on a regular basis, though, ones the logical file 
>is built
> it won't take any appreciable time to maintain it, so the next time he uses 
>this
> procedure there won't be the logical build overhead.
>

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---