Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 02 Jul 2004 @ 12:36:29 GMT

  <Prev Next>   <<First <Prev

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 these.  

  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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023