× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. May 2003

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

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.