Bob, >Is there a way to retrieve a deleted record without having to copy the >entire physical file to the save file and reading through the save file. It >would be really nice to be able to retrieve a deleted record by key. I know >there are some products out there that allow this, but was wondering how >hard it would be to write in-house. You can't retrieve a deleted record by key, or at least not directly. They have to be retrieved by RRN. The only way you would have a pseudo-key retrieval would be by sequentially checking the records till you had a match on the key field(s). How hard it would be to write in-house depends on how well versed you are with MI. You can't do it directly from a HLL, except via the SAVF technique. But why bother? Dave McKenzie has graciously put his UNDEL in the public domain, including the MI source. Or you could just call his MI program with the right parameters and put your own interface on it if you didn't like his. That is what was done with WRKDBF, which also supports undeleting records. It uses McKenzie's routines under the covers. The v07 release of WRKDBF only allowed undelete of non-keyed physical files, but the newer v08 release allows it on keyed files as well. You may want to check out both of these utilities -- they are free. The UNDEL source and objects for both RISC and CISC can be found on at www.news400.com under Resources | Code | Freeware, and the latest WRKDBF can be found for both RISC and CISC at www.wrkdbf.com. Doug +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.