Teradata Database Message 5396 - 5396 - Analytics Database - Teradata Vantage

Message

An OLD_TABLE or NEW_TABLE alias was referenced without using a subquery.

Explanation

OLD_TABLE and NEW_TABLE aliases refer to set of rows so they must be referenced as a table with a FROM clause.

Generated By

Parser.

For Whom

User.

Notes

None

Remedy

In the triggered statements and the WHEN clause use a FROM clause to refer to the OLD_TABLE and NEW_TABLE aliases.