15.00 - 5423 This trigger contains an invalid REFERENCING clause. - Teradata Database

Teradata Database Messages

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

5423 This trigger contains an invalid REFERENCING clause.


The REFERENCING clause contains one of the following errors: 1. Old and/or New are used in an improper combination with Old_Table and/or New_Table. 2. A statement trigger used the OLD or NEW correlation name identifier. 3. A row trigger used the OLD_TABLE or NEW_TABLE correlation name identifier. 4. The name specified in this clause was not unique within the trigger. * DR87420-TS185009-01 * 5. Disallow cascaded row triggers with transition table references. 6. A field without any reference is invalid when OLD_NEW_TABLE correlation name is specified. Example of an invalid statement in a trigger body: sel * from old_new_tab;

Generated By:


For Whom:

End User.


Redefine the trigger with a correct REFERENCING clause.