RE: is there a way to recover deleted records ?

Ok, thanks Doug. Now that you mention it, I do remember that SAVF twist...

Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Douglas Handy
Sent: Monday, February 04, 2008 10:11 AM
To: Midrange Systems Technical Discussion
Subject: Re: is there a way to recover deleted records ?


Eric,

I seem to recall a thread awhile back that revealed that SQL DELETEs
cannot be undone. As I recall, when SQL deletes a row, the record gets
initialized.

http://archive.midrange.com/rpg400-l/200706/msg00495.html

Rereading this thread, it seems the scenario was inconclusive. Anyone
know for sure?

I was wrong when jumping to that conclusion. I don't think it has anything
to do with SQL vs HLL deletes. As Bruce Vining later pointed out, it has to
do with whether a "fast copy" is performed when creating the SAVF used to
extract the "undeleted" records. When fast copy is available, the original
data (including deleted data) is inserted in the SAVF; when fast copy can
not be performed, deleted records are just initialized and don't retain the
deleted data.

I don't recall the exact criteria for a fast copy -- but IIRC one of them
was needing exclusive access to the file.

Doug