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

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5423 This trigger contains an invalid REFERENCING clause.

Explanation:

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:

Resolver

For Whom:

End User.

Remedy:

Redefine the trigger with a correct REFERENCING clause.