logo  
Google
 

DB2 SQL-Error: -696

SQLState: 42898

Short Description: THE DEFINITION OF TRIGGER INCLUDES AN INVALID USE OF CORRELATION NAME OR TRANSITION TABLE NAME REASON CODE

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 executed. The trigger was not created. Programmer response: Remove the invalid correlation name or transition table name along with the preceding keyword.

 <-  BACK TO INDEX