Teradata Database Message 5429 - 5429 - Analytics Database - Teradata Vantage

Message

A triggered action statement contained an invalid reference.

Explanation

A triggered action statement either: 1. Referred to an Old or New correlation name as a table. 2. Referred to an Old_Table or New_Table table as a row. 3. Referred to an Old or New correlation name as a row and used a range constraint to scan rows. 4. Referred to OLD_NEW_TABLE correlation in a row trigger. 5. OLD_NEW_TABLE referencing clause can only be used in an UPDATE trigger. 6. A field reference in a trigger body cannot directly use the OLD_NEW_TABLE correlation name. It has to use the OLD_NEW_TABLE row alias name.

Generated By

RES modules.

For Whom

End user.

Notes

None

Remedy

Correct the triggered action statement.