Re: HELP... I accidentally deleted too many records!!

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

> Okay, this wouldn't be so bad if our back worked last night, but it didn't.
>
> I did an SQL delete to purge out some records, it purged too many. Can
> anyone tell me a way to restore all of them? There is no journal on the
> file.


Many (all?) of the 'Undelete' procedures will NOT work if you've used 
RGZPFM on the file.  Reuse deleted records selected for the file will 
also cause problems.

You can also 'roll your own' undelete-- although it takes a bit of 
programming.  Save the file to a save file.  Read the save file in an 
RPG program (I believe the record length is 528).  You'll encounter 
some header information, then all of the records, one by one.  Strung 
out, end-to-end, spanning (or taking a fraction) of the 528 byte 
records.  You'll have to paste them together!  Each record has its 
own header of sorts; one key piece of information is a 'deleted' 
flag.  Your RPG program can ignore the flag and read it anyway. 
Write the re-assembled records to a COPY of the original file.  et 
voila!  The trick, she is done!

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx