RE: Undelete a huge pf

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

I might take you up on your offer, I'm in the process, of installing wrkdbf
to our test box, .. And then I need to move this big file over to our test
box, so I can run the undelete against it...  

If it doesn't work, I'll email you...

Thanks, Tim 

-----Original Message-----
From: midrange-l-bounces+thatzenbeler=clinitech.net@xxxxxxxxxxxx
[mailto:midrange-l-bounces+thatzenbeler=clinitech.net@xxxxxxxxxxxx] On
Behalf Of Martin Rowe
Sent: Tuesday, December 06, 2005 3:23 PM
To: Midrange Systems Technical Discussion
Subject: Re: Undelete a huge pf

On 06/12/05, Hatzenbeler, Tim <thatzenbeler@xxxxxxxxxxxxx> wrote:
>
> I have a large pf, with thousands of deleted records...  Is there a 
> tool I can use, that will bring back all those records in one action?
>
> Freeware, if possible...  It's for a quick query...

Tim

I seem to remember that WRKDBF uses Dave Mackenzie's UNDEL utility under the
covers. You can download just the UNDEL from the iSeries Network - despite
the directory name it is freeware:
http://www.iseriesnetwork.com/code/sharewarefiles/undelris.zip

I wrote a small front end, UNDELFILE, that loops through the file looking
for gaps in RRN, and pushes those through UNDEL to an *OUTFILE. It's been
very useful where an over optimistic program or SQL statement <cough> has
done more than it should have ;)

Regards, Martin
--
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net   /"\
DBG/400 - AS/400 & iSeries Open Source/Free Software utilities     \ /
Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news   X

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