Re: Question on Insert Trigger
From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Sat, 08 Mar 2008 10:27:28 -0500
Message-ID: <63fpjbF27h5kmU1@mid.individual.net>
> 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.
Date: Sat, 08 Mar 2008 10:27:28 -0500
Message-ID: <63fpjbF27h5kmU1@mid.individual.net>
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.
Cheers
Serge
-- Serge Rielau DB2 Solutions Development IBM Toronto LabReceived on Sat Mar 08 2008 - 09:27:28 CST