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.