×
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.
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
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.
midrange.com
