DB2 SQL-Error: -719
SQLState: 09000
Short Description: C AN ERROR OCCURRED IN A TRIGGERED SQL STATEMENT IN INFORMATION RETURNED SQLCODE SQLSTATE MESSAGE TOKENS SECTION NUMBER
During execution of an UPDATE, INSERT, or DELETE statement, a trigger was activated. One of the triggered SQL statements received an SQL error condition. trigger-name The trigger that was activated when the error occurred. 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 by the activated trigger. sqlstate The corresponding SQLSTATE for the SQLCODE received by the activated trigger. token-list The list of tokens from the original SQL error. This list might be truncated.System action: The trigger and the original INSERT, UPDATE, or DELETE statement cannot be processed. The triggering table is unchanged. Programmer response: Contact your Database Administrator to determine why the trigger named in the message received the error. System programmer response: Use the trigger name and section number to determine the failing SQL statement. If the trigger definition is available, use the section number to determine the failing statement. Alternatively, the failing statement can be retrieved from the SYSIBM.SYSPACKSTMT catalog table: SELECT TEXT, SEQNO FROM SYSIBM.SYSPACKSTMT WHERE COLLID = Â’schema-nameÂ’ AND NAME = Â’trigger-nameÂ’ AND SECTNO = section-number ORDER BY SEQNO Refer to the explanation of the reported SQLCODE. Follow the action suggested by that SQLCODE.