2. OpenAPI Function Reference : Function Summary : Query Processing
 
Share this page                  
Query Processing
IIapi_query()
Begins a query statement and allocates a statement handle, and can also allocate a transaction ID handle.
IIapi_batch()
Adds statements to a group of statements to be executed as a batch. Allocates a statement handle and can also allocate a transaction handle. For more information about IIapi_batch(), see Batch Statement Execution.
Support for batch processing must be enabled in OpenAPI by initializing at API version 7 or greater. To initialize with this version, the application uses IIapi_initialize() and sets the in_version parameter to IIAPI_VERSION_7.
The DBMS must also support batch processing, which you can determine with the OpenAPI connection level. The connection level is returned by IIapi_connect() in the co_apiLevel parameter. A minimum level of IIAPI_LEVEL_6 is required.
IIapi_setDescriptor()
Sends information about the format of data being sent to the server for subsequent IIapi_putParms() or IIapi_putColumns() calls.
IIapi_putParms()
Sends data values for query statement parameters.
IIapi_getCopyMap
Returns the data format of the copy file and database table involved in a copy statement.
IIapi_putColumns()
Sends data to be copied from a file to a database table.
IIapi_getDescriptor()
Returns the format of the data for subsequent IIapi_getColumns() call.
IIapi_getColumns()
Returns the results of a query.
IIapi_getColumnInfo() 
Returns additional information about columns retrieved by IIapi_getColumns().
IIapi_getQueryInfo()
Returns information about a query.
Iiapi_getErrorInfo()
Returns additional error or user-defined information.
IIapi_position()
Positions a scrollable cursor.
IIapi_scroll()
Scrolls a scrollable cursor.
IIapi_cancel()
Cancels an outstanding query.
IIapi_close()
Ends a query statement and frees the statement handle.