Re: is there a way to recover deleted records ?

Although the problem with the older version of UNDEL2 was diagnosed and then corrected in a newer version, that does not eliminate the fact that some SQL DELETE may in fact cause deleted rows to be unrecoverable using a utility using the SAVOBJ to access the data indirectly. In fact since the ability to recover the data is due entirely to implementation details, since implementation details may change, one should not expect that method of recovering rows to be available; e.g. just as currently the ability to recover varlen data is already effectively not [or is in some cases im]possible.

The best bet is to simply journal all sufficiently important database files, so that in the event some accidental deletion occurs, the data can be recovered without having to rely on /tricks/ versus supported /methods/ against the data. If the file is not important, nor should be the ability to recover from such an error. So as not to require explicit journaling for a particular library, there is the option to either create the QDFTJRN *DTAARA [look up details using QDFTJRN as search token] into libraries where important files will reside, or use SQL to create the files using CREATE TABLE and create important files in an SQL SCHEMA.

Regards, Chuck