Skip to end of metadata
Go to start of metadata


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
if it was an UPDATE, DELETE, or INSERT.

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
host by using connection string.

 

altibase_data_seek()

seeks to an arbitrary row in a query result set and changes the pointer location
of the resource.

OCIStmtFetch2()

altibase_fetch_row()

retrieves a row of a result set.

OCIRawResize()
OCIStringResize()

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
recently executed SQL statement.

 

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
connection.

 

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
INSERT.

OCIBindByName()
OCIBindByPos()

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
new result as an array.

 

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
most recently invoked prepared statement function that can succeed or fail.

 

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
statement handler.

 

altibase_stmt_free_result()

returns the number of columns for the most recent statement for the
statement handler.

 

altibase_stmt_param_count()

returns the number of parameter markers present in the prepared
statement.

OCIStmtPrepare(),
OCIStmtPrepare2()

altibase_stmt_prepare()

returns the number of parameter markers present in the prepared
statement.
If no parameter marker exists, the function returns 0.

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
after prepare.

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.


  • No labels