Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 23 Sep 2002 @ 15:45:13 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Update Trigger
From:   Arun Katti

Is there a way to update audit information on the same table that is being updated? For example, if I update a row on admin.ProdTabStage, I want to be able to update audit fields (like update time, user and program etc.) through a trigger.

I can do it easily in Oracle, but have not figured out how to do it in Teradata.


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