Teradata Database Message 5423 - 5423 - Analytics Database - Teradata Vantage

Message

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. 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.

Notes

None

Remedy

Redefine the trigger with a correct REFERENCING clause.