-20100 AN ERROR OCCURRED WHEN BINDING A TRIGGERED SQL STATEMENT. INFORMATION RETURNED: SECTION NUMBER : section-number SQLCODE sqlerror, SQLSTATE sqlstate, AND MESSAGE TOKENS token-list
Explanation
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.
SQLSTATE
56059
