Re: How to avoid 2nd trigger

Thank's again Lennart.
I will test this  constrain.   
Lennart wrote:
>[...]
>> ALTER TABLE EMP_SCREEN_EDIT ADD CONSTRAINT <NAME>
>>     CHECK (  NOT ( JOB IN ('manager', 'superviser')) OR ( COMM = 0 AND
>> EDLEVEL > 10 ) )
>
>Perhaps I should have elaborated a bit more about this.
>
>A => B is the same as NOT A OR B. In your case:
>
>JOB IN ('manager', 'superviser') => ( COMM = 0 AND EDLEVEL > 10 )
>
>can be rewritten as
>
>(NOT JOB IN ('manager', 'superviser')) OR (COMM = 0 AND EDLEVEL > 10 )
>
>/Lennart

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200807/1