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

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
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.