RE: Triggers or Journals?

["Graap, Ken" <keg@xxxxxxxxxxxxxxxxxx>]

>IBM is going gung ho with triggers for editing on their files.

I wonder why there isn't a broader use of DB Referential Constraints in
DB2/400? Moving editing logic into the database and out of application code
sure seems to make sense. Is anyone moving their DB editing logic into
DB2/400 via DB Constraints?

Kenneth

****************************************
Kenneth E. Graap
IBM Certified Specialist 
AS/400e Professional System Administrator
NW Natural (Gas Services)
keg@nwnatural.com
Phone: 503-226-4211 x5537
FAX:    603-849-0591
****************************************


-----Original Message-----
From: rob@dekko.com [mailto:rob@dekko.com]
Sent: Thursday, March 29, 2001 7:35 AM
To: MIDRANGE-L@midrange.com
Subject: RE: Triggers or Journals?



IBM is going gung ho with triggers for editing on their files.  New files
from IBM have been known to have triggers on them for editing purposes.
Makes sense to me.  When you can maintain a file with utilities, programs,
web, client server, ... why copy the editing routines all over the place?

Rob Berendt

==================
Remember the Cole!

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