Re: Viewing/copying only Deleted Records

Thanks...I never needed to do this before so I did not know about the
COMPRESS(*NO) parameter.  Since the data is limited to about a 6 month time
frame that will limit the records that I need to look at.

Eric

----- Original Message -----
From: "Douglas Handy" <dhandy1@xxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, August 18, 2004 2:49 PM
Subject: Re: Viewing/copying only Deleted Records


> Eric,
>
> > Using WRKDBF, I can "undelete" these records.
>
> Make a copy of the file (eg CPYF ... COMPRESS(*NO) to retain deleted
records)
> then use WRKDBF/WRKDBFUNDL to mass un-delete all deleted records in the
entire
> file.
>
> Run a SQL or whatever search for records which match your criteria, which
will
> then of course include records which were not originally deleted.  Join
back to
> the production file to find out which were not previously deleted.
>
> Doug
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>