ESL Database Services (EDS) returns SQLSTATE values, which are based on the ODBC SQLSTATE values. EDSError returns these values, which are always strings that contain five characters. The this section lists SQLSTATE values that a driver can return for EDSError.
The character string value returned for a SQLSTATE consists of a two-character class value followed by a three-character subclass value. ODBC uses class and subclass values as defined by the ANSI SQL2 standard.
A class value of ‘01’ indicates a warning and is accompanied by a return code of EDS_SUCCESS_WITH_INFO.
Class values other than ‘01’, except for the class ‘IM’, indicate an error and are accompanied by a return code of EDS_ERROR.
The class ‘IM’ is specific to warnings and errors that derive from the implementation of ODBC itself.
The subclass value ‘000’ in any class is for implementation-defined conditions within the given class.
SQL STATE |
Description |
Can be returned from |
0000 |
Success |
EDSBrowseConnect EDSError |
01002 |
Disconnect error. |
EDSDisconnect |
01004 |
Data truncated. |
|
01006 |
Privilege not revoked. |
EDSExecDirect EDSExecute |
01S00 |
Invalid connection string attribute. |
EDSBrowseConnect EDSDriverConnect |
07001 |
Wrong number of parameters. |
EDSExecDirect EDSExecute |
07006 |
Restricted data type attribute violation. |
EDSExtendedFetch EDSFetch EDSGetData EDSSetParam |
08001 |
Unable to connect to data source. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
08002 |
Connection in use. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
08003 |
Connection not open. |
EDSAllocStmt EDSDisconnect EDSGetConnectOption EDSGetInfo EDSNativeSql EDSSetConnectOption EDSTransact |
08004 |
Data source rejected establishment of connection. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
08007 |
Connection failure during transaction. |
EDSTransact |
21S02 |
Degree of derived table does not match column list. |
EDSExecDirect EDSPrepare |
22001 |
String data right truncation. |
EDSExecDirect EDSExecute EDSPutData |
22003 |
Numeric value out of range. |
EDSExecDirect EDSExecute EDSExtendedFetch EDSFetch EDSGetData EDSGetInfo EDSPutData |
22005 |
Error in assignment. |
EDSExecDirect EDSExecute EDSPrepare |
22008 |
Datetime field overflow. |
EDSExecDirect EDSExecute EDSPutData |
22012 |
Division by zero. |
EDSExecDirect EDSExecute EDSExtendedFetch EDSFetch |
22026 |
String data, length mismatch. |
EDSExecDirect EDSPutData |
23000 |
Integrity constraint violation. |
EDSExecDirect EDSExecute |
25000 |
Invalid transaction state. |
EDSDisconnect |
28000 |
Invalid authorization specification. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
34000 |
Invalid cursor name. |
EDSExecDirect EDSPrepare EDSSetCursorName |
37000 |
Syntax error or access violation. |
EDSExecDirect EDSNativeSql EDSPrepare |
3C000 |
Duplicate cursor name. |
EDSSetCursorName |
40001 |
Serialization failure. |
EDSExecDirect EDSExecute EDSExtendedFetch EDSFetch |
70100 |
Operation aborted. |
EDSCancel |
IM001 |
Driver does not support this function. |
All ODBC functions except: EDSAllocConnect EDSAllocEnv EDSDataSources EDSError EDSFreeConnect EDSFreeEnv EDSGetFunctions |
IM002 |
Data source name not found and no default driver specified. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
IM003 |
Driver specified by data source name could not be loaded. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
IM004 |
Driver’s EDSAllocEnv failed. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
IM005 |
Driver’s EDSAllocConnect failed. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
IM006 |
Driver’s EDSSetConnectOption failed. |
EDSBrowseConnect EDSConnect EDSDriverConnect |
IM007 |
No data source specified; dialog prohibited |
EDSDriverConnect |
IM008 |
Dialog failed. |
EDSDriverConnect |
IM009 |
Unable to load translation DLL. |
EDSBrowseConnect EDSConnect EDSDriverConnect EDSSetConnectOption |
S0001 |
Base table or view already exists. |
EDSExecDirect EDSPrepare |
S0002 |
Base table not found. |
EDSExecDirect EDSPrepare |
S0011 |
Index already exists. |
EDSExecDirect EDSPrepare |
S0012 |
Index not found. |
EDSExecDirect EDSPrepare |
S0021 |
Column already exists. |
EDSExecDirect EDSExecute EDSPrepare |
S0022 |
Column not found. |
EDSExecDirect EDSPrepare |
S1000 |
General error. |
All ODBC functions except: EDSAllocEnv EDSError |
S1001 |
Memory allocation failure. |
All ODBC functions except: EDSError EDSFreeConnect EDSFreeEnv |
S1002 |
Invalid column number. |
EDSBindCol EDSColAttributes EDSDescribeCol EDSExtendedFetch EDSFetch EDSGetData |
S1003 |
Program type out of range. |
EDSBindCol EDSGetData EDSSetParam |
S1004 |
SQL data type out of range. |
EDSGetTypeInfo EDSSetParam |
S1008 |
Operation cancelled. |
All ODBC functions that can be processed asynchronously: EDSColAttributes EDSColumnPrivileges EDSColumns EDSDescribeCol EDSDescribeParam EDSExecDirect EDSExecute EDSExtendedFetch EDSFetch EDSForeignKeys EDSGetData EDSGetTypeInfo EDSMoreResults EDSNumParams EDSNumResultCols EDSParamData EDSPrepare EDSPrimaryKeys EDSProcedureColumns EDSProcedures EDSPutData EDSSetPos EDSSetScrollOptions EDSSpecialColumns EDSStatistics EDSTablePrivileges EDSTables |
S1010 |
Function sequence error. |
EDSBindCol EDSColAttributes EDSColumnPrivileges EDSColumns EDSDescribeCol EDSDescribeParam EDSDisconnect EDSExecDirect EDSExecute EDSExtendedFetch EDSFetch EDSForeignKeys EDSFreeConnect EDSFreeEnv EDSFreeStmt EDSGetConnectOption EDSGetCursorName EDSGetData EDSGetFunctions EDSGetInfo EDSGetStmtOption EDSGetTypeInfo EDSMoreResults EDSNumParams EDSNumResultCols EDSParamData EDSParamOptions EDSPrepare |
S1012 |
Invalid transaction operation code specified. |
EDSTransact |
S1015 |
No cursor name available. |
EDSGetCursorName |
S1091 |
Descriptor type out of range. |
EDSColAttributes |
S1092 |
Option type out of range. |
EDSFreeStmt EDSGetConnectOption EDSGetStmtOption EDSSetConnectOption EDSSetStmtOption |
S1093 |
Invalid parameter number. |
EDSDescribeParam EDSSetParam |
S1094 |
Invalid scale value. |
EDSSetParam |
S1095 |
Function type out of range. |
EDSGetFunctions |
S1096 |
Information type out of range. |
EDSGetInfo |
S1097 |
Column type out of range. |
EDSSpecialColumns |
S1098 |
Scope type out of range. |
EDSSpecialColumns |
S1099 |
Nullable type out of range. |
EDSSpecialColumns |
S1100 |
Uniqueness option type out of range. |
EDSStatistics |
S1101 |
Accuracy option type out of range. |
EDSStatistics |
S1102 |
Table type out of range. |
EDSTables |
S1103 |
Direction option out of range. |
EDSDataSources |
S1106 |
Fetch type out of range. |
EDSExtendedFetch |
S1107 |
Row value out of range. |
EDSExtendedFetch EDSParamOptions EDSSetPos EDSSetScrollOptions |
S1108 |
Concurrency option out of range |
EDSSetScrollOptions |
S1109 |
Invalid cursor position; no keyset defined. |
EDSSetPos |
S1110 |
Invalid driver completion. |
EDSDriverConnect |
S1DE0 |
No data at execution values pending |
EDSParamData. EDSPutData |
S1T00 |
Timeout expired. |
EDSBrowseConnect EDSColAttributes EDSColumnPrivileges EDSColumns EDSConnect EDSDescribeCol EDSDescribeParam EDSDriverConnect EDSExecDirect EDSExecute EDSExtendedFetch EDSFetch EDSForeignKeys EDSGetData EDSGetInfo EDSGetTypeInfo EDSMoreResults EDSNumParams EDSNumResultCols EDSParamData EDSPrepare EDSPrimaryKeys EDSProcedureColumns EDSProcedures EDSPutData EDSSetPos EDSSpecialColumns EDSStatistics EDSTablePrivileges EDSTables |
