Re: Question on Insert Trigger
Date: Sat, 08 Mar 2008 23:55:52 -0500
DA Morgan wrote:
> But I am wondering ... would you use a package variable, when
> you get them into DB2, to enforce a business rule?
Ah why not? Depends on your rule.
E.g. if I have a rule that says: Ignore all input provided by user DAMORGAN that seems like a sensitive thing to do. Rules can be user dependent, can they not? You like to point out that certain products fail to provide BEFORE TRIGGERs. Aren't before triggers used to enforce business rules? By claiming that constraints suffice you say BEFORE TRIGGERs are not needed and you bite your own proverbial tail. BEFORE TRIGGERs are used where CHECK CONSTRAINTs fail, such as looking at data in different tables, or looking up variable content.
> With respect to your other question:
So the answer is no, you are an "I", not a "We".
-- Serge Rielau DB2 Solutions Development IBM Toronto LabReceived on Sat Mar 08 2008 - 22:55:52 CST