SQL Reference

Order of Error Reporting

The order of error reporting is as follows:

1. Severe error conditions are always reported. When a severe error is reported, there are no additions to the SQLCA.
2. If no severe error occurs, a deadlock error takes precedence over other errors.
3. For all other errors, the SQLCA for the first negative SQL code is returned.
4. If no negative SQL codes are detected, the SQLCA for the first warning (that is, positive SQL code) is returned.

   For DB2 Enterprise - Extended Edition, the exception to this rule occurs if a data manipulation operation is issued on a table that is empty on one partition, but has data on other nodes. The SQLCODE +100 is only returned to the application if agents from all partitions return SQL0100W, either because the table is empty on all partitions or there are no more rows that satisfy the WHERE clause in an UPDATE statement.

Related Information:

• Appendix B, SQL Communications (SQLCA)
• Viewing the SQLCA Interactively
• SQLCA Field Descriptions
• DB2 Enterprise - Extended Edition Usage of the SQLCA