Sorry in advance if this is a stupid or newbie question, but I have
scoured all info source and cannot find the answer...
I want to implement a trigger (in db2 8.1) that will fire on the update
of ANY column or permutation of columns in that table. For example,
create trigger <trig name>
after update of <col1> OR <col2> OR .. <colN> on <table name>
etc.
It does NOT appear that there is a way to do this? Have you ever faced
this or a similar situation before? Any advice on how to do this?
Thanks in advance for any feedback.
ak_tiredofspam@yahoo.com - 24 Dec 2004 03:31 GMT
have you tried
AFTER UPDATE ON <YourTable>?
ak_tiredofspam@yahoo.com - 24 Dec 2004 03:31 GMT
have you tried
AFTER UPDATE ON <YourTable>?
ak_tiredofspam@yahoo.com - 24 Dec 2004 03:31 GMT
have you tried
AFTER UPDATE ON <YourTable>?
ak_tiredofspam@yahoo.com - 24 Dec 2004 03:31 GMT
have you tried
AFTER UPDATE ON <YourTable>?
Re_endian_miss@yahoo.com - 29 Dec 2004 15:44 GMT
This appears to work exactly as needed!
Thank you!
> have you tried
> AFTER UPDATE ON <YourTable>?