Conditionally firing the trigger is not supported yet if i remember
correct, but you can carry the IF condition into the where
create trigger S.TRIGNAME
after update of COL1 on S.T1
referencing NEW as N OLD as O
for each row mode db2sql
insert into S.T2(COLN)
where (not N.COL1=O.COL1);
This will insert nothing if the condition
(not N.COL1=O.COL1) evaluates to FALSE.
[may need to check for NULLs separately if cols are nullable in these
It will feel like trigger did not fire.
At 10:03 PM 8/11/2005, you wrote:
Can any one help? I would like to use the IF control statement in row
trigger. I do not find any detail related to it in manual and on
have Idea about it please post me a example.
Waiting for your reply.
Thanks and Regrds,