Re: Question on Insert Trigger
Date: Fri, 07 Mar 2008 08:09:58 -0500
> Thanks to all. not null in my code was just an example. My filtering
> logic is lot more complex and cannot implemented through a costraint.
> What I am asking is there a way to do filtering in the trigger if it
> cannot be done using EXCEPTIONS INTO statement.
Can you squeeze in a view? I.e. rename the table, create select-* view over the renamed table using the original table name. Then create an INSTEAD OF TRIGGER on the view to intercept the rows you don't like. You can ignore them, save them away, or patch them up.
-- Serge Rielau DB2 Solutions Development IBM Toronto LabReceived on Fri Mar 07 2008 - 07:09:58 CST