Administrator Guide : Basic Troubleshooting and Tracing : How to Access Error Information : Examine the SQLCA Fields
 
Share this page                  
Examine the SQLCA Fields
Information about errors and warnings is stored in the SQL Communications Area (SQLCA). You can access the Generic Error Codes, DBMS return code, Gateway or DBMS message text, and SQLWARN5 by examining the contents of the SQLCA fields listed in the following table:
Field
Contents
SQLCA.SQLCODE
Generic error codes.
SQLCA.SQLERRD [0]
DBMS status codes.
SQLCA.SQLERRM
First 70 characters of the gateway error message text or the DBMS system error message text.
SQLCA.SQLWARN.SQLWARN5
If set to W, the statement is not supported by the gateway, or a parameter in the statement was recognized but not supported.