Archives of the TeradataForum

Message Posted: Fri, 15 Jun 2012 @ 17:13:07 GMT

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

The trigger body is restricted to certain "action statements"; a cursor is not allowed. See the DDL Detailed Topics manual section for CREATE TRIGGER.

It looks like you are trying to make a STATEMENT trigger behave as a ROW trigger. A STATEMENT trigger can do INSERT/SELECT from OLD_TABLE. A ROW trigger can do single-row INSERT based on OLD ROW.

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