Skip to content
≡

Administrator

Developer

Tools

External Tools

Appendix C. Error Codes#

SQLError returns SQLSTATE values as defined in the X/Open and SQL Access Group SQL CAE specification (1992), and ODBC specifications. SQLSTATE is a five-byte alphanumeric string. This Appendix describes SQLSTATE values for Altibase CLI and ODBC.

SQLSTATE#

The following table displays SQLSTATE values that can be returned by SQLError of the Altibase CLI driver.

SQLSTATE Error Can be returned from
01004 Data truncation
(if the size of the value to be returned is larger than the size of the buffer)		 SQLDescribeCol
SQLFetch
SQLGetData
07006 Restricted data type attribute violation SQLBindParameter
SQLExecute
SQLFetch
07009 Invalid descriptor index SQLBindCol
SQLBindParameter
SQLColAttribute
SQLDescribeCol
SQLDescribeParam
SQLGetData
  • For SQLSTATE 08001, 08002, 08003, and 08S01, refer to the next table.
SQLSTATE Error Can be returned from
HY000 General error SQLAllocStmt
SQLAllocConnect
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLColumns
SQLConnect
SQLDescribeCol
SQLDisconnect
SQLDriverConnect
SQLEndTran
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeHandle
SQLFreeStmt
SQLGetData
SQLNumParams
SQLNumResultCols
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLRowCount
SQLSetAttribute
SQLSetConnectAttr
SQLSetEnvAttr
SQLStatistics
SQLTables
HY001 Memory allocation error
(Cannot allocate the requested memory for the ODBC driver to execute and complete the function.)		 SQLAllocConnect
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLConnect
SQLDriverConnect
SQLExecDirect
SQLGetTypeInfo
SQLPrepare
HY003 Invalid application buffer type
(the cType argument value is not a valid C data type.)		 SQLBindCol
SQLBindParameter
HY009 Invalid argument
(null pointer)		 SQLAllocConnect
SQLAllocStmt
SQLBindParameter
SQLExecDirect
SQLForeignKeys
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
HY010 Function sequence error SQLAllocStmt
SQLDescribeParam
SQLGetData
HY090 Invalid character string or buffer length SQLBindParameter
SQLDescribeCol
SQLExecute
SQLForeignKeys
SQLGetData
SQLGetStmtAttr
SQLTablePrivileges
HY092 Invalid attribute or option SQLGetStmtAttr
HY105 Invalid parameter type SQLBindParameter
HYC00 Unsupported attribute SQLGetConnectAttr
SQLGetStmtAttr
SQLSTATE Code Error Can be returned from
HY000 0x51001 The character set does not exist. SQLConnect
SQLDriverConnect
0x5003b The communication buffer is insufficient.
(It exceeded the length of the communication buffer.)		 SQLExecute
HY001 0x5104A Memory allocation error
(Cannot allocate the memory requested for the driver to execute the function and complete execution)		 SQLConnect
SQLDriverConnect
08001 0x50032 The driver cannot set the connection to the database. SQLConnect
SQLDriverConnect
SQLSTATE Code Error Can be returned from
08002 0x51035 The dbc is already connected to the database. SQLConnect
SQLDriverConnect
08003 0x51036 stmt is unconnected or disconnected. SQLExecDirect
SQLExecute
SQLPrepare
08S01 0x51043 Communication channel error
(Communication channel failure occurred before the execution of the function was complete between the ODBC driver and the database.)		 SQLColumns
SQLConnect
SQLDriverConnect
SQLExecDirect
SQLExecute
SQLFetch
SQLForeignKeys
SQLGetConnectAttr
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLSetConnectAttr
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables

The following tables show how each state changes when an Altibase CLI function that uses an environment, connection or statement handle is called in a statement state.

Altibase CLI statements have the following states.

State Description
S0 Unallocated statement.
(The connection state must be connected connection.)
S1 Allocated statement.
S2 Prepared statement.
(A (possibly empty) result set will be created.)
S6 Cursor positioned with SQLFetch.

The entry values in the transition table are as follows:

  • -- : When the state remains the same after the function is executed

  • Sn : When the statement state is transitioned to a specified state

  • (IH) : Invalid Handle

  • (HY010) : Function sequence error

  • (24000) :

Note*

  • S : Success. In this case, the function returns one of the following values: SQL_SUCCESS_WITH_INFO or SQL_SUCCESS.

  • E : Error. In this case, the function returns SQL_ERROR.

  • R : Results. There is a result set when the statement is executed. (There is a possibility that the result set is an empty set.)

  • NR : No Results. There is no result set when the statement is executed.

  • NF : No Data Found. The function returns SQL_NO_DATA.

  • RD : Receive Done

  • P : Prepared. The statement was prepared

  • NP : Not Prepared. The statement was not prepared.

The following example shows how to view a statement state transition table for the SQLPrepare function.

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
(IH) S => S1 S => S2 (24000)
E => S1

