Archives of the TeradataForum

Message Posted: Thu, 03 Aug 2000 @ 16:37:39 GMT

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

The syntax for row triggers has ambiguous semantics - see DR45997 in the V2R3.0.3 Release Summary (B035-1068-039K). In V2R3.0.3 and later, attempting to create this trigger would fail with code 5529. From the V2R4 messages manual, the corresponding message is:

A triggered statement inside a row trigger can not refer to a table that is being changed by the row trigger.

Rewrite it as a statement trigger and it will work:

     REPLACE TRIGGER TEST.XXXXX ENABLED
     BEFORE DELETE ON TEST.TABLEA
       REFERENCING OLD_TABLE AS DELETEROWS
       FOR EACH STATEMENT
     (DELETE FROM TEST.TABLEB WHERE COLB IN (SELECT COLB FROM DELETEROWS););

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