Overview
From Altibase Version 5.3.5.x, ALTIBASE HDB provides ACI(Altibase C Interface), which is compared to OCI(ORACLE C Interface).
The functionality of ACI is based on the mysql connector/c interface.
And this interface was established as a kind of DBC(Database Connectivity) which is more easily to use than CLI.
And it has fewer functions and parameters to call than CLI requires to improve usability.
But most contents of ACI are similar to those of Altibase CLI.
Features
- This Interface cannot be worked on the windows platforms.
- ACI only supports library written in C Language instead of C++.
- This is not standard interface like as OCI.
- To use binding functionality in ACI, it is sure to use a prepared statement.
- Parameter binding is impossible to use In ACI, even in case of the SQLExecDirect() unlike as CLI.
General Functions
Oracle OCI |
Altibase ACI |
Comments |
---|---|---|
OCIAttrGet() |
altibase_affected_rows() |
returns the number of rows changed, deleted, or inserted by the last statement |
OCIClientVersion() |
altibase_client_version() |
returns a constant that represents the client library version. |
OCIServerDetach() |
altibase_close() |
closes a previously opened connection. |
OCITransCommit() |
altibase_commit() |
commits the current trasnaction. |
OCITransRollback() |
altibase_rollback() |
rolls back the current transaction. |
OCIParamSet() |
altibase_set_autocommit() |
sets the autocommit mode to on. |
OCIServerAttach() |
altibase_connect() |
attempts to establish a connection to an Altibase database engine running on |
|
altibase_data_seek() |
seeks to an arbitrary row in a query result set and changes the pointer location |
OCIStmtFetch2() |
altibase_fetch_row() |
retrieves a row of a result set. |
OCIRawResize() |
altibase_free_result() |
frees the memory allocated for a result set. |
OCIStmtExecute() |
altibase_query() |
executes the SQL statement. |
OCIErrorGet() |
altibase_errno() |
returns the error code for the most recently invoked API function that can succeed or fail. |
OCIErrorGet() |
altibase_error() |
returns error message for the most recently invoked API function. |
|
altibase_sqlstate() |
returns a null-terminating string containing the SQLSTATE error code for the most |
|
altibase_fetch_lengths() |
returns the lengths of the columns of the current row within a result set. |
|
altibase_field() |
returns the definition of one column of a result set. |
|
altibase_field_count() |
returns the number of columns for the most recent query on the connection. |
|
altibase_get_charset() |
returns character set name for the current connection. |
OCIInitialize() |
altibase_init() |
allocates or initializes an Altibase object as a connection handle. |
|
altibase_list_fields() |
returns a result set consisting of field names in the given table. |
|
altibase_list_tables() |
returns a result set consisting of table names in the current database. |
|
altibase_next_result() |
moves the cursor position on the next statement result set to read. |
|
altibase_num_fields() |
returns the number of columns in a result set. |
|
altibase_num_rows() |
returns the number of rows in the result set. |
|
altibase_proto_version() |
returns a constant representing the protocol version used by the current |
|
altibase_proto_verstr() |
returns a string representing the protocol version used by the current connection. |
OCIServerVersion() |
altibase_server_version() |
returns the version number of the server. |
|
altibase_set_charset() |
is used to set the character set for the current connection. |
OCIUserCallbackRegister() |
altibase_set_failover_callback() |
registers failover callbacks for the failover to happen in the current database. |
|
altibase_set_option() |
enables or disables an option for the connection. |
Prepared Statement Functions
Oracle OCI |
Altibase ACI |
Comments |
---|---|---|
|
altibase_stmt_affected_rows() |
returns the number of rows changed, deleted, or inserted by the last statement if it was an UPDATE, DELETE, or |
OCIBindByName() |
altibase_stmt_bind_param() |
used to bind input data for the parameter markers in the SQL statement. |
OCIStmtExecute() |
altibase_stmt_execute() |
executes the prepared query associated with the statement handle. |
|
altibase_stmt_bind_result() |
used to bind output columns in the result set. |
|
altibase_stmt_data_seek() |
seeks to an arbitrary row in a statememt result set and moves its position. |
OCIErrorGet() |
altibase_stmt_errno() |
returns the error code for the most recently invoked statement. |
OCIErrorGet() |
altibase_stmt_error() |
returns error message for the most recently invoked statement. |
OCIStmtFetch(), OCIStmtFetch2() |
altibase_stmt_fetch() |
fetches a row from the result set in a prepared statement. |
|
altibase_stmt_fetch_column() |
fetches one column from the current result set row. |
|
altibase_stmt_fetched() |
returns the number of the exisitng rows fetched previously after fetching |
|
altibase_stmt_num_rows() |
returns the number of rows in the result set. |
|
altibase_stmt_sqlstate() |
returns a null-terminating string containing the SQLSTATE error code for the |
|
altibase_stmt_store_result() |
is called to buffer the complete result set. |
OCISessionEnd() |
altibase_stmt_close() |
closes the prepared statement. |
|
altibase_stmt_field_count() |
returns the number of columns for the most recent statement for the |
|
altibase_stmt_free_result() |
returns the number of columns for the most recent statement for the |
|
altibase_stmt_param_count() |
returns the number of parameter markers present in the prepared |
OCIStmtPrepare(), |
altibase_stmt_prepare() |
returns the number of parameter markers present in the prepared |
OCIAttrGet() |
altibase_stmt_get_attr() |
can be used to get the current value for a statement attribute. |
OCIAttrSet() |
altibase_stmt_init() |
creates an ALTIBASE_STMT handle. |
|
altibase_stmt_processed() |
returns the number of rows after using the array binding. |
OCIDescriptorFree() |
altibase_stmt_reset() |
resets statement handle for a prepared statement on client and server to state |
OCIDescribeAny() |
altibase_stmt_result_metadata() |
returns the result set metadata for the prepared query. |
OCIBindArrayOfStruct() |
altibase_stmt_set_array_bind() |
specifies the size of array when you want to use the array binding. |
OCIDefineArrayOfStruct() |
altibase_stmt_set_array_fetch() |
specifies the size of array when you want to fetch an array. |
|
altibase_stmt_status() |
returns the results returned after using the array binding or fetching an array. |