Re: How to avoid 2nd trigger

What about using delete/insert instead of update? 

Lennart wrote:
>> I am currently developing trigger based screen edit fro several 100
screens
>> in COBOL/CICS
>[quoted text clipped - 81 lines]
>> I don't have MERGE STATEMENT, and I don't have INSTEAD OF TRIGGERS.
>> Any Ideas?
>
>I don't think you can avoid that since triggers are fired either after
>update or insert. Merge wont do you any good and instead of triggers
>only works for views.
>
>Is there some specific reason that you don't want to use check
>constraints and foreign keys for this purpose?
>
>/Lennart

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