RE: Reuse deleted records (was SQL vs DDS)

So I take it the answer to the question is yes.

By the way, we use JDEdwards, which doesn't journal... and if you are going
to suggest we start journaling are you then implying that journaling is no
longer a sizeable resource hit?  Is there a point to journaling when you
aren't doing commitment control?  Do the journals still need managing or can
we let the system switch them for us (we have no operators).  Excuse my
ignorance but it has been about 5 years since I've been in a shop with any
journaling and I was never an operator so I've never had to manage them...
although when I had them they were EXTREMELY useful for proving the user did
what they said they didn't do!!  <g>

-----Original Message-----
From: Colin Williams [mailto:Williamsc@technocrats.co.uk]
Sent: Friday, August 27, 1999 1:18 AM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: Reuse deleted records (was SQL vs DDS)


Why would you want to recover deleted records. Your system should always
have an audit trail for anything that you delete, so you should be able
to re-key where necessary!

>>> -----Original Message-----
>>> From: Roger Boucher [mailto:RBoucher@stanpac.com]
>>> Sent: Thursday, August 26, 1999 5:23 PM
>>> To: 'MIDRANGE-L@midrange.com'
>>> Subject: Reuse deleted records (was SQL vs DDS)
>>> 
>>> 
>>> 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
>>> +---
>>> 
+---
| 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
+---