Reg. Triggers in DB2 8.2
IT & Infrastructure
1
Posts
1
Posters
1
Views
1
Watching
-
Hi friends, Please help me for triggers. Thats is when i insert or update on one table it should get updated in another table. I am using the following query. Its created without any errors. But not updating the fields. create trigger trig1 after update of stn on stn referencing old as o new as n for each row mode db2sql when (exists(select stn_id from stn where stn_id = o.stn_id))begin atomic update oper set oper_stn_id = n.stn_id where oper_stn_id = o.stn_id; end Likewise also, My date field in a table should automatically changed to system date daily by trigger. Please help me for these two. Thanks in Advance, Best Regards,
Prya