Raul,
It all depends on whether you are talking about traditional DDS defined database files, or SQL DDL-defined tables, because by default SQL tables will have REUSEDLT(*YES) specified. So, in that case, the journal is the only reliable way ...
Or, get out the back-up tapes, and find a copy of that file from last night's incremental back-ups, restore it to some "temporary" library, and then copy the records from there?
If you happen to have a DDS-defined *FILE with REUSEDLT(*NO), the old default, then deleted records are still "in there" but marked as deleted with a "delete byte" in position one of the record. There are a number of tools that can recover deleted records by changing that "delete byte" to indicate the record is not deleted, but this requires some low-level APIs requiring use of ILE C APIs, etc.
You could also save the current file into a save file, then a program can read the save file to find (and recover) the deleted records. Lots of work...
For a nice example of some of these techniques, see:
https://think400.dk/downloads ;
and page down until you see:
Dave McKenzie - Undel II (undelete records)
It is well-documented.
I hope that helps,
Mark S. Waterbury
On Monday, November 21, 2022 at 10:10:16 AM EST, Raul Alberto Jager Weiler <raul.jager@xxxxxxxxx> wrote:
Is there a way to recover data from deleted records? I remember that in
older releases there was an utility that had an option to undelete, but I
do not know if it works with current releases.
I know the journal can do it, unless the receivers are deleted.
midrange.com
