SQL Reference

DB2 Enterprise - Extended Edition Usage of the SQLCA

In DB2 Universal Database Enterprise - Extended Edition, one SQL statement may be executed by a number of agents on different partitions, and each agent may return a different SQLCA for different errors or warnings. The coordinator agent also has its own SQLCA.

To provide a consistent view for applications, all SQLCA values are merged into one structure and SQLCA fields indicate global counts. For example:

• For all errors and warnings, the sqlwarn field contains the warning flags received from all agents.
• Values in the sqlerrd fields indicating row counts are accumulations from all agents.

Note that SQLSTATE 09000 may not be returned in all cases of an error occurring while processing a triggered SQL statement.

Related Information:

• Appendix B, SQL Communications (SQLCA)
• Viewing the SQLCA Interactively
• SQLCA Field Descriptions
• Order of Error Reporting