Using SQLCODE

The following table lists the values SQLCODE can contain:

**Table 8-1: SQLCODE return values**
Value	Meaning
0	No warnings or errors occurred.
<0	An error occurred. The SQLCA variables contain useful information for diagnosing the error.
100	No rows returned from last statement, although the statement executed successfully. This condition is useful for driving a loop that fetches rows from a cursor. When SQLCODE becomes 100, the loop and all rows that have been fetched end. This technique is illustrated in Chapter 6, “Using Transact-SQL Statements.”