Re: Triggers or Journals?

I started to use the built-in referential constraints a while back.  The
problem I ran into was that I had to design my DB views around the
requirements for the constraint rather than my programming requirements -
after talking to IBM about it I decided it was too intrusive and moved my
referential constraints to triggers.  This was quite a while ago so I don't
really remember the details.  I was/am on v4r3.

Regards
Rick
----- Original Message -----
From: "Graap, Ken" <keg@exchange.gasco.com>
To: <MIDRANGE-L@midrange.com>
Sent: Thursday, March 29, 2001 11:09 AM
Subject: RE: Triggers or Journals?


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

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