SQL Reference

Viewing the SQLCA Interactively

To display the SQLCA after each command you use in the command line processor, use the command db2 -a. The SQLCA is then provided as part of the output for subsequent commands. The SQLCA is also dumped in the db2diag.log file.

Related Information:

• Appendix B, SQL Communications (SQLCA)
• SQLCA Field Descriptions
• Order of Error Reporting
• DB2 Enterprise - Extended Edition Usage of the SQLCA

¹¹⁰

The field names shown are those present in an SQLCA that is obtained via an INCLUDE statement.