Table 27. SQLState messages reported by CLI
| SQLSTATE | CLI function name | Description | Explanation |
|---|---|---|---|
| 01000 | SQLAllocHandle | Warning. | Informational message. (Function returns SQL_SUCCESS_WITH_INFO.) |
| 01000 | SQLFreeHandle | Warning. | Informational message. (Function returns SQL_SUCCESS_WITH_INFO.) |
| 01002 | SQLDisconnect | Disconnect error. | An error occurred during the disconnect. However, the disconnect succeeded. (Function returns SQL_SUCCESS_WITH_INFO.) |
| 01004 | SQLDescribeCol | Data truncated. | The column name returned in the argument ColumnName was longer than the value specified in the argument BufferLength. The argument NameLengthPtr contains the length of the full column name. (Function returns SQL_SUCCESS_WITH_INFO.) |
| 01004 | SQLFetch | Data truncated. | The data returned for one or more columns was truncated. String values or numeric values are right truncated. (SQL_SUCCESS_WITH_INFO is returned if no error occurred.) |
| 01004 | SQLGetData | Data truncated. | The data returned for the specified column (ColumnNumber ) was truncated. String or numeric values are right truncated. (SQL_SUCCESS_WITH_INFO is returned. ) |
| 01S06* | SQLFetchScroll | Attempted to fetch before the result set returned the first row set. | The requested row set overlapped the start of the result set when the current position was beyond the first row, and either FetchOrientation was SQL_PRIOR, or FetchOrientation was SQL_RELATIVE with a negative FetchOffset whose absolute value was less than or equal to the current SQL_ATTR_ROW_ARRAY_SIZE. (Function returns SQL_SUCCESS_WITH_INFO.) |
| 07005 | SQLDescribeCol | The statement did not return a result set. | The statement associated with the StatementHandle did not return a result set. There were no columns to describe. (Call SQLNumResultCols() first to determine if there are any rows in the result set.) |
| 07006 | SQLBindParameter | Invalid conversion. | The conversion from the data type identified by the ValueType argument to the data type identified by the ParameterType argument is not a meaningful conversion. (For example, conversion from SQL_C_DATE to SQL_DOUBLE.) |
| 07006 | SQLFetch | Invalid conversion. | The data type could not be converted in a meaningful manner to the data type specified by fCType in SQLBindCol() . |
| 07006 | SQLGetData | Invalid conversion. | The data type cannot be converted to the C data type specified by the argument TargetType . The function was called before for the same ColumnNumber value but with a different TargetType value. |
| 07009 | SQLBindCol | Invalid descriptor index. | The value specified for the argument ColumnNumber exceeded the maximum number of columns in the result set. |
| 07009 | SQLDescribeCol | Invalid descriptor index | The value specified for ColumnNumber was equal to or less than 0. The value specified for the argument ColumnNumber was greater than the number of columns in the result set. |
| 08001 | SQLConnect | Unable to connect to data source. | DB2 CLI was unable to establish a connection with the data source (server). |
| 08002 | SQLConnect | Connection in use. | The specified ConnectionHandle was already used to establish a connection with a data source and the connection is still open. |
| 08003 | SQLAllocHandle | Connection is closed. | The HandleType argument was SQL_HANDLE_STMT, but the connection specified by the InputHandle argument was not open. The connection process must be completed successfully (and the connection must be open) for DB2 CLI to allocate a statement handle. |
| 08003 | SQLDisconnect | Connection is closed. | The connection specified in the argument ConnectionHandle was not open. |
| 08004 | SQLConnect | The application server rejected establishment of the connection. | The data source (server) rejected the establishment of the connection. |
| 08S01 | SQLFreeHandle | Communication link failure. | The HandleType argument was SQL_HANDLE_DBC, and the communication link between DB2 CLI and the data source to which it was trying to connect failed before the function completed processing. |
| 22002 | SQLFetch | Invalid output or indicator buffer specified. | The pointer value specified for the argument pcbValue in SQLBindCol() was a null pointer and the value of the corresponding column is null. There is no means to report SQL_NULL_DATA. |
| 22002 | SQLGetData | Invalid output or indicator buffer specified. | The pointer value specified for the argument StrLen_or_IndPtr was a null pointer and the value of the column is null. There is no means to report SQL_NULL_DATA. |
| 22003 | SQLExecDirect | Numeric value out of range. | A numeric value assigned to a numeric type column caused truncation of the whole part of the number, either at the time of assignment or in computing an intermediate result. |
| 22005 | SQLGetData | Error in assignment. | A returned value was incompatible with the data type denoted by the argument TargetType |
| 39001 * | SQLExecute | A user-defined function returned an invalid SQLSTATE. | A user-defined function returned an invalid SQLSTATE. |
| 40003 08S01 | SQLBindCol | Communication link error. | The communication link between the application and data source failed before the function completed. |
| 40003 08S01 | SQLBindParameter | Communication link failure. | The communication link between the application and data source failed before the function completed. |
| 40003 08S01 | SQLDescribeCol | Communication link failure. | The communication link between the application and data source failed before the function completed. |
| 40003 08S01 | SQLFreeStmt | Communication link failure. | The communication link between the application and data source failed before the function completed. |
| 40003 08S01 | SQLGetData | Communication link failure. | The communication link between the application and data source failed before the function completed. |
| 40003 08S01 | SQLNumResultCols | Communication link failure. | The communication link between the application and data source failed before the function completed. |
| 40003 08S01 | SQLRowCount | Communication link failure. | The communication link between the application and data source failed before the function completed. |
| 42nnn* | SQLPrepare | Syntax Error. | 42nnn SQLSTATES indicate a variety of syntax or access problems with the statement. The characters nnn refer to any SQLSTATE with that class code. Example: 42nnn refers to any SQLSTATE in the 42 class. |
| 42xxx | SQLExecDirect | Syntax error or access rule violation. | 42xxx SQLSTATES indicate a variety of syntax or access problems with the statement. xxx refers to any SQLSTATE with that class code. Example: 42xxx refers to any SQLSTATE in the 42 class. |
| 42xxx | SQLNumResultCols | Syntax Error. | 42xxx SQLSTATES indicate a variety of syntax or access problems with the statement. xxx refers to any SQLSTATE with that class code. Example: 42xxx refers to any SQLSTATE in the 42 class. |
| 58004 | SQLBindCol | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLBindParameter | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLConnect | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLDescribeCol | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLDisconnect | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLExecDirect | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLFetch | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLFreeStmt | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLGetData | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLPrepare | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLNumResultCols | Unexpected system failure. | Unrecoverable system error. |
| 58004 | SQLRowCount | Unexpected system failure. | Unrecoverable system error. |
| 59101* | SQLExecute | User not defined. | User is not defined in the Mobile Devices Administration Center control database. |
| 59102* | SQLExecute | Incorrect password. | User password does not match the password defined in the Mobile Devices Administration Center. |
| 59103* | SQLExecute | Group not defined. | Group is not defined in the Mobile Devices Administration Center. |
| 59104* | SQLExecute | Application not defined. | Application is not defined in the Mobile Devices Administration Center. |
| 59105* | SQLExecute | Subscription not defined. | Subscription with AgentAdapter is not defined in the Mobile Devices Administration Center. |
| 59106* | SQLExecute | Subscription not complete. | The subscription does not have all the required information to invoke a remote stored procedure. |
| 59120* | SQLExecute | XML conversion error. | AgentAdapter failed at converting user input data to XML document. |
| 59121* | SQLExecute | General AgentAdapter error. | General AgentAdapter error. |
| 59122* | SQLExecute | Loading library failed. | Some required libraries cannot be found on the system. |
| HY000 | SQLAllocHandle | General error. | An error occurred for which there is no specific SQLSTATE. The error message returned by SQLGetDiagRec() in the *MessageText buffer describes the error and its cause. |
| HY000 | SQLFreeHandle | General error. | An error occurred for which there is no specific SQLSTATE. The error message returned by SQLGetDiagRec() in the *MessageText buffer describes the error and its cause. |
| HY001 | SQLAllocHandle | Memory allocation error. | DB2 CLI is unable to allocate memory for the specified handle. |
| HY001 | SQLBindCol | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLBindParameter | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLConnect | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLDescribeCol | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLDisconnect | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLExecDirect | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLFetch | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLFreeHandle | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLFreeStmt | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLGetData | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLPrepare | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLNumResultCols | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY001 | SQLRowCount | Memory allocation failure. | DB2 CLI is unable to allocate memory required to support execution or completion of the function. |
| HY002 | SQLBindCol | Invalid column number. | The value specified for the argument ColumnNumber is less than 0. The value specified for the argument ColumnNumber exceeded the maximum number of columns supported by the data source. |
| HY002 | SQLDescribeCol | Invalid column number. | The value specified for the argument ColumnNumber is less than 1. The value specified for the argument ColumnNumber is greater than the number of columns in the result set. |
| HY002 | SQLGetData | Invalid column number. | The specified column is less than 0 or greater than the number of result columns. |
| HY003 | SQLBindCol | Program type out of range. | TargetType is not a valid data type or SQL_C_DEFAULT. |
| HY003 | SQLBindParameter | Program type out of range. | The value specified by the argument ParameterNumber is not a valid data type or SQL_C_DEFAULT. |
| HY003 | SQLGetData | Program type out of range. | TargetType is not a valid data type or SQL_C_DEFAULT. |
| HY004 | SQLBindParameter | SQL data type out of range. | The value specified for the argument ParameterType is not a valid SQL data type. |
| HY009 | SQLBindParameter | Invalid argument value. | The argument ParameterValuePtr is a null pointer, and the argument StrLen_or_IndPtr is a null pointer, and InputOutputType is not SQL_PARAM_OUTPUT. |
| HY009 | SQLExecDirect | Invalid argument value. | StatementText is a null pointer. |
| HY009 | SQLNumResultCols | Invalid argument value. | StatementText is a null pointer. |
| HY010 | SQLDescribeCol | Function sequence error. | The function is called prior to calling SQLPrepare() or SQLExecDirect() for the StatementHandle . |
| HY010 | SQLExecute | Function sequence error. | The specified StatementHandle is not in a prepared state. SQLExecute() is called without first calling SQLPrepare(). |
| HY010 | SQLFetch | Function sequence error. | The function is called prior to calling SQLPrepare() or SQLExecDirect() for the StatementHandle. |
| HY010 | SQLFreeHandle | Function sequence error. | The HandleType argument is SQL_HANDLE_ENV, and at least one connection is in an allocated or connected state. SQLDisconnect() and SQLFreeHandle() with a HandleType of SQL_HANDLE_DBC must be called for each connection before calling SQLFreeHandle() with a HandleType of SQL_HANDLE_ENV. The HandleType argument is SQL_HANDLE_DBC, and the function is called before calling SQLDisconnect() for the connection. The HandleType argument is SQL_HANDLE_STMT; SQLExecute() or SQLExecDirect() is called with the statement handle, and returned SQL_NEED_DATA. (DM) All subsidiary handles and other resources were not released before SQLFreeHandle() is called. |
| HY010 | SQLGetData | Function sequence error. | The function is called without first calling SQLFetch(). |
| HY010 | SQLNumResultCols | Function sequence error. | The function is called prior to calling SQLPrepare() or SQLExecDirect() for the StatementHandle. |
| HY010 | SQLRowCount | Function sequence error. | The function is called prior to calling SQLExecute() or SQLExecDirect() for the StatementHandle. |
| HY013 | SQLAllocHandle | Unexpected memory handling error. | The HandleType argument is SQL_HANDLE_DBC, or SQL_HANDLE_STMT; and the function call cannot be processed because the underlying memory objects cannot be accessed, possibly because of low memory conditions. |
| HY013 | SQLBindCol | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLBindParameter | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLConnect | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLDescribeCol | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLDisconnect | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLExecDirect | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLFetch | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLFreeHandle | Unexpected memory handling error. | The HandleType argument is SQL_HANDLE_STMT, and the function call cannot be processed because the underlying memory objects cannot be accessed, possibly because of low memory conditions. |
| HY013 | SQLGetData | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLNumResultCols | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLNumResultCols | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY013 | SQLRowCount | Unexpected memory handling error. | DB2 CLI is unable to access memory required to support execution or completion of the function. |
| HY014 | SQLAllocHandle | No more handles. | The limit for the number of handles that can be allocated for the type of handle indicated by the HandleType argument is reached. |
| HY014 | SQLExecDirect | No more handles. | DB2 CLI is unable to allocate a handle due to internal resources. |
| HY014 | SQLNumResultCols | No more handles. | DB2 CLI is unable to allocate a handle due to internal resources. |
| HY017 | SQLFreeHandle | Invalid use of an automatically allocated descriptor handle. | The Handle argument is set to the handle for an automatically allocated descriptor or an implementation descriptor. |
| HY024 | SQLSetStmtAttr | Invalid attribute value. | Given the specified Attribute value, an invalid value is specified in ValuePtr. |
| HY090 | SQLBindCol | Invalid string or buffer length. | The value specified for the argument BufferLength is less than 1, and the argument TargetType is either SQL_C_CHAR, SQL_C_BINARY or SQL_C_DEFAULT. |
| HY090 | SQLBindParameter | Invalid string or buffer length. | The value specified for the argument BufferLength is less than 0. |
| HY090 | SQLDescribeCol | Invalid string or buffer length. | The length specified in argument BufferLength is less than 1. |
| HY090 | SQLExecDirect | Invalid string or buffer length. | The argument TextLength is less than 1 but not equal to SQL_NTS. |
| HY090 | SQLGetData | Invalid string or buffer length. | The value of the argument BufferLength is less than 0 and the argument TargetType is SQL_C_CHAR or SQL_C_BINARY; or TargetType is SQL_C_DEFAULT and the default type is one of SQL_C_CHAR, SQL_C_BINARY, or SQL_C_DBCHAR. |
| HY090 | SQLNumResultCols | Invalid string or buffer length | The argument TextLength is less than 1, but not equal to SQL_NTS. |
| HY092 | SQLAllocHandle | Option type out of range. | The HandleType argument is not:
|
| HY092 | SQLFreeStmt | Option type out of range. | The value specified for the argument Option is not SQL_DROP or SQL_RESET_PARAMS. |
| HY093 | SQLBindParameter | Invalid parameter number. | The value specified for the argument ValueType is less than 1 or greater than the maximum number of parameters supported by the server. |
| HY094 | SQLBindParameter | Invalid scale value. | The value specified for ParameterType is either SQL_DECIMAL or SQL_NUMERIC, and the value specified for DecimalDigits is less than 0 or greater than the value for the argument ParamDef (precision). |
| HY104 | SQLBindParameter | Invalid precision value. | The value specified for ParameterType is either SQL_DECIMAL or SQL_NUMERIC, and the value specified for ParamDef is less than 1. |
| HY105 | SQLBindParameter | Invalid parameter type. | InputOutputType is not SQL_PARAM_INPUT. |
| HY106 | SQLFetchScroll | Fetch type out of range. | The value specified for the argument FetchOrientation is not valid. The value of the SQL_CURSOR_TYPE statement attribute is SQL_CURSOR_FORWARD_ONLY and the value of argument FetchOrientation is not SQL_FETCH_NEXT. |
| HY107 | SQLFetchScroll | Row value out of range. | The value specified with the SQL_ATTR_CURSOR_TYPE statement attribute is SQL_CURSOR_KEYSET_DRIVEN, but the value specified with the SQL_ATTR_KEYSET_SIZE statement attribute is greater than 0 and less than the value specified with the SQL_ATTR_ROW_ARRAY_SIZE statement attribute. |
| HY501 | SQLConnect | Invalid DataSource name. | The specified DataSource name is not valid. |
| HYC00 | SQLBindCol | Driver not capable. | DB2 CLI recognizes, but does not support the data type specified in the argument TargetType . |
| HYC00 | SQLBindParameter | Driver not capable. | DB2 CLI or data source does not support the conversion specified by the combination of the value specified for the argument ValueType and the value specified for the argument ParameterType. The value specified for the argument ParameterType is not supported by either DB2 CLI or the data source. |
| HYC00 | SQLDescribeCol | Driver not capable. | The SQL data type of column ColumnNumber is not recognized by DB2 CLI. |
| HYC00 | SQLGetData | Driver not capable. | The SQL data type for the specified data type is recognized but not supported by DB2 CLI. The requested conversion from the SQL data type to the application data TargetType cannot be performed by DB2 CLI or the data source. |
Related reference