Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 May 2002 @ 18:02:36 GMT


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


Subj:   Trigger Update Count of the Table..
 
From:   Dev a p

Hi,

We have Activity log table, When job finish it will insert a row with how many rows inserted with table name.

****** Activty_log*********
Table Inserted Total_row
tab1 100 ?????

Is it possible to create trigger(After Insert) that will take that table name and query with (Select * from Tab1) and update the row.

Thanks,



     
  <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