Table 8-41 Classes of SQLSTATE returned by HiRDB and their explanations
Class | Explanation | Reference |
---|---|---|
00 | Terminated normally. | Table 8-42 |
01 | A warning was issued. | Table 8-43 |
02 | There is no data. | Table 8-44 |
40 | The transaction rolled back. | Table 8-45 |
R0 | Terminated abnormally. | Table 8-46 |
R2 | There is no data. | Table 8-47 |
Table 8-42 SQLSTATE class 00
SQLSTATE | Explanation | SQLCODE | SQLWARN |
---|---|---|---|
00000 | Terminated normally. | 0 | None |
Table 8-43 SQLSTATE class 01
SQLSTATE | Explanation | SQLCODE | SQLWARN |
---|---|---|---|
01000 | Terminated normally with a warning. | 0 | SQLWARN0='W' |
0100C | A dynamic result set was returned. | 120 | SQLWARN0='W' |
0100D | Another result set wass returned. | 121 | SQLWARN0='W' |
0100E | An attempt was made to return too many result sets. | 120 | SQLWARN0='W' |
01R00 | Terminated normally with a warning. | Positive number other than 100 or 110 | SQLWARN0=space-character or 'W' |
Table 8-44 SQLSTATE class 02
SQLSTATE | Explanation | SQLCODE | SQLWARN |
---|---|---|---|
02000 | There is no data. | 100 | None |
02001 | There is no other result set to be returned. | 100 | None |
Table 8-45 SQLSTATE class 40
SQLSTATE | Explanation | SQLCODE | SQLWARN |
---|---|---|---|
40000 | The SQL statement terminated with an error because the transaction rolled back. For details, refer to the error message corresponding to the SQLCODE. | -1 to -999 | SQLWARN0='W' SQLWARN6='W' |
Table 8-46 SQLSTATE class R0
SQLSTATE | Explanation | SQLCODE | SQLWARN |
---|---|---|---|
R0000 | Terminated abnormally. | SQLCODE<0 | SQLWARN6=' ' |
Table 8-47 SQLSTATE class R2
SQLSTATE | Explanation | SQLCODE | SQLWARN |
---|---|---|---|
R2000 | During a list search, a row that existed at the time of list creation was not returned. | 110 | None |