Archives of the TeradataForum
Message Posted: Fri, 02 Jul 2004 @ 12:36:29 GMT
| Subj: || || Re: Question relating to triggers |
| From: || || Victor Sokovin |
| ||As you have indicated, in V2r5.1 triggers on multiple columns are not supported, and this is indicated by the script that tests for
| ||So the question, is, how would I get a trigger to fire on an update to a row where multiple columns are updated at the same time, without
having to change the application. Would a statement trigger rather than a row trigger be the way to go?|| |
I am afraid I don't have much experience with specifically update triggers as I am usually working on data warehousing projects, where
updates are not that common. I would just suggest to look at the application logic and check whether a statement trigger can substitute the row
triggers. Statement triggers in general cannot be as detailed as the row level ones but perhaps they are enough for your purpose in this
particular case? The only way to find out is to try them.
Alternatively (I realize that this might be a kind of an application change you are trying to avoid), you could perhaps take away the rows for
update into a temp table, update them there or modify them on the fly via SQL and insert them back into the original table. Then you could fire
insert triggers instead of update triggers. Just a suggestion.