Re: Question on Insert Trigger

From: Serge Rielau <>
Date: Sat, 08 Mar 2008 10:27:28 -0500
Message-ID: <>

DA Morgan wrote:
> Serge Rielau wrote:

>> Hypothetically: If the business rule depends on data in some table or 
>> a package variable (any sort of "external to the row" data), can it 
>> still be written as a constraint?
>> Presumably VPD cannot "ignore" input data, so it isn't applicable here 
>> I guess.

> My initial answer is no but business rules, as we define them are
> not the kind of thing one would write to a package variable. If it
> is variable it is not a rule.

"We"? Is ACE a royal title?
Variables come in shades of grey.
If it changes once a year it's still a variable. Anyway not worth fighting about, it was after all hypothetical. I made my proposal and it's up the OP to consider it.


Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Sat Mar 08 2008 - 09:27:28 CST

Original text of this message