If the SQLPrepare function is called when the handle type is SQL_HANDLE_STMT and the statement state is S0, SQL_INVALID_Handle (IH) is returned. If SQLPrepare is called and successfully executed when the handle type is SQL_HANDLE_STMT and the state is S1, this state is retained. If SQLPrepare is called and successfully executed when the handle type is SQL_HANDLE_STMT and the state is S2, the statement state is transitioned to S2; if unsuccessful, the statement state remains S1 as before. If the function is called while the handle type is SQL_HANDLE_STMT and the state is S6, SQL_ERROR and SQLSTATE 24000 (Invalid Cursor State) are always returned.

SQLAllocHandle#

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
-- -- -- --
S1*

* When HandleType is SQL_HANDLE_STMT

SQLBindCol#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
(IH) -- -- --

SQLBindParameter#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
(IH) -- -- --

SQLColumns, SQLGetTypeInfo, SQLPrimaryKeys, SQLProcedureColumns, SQLProcedures, SQLStatistics, SQLTables#

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
(IH) S => S6 E => S1 (24000)
S => S6

SQLConnect#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
(Error) (Error) (Error) (Error)

SQLDisconnect#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
-- * => S0 * => S0 * => S0

* *When the SQLDisconnect function is called, all statements related to the connection handle are terminated. This function moves a connection from a connection state to an allocated connection state; the connection state is C4 (connected connection) before the statement state becomes S0.

SQLDriverConnect#

Please refer to SQLConnect.

SQLExecDirect#

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
(IH) S, NR => -- S, NR => S1 (24000)
S, R => S6 S, R => S6
E => S1

SQLExecute#

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
(IH) (HY010) S, NR => -- (24000)
S, R => S6
E => --

SQLFetch#

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
(IH) (HY010) (HY010) S => --

SQLFreeHandle#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
-- (HY010) (HY010) (HY010)
(IH) S0 S0 S0
  • (1) When the handleType of the first row is SQL_HANDLE_ENV or SQL_HANDLE_DBC
  • (2) When the handleType of the second row is SQL_HANDLE_STMT

SQLFreeStmt#

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
(IH) -- -- NP = > S1
P => S2
(IH) S0 S0 S0
  • (1) When fOption of the first row is SQL_CLOSE
  • (2) When fOption of the second row is SQL_DROP

SQLGetData#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
(IH) (HY010) (HY010) S || NF => --

SQLGetTypeInfo#

Please refer to SQLColumns.

SQLNumResultCols#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
(IH) (HY010) S => -- S => --

SQLPrepare#

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
(IH) S => -- S => -- (24000)
E => S1

SQLPrimaryKeys#

Please refer to SQLColumns.

SQLProcedureColumns#

Please refer to SQLColumns.

SQLProcedures#

Please refer to SQLColumns.

SQLSetConnectAttr#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
--* -- -- (24000)

* When the set Attribute is a connection attribute; please refer to SQLSetStmtAttr if the set Attribute is a statement attribute.

SQLSetEnvAttr#

S0 Unallocated S1 Allocated S2 Prepared S6 Infetch
(Error) (Error) (Error) (Error)

SQLSetStmtAttr#

S0 Unallocated S1Allocated S2 Prepared S6 Infetch
(IH) -- (1) => -- (1) => --
(2) => (Error) (2) => (24000)

  • (1) When the Attribute argument is neither SQL_ATTR_CONCURRENCY, SQL_ATTR_CURSOR_TYPE, SQL_ATTR_SIMULATE_CURSOR, SQL_ATTR_USE_BOOKMARKS, SQL_ATTR_CURSOR_SCROLLABLE, nor SQL_ATTR_CURSOR_SENSITIVITY

  • (2) When the Attribute argument is either SQL_ATTR_CONCURRENCY, SQL_ATTR_CURSOR_TYPE, SQL_ATTR_SIMULATE_CURSOR, SQL_ATTR_USE_BOOKMARKS, SQL_ATTR_CURSOR_SCROLLABLE, or SQL_ATTR_CURSOR_SENSITIVITY

SQLStatistics#

Please refer to SQLColumns.

SQLTables#

Please refer to SQLColumns.


State Transition Table#

The following table lists the major functions that affect state transition:

S0 UNALLOCATED S1 ALLOCATED S2 PREPARED S6 INFETCH
Prepare (IH) S => S1 S => S2 (24000)
E => S1
ExecDirect (IH) S,NR => S1 S => S2 (24000)
S,R => S6 S,R => S6
E => S1
Execute (IH) (HY010) S,NR => S2 (24000)
S,R => S6
E => S2
Fetch (IH) (HY010) (HY010) S => S6
FreeStmt (CLOSE) (IH) S1 S2 NP => S1
P => S2
FreeStmt (DROP) (IH) S0 S0 S0

Cf )

- (IH) : Invalid Handle (HY010) : Function Sequence Error

- (24000) : Invalid Cursor State

- S : Success E : Error except Network Error

- R : Results NR : No Results NF : No data Found RD: Receive Done

- P : Prepared NP : Not Prepared