Re: How to retrive deleted record in SQL?

[dhandy@xxxxxxxxxxx (Douglas Handy)]

Walden,

>Correct me if I'm wrong, but manipulating the flags in the save file would
>not work since the restore would crash because the CRC code for the savf
>record would not match the data for that record. (Unless you know the
>algorithm for savf CRC codes.)

Sorry; you are right of course.  I remembered QUSRTOOL used the savf
method but mismembered what it did after that and didn't think about
it before posting.  I just checked, it writes the deleted records to a
new file in a different library where you have to decide which
record(s) to merge back into the original file.

I was just mentioning QUSRTOOL in passing because I think Dave
McKenzie's direct display/retrieval is alot slicker.  BTW, it only
uses MI to retrieve the data.  It uses regular disk operations to add
deleted records back to the file.  A neat utility to have in the
toolbox "just in case".  I have not (yet) had to use it.

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: david@midrange.com
+---