Archives of the TeradataForum

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

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

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