Using CA InterTest for CICS with DB2 and SQL/DS Programs › SQL Return Codes

SQL Return Codes

The SQL communication area (SQLCA) is a structure of variables that is updated after each SQL statement executes. An application program that contains executable SQL statements must provide an SQLCA to let DB2 communicate with the program.

Note: The IBM manual DB2 Application Programmer Guide provides information on the SQLCA.

When DB2 processes an SQL statement, it places a return code in the SQLCODE field of the SQLCA that indicates the success or failure of the SQL request:

• If the return code is zero, the SQL request was processed. DB2 did not detect an error or an exceptional condition.
• If the return code is a negative number, DB2 detected an error.
• If the return code is a positive number, DB2 detected an exceptional but valid condition.

Note: Sometimes a zero return code does not indicate a successful execution. You should always check the SQLWARN field to ensure that it is blank, which indicates successful execution. If the field is not blank, a warning condition exists. Check the other warning indicators to determine the specific condition.

Example

If a value was truncated the SQLCODE will be zero, but the SQLWARN1 field indicates truncation.

Because the SQLCA contains valuable diagnostic information, it is a good idea to check its contents after each SQL request.