API functions in OceanBase Connector/ODBC

The following table summarizes all API functions available in the current version of OceanBase Connector/ODBC.

For more information about the API functions of ODBC, see ODBC API Reference.

Function name	Supported?	Description
SQLAllocConnect	Yes	Obtains a connection handle.
SQLAllocEnv	Yes	Obtains an environment handle allocated by the driver.
SQLAllocHandle	Yes	Obtains an environment, connection, statement, or descriptor handle.
SQLAllocStmt	Yes	Allocates a statement handle.
SQLBindCol	Yes	Binds application data buffers to columns in a result set.
SQLBindParameter	Yes	Binds a buffer to a parameter marker in an SQL statement.
SQLBrowseConnect	Yes (in Windows but not Linux)	Returns the attributes and attribute values required for connecting to a data source.
SQLBulkOperations	Yes	Performs bulk bookmark insert, update, delete, and fetch operations.
SQLCancel	Yes	Cancels processing on a statement.
SQLCancelHandle	Yes	Cancels processing on a connection or statement.
SQLCloseCursor	Yes	Closes a cursor opened in a statement and discards the pending result.
SQLColAttribute	Yes	Returns the descriptor information of a column in a result set.
SQLColAttributes	Yes	Returns the descriptor information of a column in a result set.
SQLColumnPrivileges	Yes	Returns the columns of the specified table and the privileges associated with the columns.
SQLColumns	Yes	Returns the names of columns in the specified table.
SQLConnect	Yes	Establishes a connection between the driver and a data source.
SQLCopyDesc	Yes	Copies the descriptor information of one descriptor handle to another.
SQLDescribeCol	Yes	Returns the result descriptor of a column in a result set.
SQLDisconnect	Yes	Closes the connection associated with the specified connection handle.
SQLDriverConnect	Yes	Establishes a connection between the driver and a data source.
SQLEndTran	Yes	Requests to commit or roll back a statement operation.
SQLError	Yes	Returns error or status information.
SQLExecDirect	Yes	Executes a statement.
SQLExecute	Yes	Executes a prepared statement.
SQLExtendedFetch	Yes	Returns the specified row in a result set.
SQLFetch	Yes	Returns the next row in a result set.
SQLFetchScroll	Yes	Returns a scrollable row of results.
SQLForeignKeys	Yes	Returns the names of columns used as foreign keys (if any) of the specified table.
SQLFreeConnect	Yes	Releases the connection handle.
SQLFreeEnv	Yes	Releases the environment handle.
SQLFreeHandle	Yes	Releases the environment, connection, statement, or descriptor handle.
SQLFreeStmt	Yes	Ends statement processing and discards the pending result, or releases all resources associated with the statement handle.
SQLGetConnectAttr	Yes	Returns the settings of the current connection attribute.
SQLGetConnectOption	Yes	Returns the value of a connection option.
SQLGetCursorName	Yes	Returns the name of the cursor associated with the specified statement.
SQLGetData	Yes	Retrieves the data of a single column or a single parameter in a result set.
SQLGetDescField	Yes	Returns the current setting or value of a single field.
SQLGetDescRec	Yes	Returns the current settings or values of multiple fields.
SQLGetDiagField	Yes	Returns a single field of the diagnostic data structure.
SQLGetDiagRec	Yes	Returns multiple fields of the diagnostic data structure.
SQLGetEnvAttr	Yes	Returns the current settings of an environment attribute.
SQLGetFunctions	Yes	Returns information about whether the driver supports a specific ODBC function.
SQLGetInfo	Yes	Returns information about the driver and data source associated with a connection.
SQLGetStmtAttr	Yes	Returns the current settings of a statement attribute.
SQLGetStmtOption	Yes	Returns the value of a statement option.
SQLGetTypeInfo	Yes	Returns supported data types.
SQLMoreResults	Yes	Determines whether more results are available in a statement.
SQLNumParams	Yes	Returns the number of parameters in an SQL statement.
SQLNumResultCols	Yes	Returns the number of columns in a result set.
SQLParamData	Yes (in MySQL mode but not Oracle mode)	Supplies parameter data for statement execution.
SQLParamOptions	Yes	Supplies parameter options for statement execution.
SQLPrepare	Yes	Preprocesses the SQL string to be executed.
SQLPrimaryKeys	Yes	Returns the names of columns used as primary keys of a table.
SQLProcedureColumns	Yes	Returns the input and output parameters and the columns that make up the result set for the specified procedure.
SQLProcedures	Yes	Returns the names of procedures stored in the specified data source.
SQLPutData	Yes (in MySQL mode but not Oracle mode)	Allows an application to send data of parameters or columns to the driver for statement execution.
SQLRowCount	Yes	Returns the number of rows affected by an insert, update, or delete request.
SQLSetConnectAttr	Yes	Sets connection attributes.
SQLSetConnectOption	Yes	Sets connection options.
SQLSetCursorName	Yes	Specifies the cursor name.
SQLSetDescField	Yes	Sets a single descriptor field.
SQLSetDescRec	Yes	Sets multiple descriptor fields.
SQLSetEnvAttr	Yes	Sets environment attributes.
SQLSetParam	Yes	Sets parameter attributes.
SQLSetPos	Yes	Sets the cursor position in a row set.
SQLSetScrollOptions	Yes	Sets cursor scrolling options.
SQLSetStmtAttr	Yes	Sets statement attributes.
SQLSetStmtOption	Yes	Sets statement options.
SQLSpecialColumns	Yes	Returns the best column set that uniquely identifies a row in the specified table, or columns automatically updated when a transaction updates any value in the row.
SQLStatistics	Yes	Retrieves statistics of a single table and indexes associated with the table.
SQLTablePrivileges	Yes	Returns tables and privileges associated with each table.
SQLTables	Yes	Returns tables, directories, schema names, or table types stored in a specific data source.
SQLTransact	Yes	Commits or rolls back a transaction.

The current version of OceanBase Connector/ODBC does not support the following API functions:

SQLCompleteAsync
SQLDataSources
SQLDescribeParam
SQLDrivers
SQLNativeSql