SQLState
The SQLState code describes the status of the SQL statement submitted to Teradata Database for execution. The next table lists the SQLState five-character codes that can be returned.
|
SQLState |
Error |
|
01000 |
General warning |
|
01004 |
Fractional truncation |
|
01S03 |
Cursor operation conflict |
|
07001 |
COUNT field incorrect |
|
22003 |
Non-character and non-binary data sent in pieces |
|
22005 |
Invalid character value for cast specification |
|
22008 |
Invalid datetime format |
|
37000 |
Syntax error or access violation |
|
70100 |
Server declined cancel request |
|
HY009 |
Invalid use of null pointer |
|
S0001 |
Base table or view already exists |
|
S0002 |
Base table or view not found |
|
S0011 |
Index already exists |
|
S0012 |
Index not found |
|
S0021 |
Column already exists |
|
S0022 |
Column not found |
|
S1000 |
General database error |
|
S1001 |
Memory allocation error |
|
S1002 |
Invalid descriptor index |
|
S1003 |
Invalid application buffer type |
|
S1004 |
Invalid SQL data type |
|
S1008 |
Operation canceled |
|
S1009 |
Invalid attribute value |
|
S1010 |
Associated statement is not prepared |
|
S1010 |
Function sequence error |
|
S1011 |
Attribute cannot be set now |
|
S1012 |
Invalid transaction operation code |
|
S1090 |
Invalid string or buffer length |
|
S1091 |
Invalid descriptor field identifier |
|
S1092 |
Invalid attribute/option identifier |
|
S1096 |
Invalid information type |
|
S1097 |
Column type out of range |
|
S1098 |
Scope type out of range |
|
S1099 |
Nullable type out of range |
|
S1100 |
Uniqueness option type out of range |
|
S1101 |
Accuracy option type out of range |
|
S1103 |
Invalid retrieval code |
|
S1104 |
Invalid precision or scale value |
|
S1105 |
Invalid parameter type |
|
S1106 |
Fetch type out of range |
|
S1107 |
Row value out of range |
|
S1109 |
Invalid cursor position |
|
S1110 |
Invalid driver completion |
|
S1111 |
Invalid bookmark value |
|
S1C00 |
Optional feature not implemented |
|
S1T00 |
Timeout expired |