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

[Douglas Handy <dhandy1@xxxxxxxxxxxxx>]

Mike,
>
>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? 

If you have TAATOOLS, I believe they include a command to retrieve deleted
records.  

Dave McKenzie also has an excellent freeware tool, UNDEL, which undeletes
records in any size physical file without the need to copy it to a savf as in
intermediate step.  UNDEL is available on the iSeriesNetwork website in the
shareware section, last I knew.

UNDEL is also used under the covers by another excellent freeware tool, WRKDBF,
which is a little like DBU.  With it you can undelete specific records from a
file (as UNDEL does), plus there is a command included to just mass undeleted
all deleted records in a given file.

See www.wrkdbf.com and download the format for your machine (RISC vs CISC)

Doug