Reuse deleted records (was SQL vs DDS)

[Roger Boucher <RBoucher@xxxxxxxxxxx>]

This brings to mind a question... what if you want to recover deleted
records.  I am assuming that if you reuse deleted records you wouldn't be
able to recover them using any of the utilities available for that purpose?


-----Original Message-----
From: Jim Langston [mailto:jlangston@conexfreight.com]
Sent: Wednesday, August 25, 1999 1:23 PM
To: MIDRANGE-L@midrange.com
Subject: Re: SQL vs DDS


Actually, there is only one reason I have come up with to reusedeleted *NO.
I asked that same question a few years ago, and the consensus was it was
useful for debugging.

Quite a number of times someone comes up and says they just ran a job, they
did it totally wrong, could I fix it?  I ask them for invoice number,
container
numbers, no, they don't have the numbers.

So, I just work with the file using PDM and do a 5 on the member, jump down
to the bottom and I can see the last records that were added.

If I had ReUseDeleted *YES I wouldn't know that the last records were
actually
the last records added to the file.

That is the only reason people have come up with when I asked.  As such,
some
files I have ReuseDeleted *YES and some I have it as *NO.

Regards,

Jim Langston

John P Carr wrote:

<SNIP>

>  (BTW,  I don't know why anyone would not be
> using ReUseDeleted Records *YES).

<ENDSNIP>


+---
| 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
+---
+---
| 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
+---