4.1 SQLSTATE output format
SQLSTATE is one of the return codes HADB returns after executing an SQL statement. An SQLSTATE value consists of five digits, where the first two digits indicate a class and the remaining three digits a subclass.
The following table lists the SQLSTATE classes.
|
Class |
Meaning |
|---|---|
|
00 |
Normal termination |
|
01 |
Warning |
|
02 |
No data satisfies the retrieval condition. |
|
07 |
Dynamic SQL statement errors |
|
08 |
HADB server connection errors |
|
21 |
Cardinality violation |
|
22 |
Data exception |
|
23 |
Integrity constraint violation |
|
24 |
Cursor status errors |
|
40 |
Errors resulting in transaction rollback |
|
42 |
Syntax errors or access rule violation |
|
51 |
SQL function-specific errors (errors caused by specific nonstandard SQL functions) |
|
52 |
Errors due to an execution environment status that prohibits SQL statement execution |
|
53 |
Errors due to a system resource status that prohibits SQL statement execution (such as a memory or resource shortage) |
|
54 |
Error caused by application program settings, processing, attributes, or statuses |
|
56 |
Limit- or value-related errors |
|
5B |
User-requested cancellation |
|
5C |
Other system errors |
|
5D |
SQLSTATE cannot be obtained. |
|
R2 |
JDBC driver-related errors |