logo  
Google
 

DB2 SQL-Error: -20100

SQLState: 56059

Short Description: AN ERROR OCCURRED WHEN BINDING A TRIGGERED SQL STATEMENT INFORMATION RETURNED SECTION NUMBER SQLCODE SQLSTATE AND MESSAGE TOKENS

During execution of a CREATE TRIGGER statement, the SQL statements specified in the triggered action are bound into a trigger package. During that processing, an error was discovered in one of those statements. section-number The section number associated with the failing triggered SQL statement. For triggers that contain a WHEN clause, the WHEN clause is section number one. The triggered SQL statements are numbered sequentially, beginning with section number two. This is true for triggers with or without a WHEN clause. sqlcode The SQLCODE received when binding the statement. sqlstate The corresponding SQLSTATE for the SQLCODE received when binding the statement. token-list The list of tokens from the original SQL error. This list might be truncated.System action: The CREATE TRIGGER statement was not processed. The trigger and the trigger package were not created. Programmer response: Use the section number determine the failing triggered SQL statement. Refer to the explanation of the reported SQLCODE. Follow the action suggested by that message.

 <-  BACK TO INDEX