Archives of the TeradataForum

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

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

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.

AK

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