Re: Reuse deleted records (was SQL vs DDS)

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

Colin Williams wrote:
> 
> 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!

RE-KEY!?

I hope you're kidding. If not, then I think I know the reason that
Windows is such a hit! 

<VBG... i think>

Journals give you the audit trail AND allow you to undelete or redo.

-- 
===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"
+---
| 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
+---