Start of change

-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

End of change