-696   THE DEFINITION OF TRIGGER trigger-name INCLUDES AN INVALID USE OF CORRELATION NAME OR TRANSITION TABLE NAME name. REASON CODE=reason-code

Explanation

The trigger definition included an invalid use of name
trigger-name
The trigger that encountered the error
name
The transition variable correlation name or transition table name
reason-code
A reason-code indicating the specific problem as follows:
  1. NEW correlation name and NEW_TABLE name are not allowed in a DELETE trigger.
  2. OLD correlation name and OLD_TABLE name are not allowed in an INSERT trigger.
  3. OLD_TABLE name and NEW_TABLE name are not allowed in a BEFORE trigger.

System action

The statement cannot be processed. The trigger was not created.

Programmer response

Remove the invalid correlation name or transition table name along with the preceding keyword.

SQLSTATE

42898