RE: Reuse deleted records (was SQL vs DDS)

In a prior life, I had to deal with mistakenly deleted records with
home-grown utilities.  When we went to the S/38 I pleased to use journaling,
but was turned down because of the perceived system hit.  Nowadays, I work
as hard as I can to include auditing, error recover and security in the
design, rather than try to glue on a patch after the design is in
production.

I would strongly recommend journaling.  Many non-AS/400 shops can't turn
journaling off!  This is another argument in favour of using SQL over DDS.
If you use SQL to set up your collections (libraries) then commitment
control is turned on for tables (files) created in those collections.  Using
DDS, you'd need to manually set it up.

Buck Calabro
Aptis; Albany, NY
mailto:Buck.Calabro@aptissoftware.com

> -----Original Message-----
> From: Roger Boucher 
> Sent: Thursday, August 26, 1999 12: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?
> 
> 
+---
| 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
+---