Allocate a statement handle (SQLAllocStmt) allocates a new statement handle and associates it with the connection specified by the connection handle.
Allocate connection handle (SQLAllocConnect) allocates a connection handle and associated resources within the environment identified by the input environment handle.
Bind LOB file reference to LOB column (SQLBindFileToCol) associates (binds) a LOB column in a result set to a file reference or an array of file references.
Bind LOB file reference to LOB parameter (SQLBindFileToParam) associates (binds) a parameter marker in an SQL statement to a file reference or an array of file references.
Cancel statement (SQLCancel) attempts to end the processing of an ongoing SQL statement operation that is executing asynchronously.
Connect to a data source (expanded) (SQLDriverConnect) establishes a connection to the target database, but SQLDriverConnect() uses a connection string to determine the data source name, user ID and password.
Connect to a data source (expanded, UTF-16 support) (SQLDriverConnectW) establishes a connection to the target database, but SQLDriverConnectW() uses a connection string to determine the data source name, user ID and password.
Copy description statement (SQLCopyDesc) copies the fields of the data structure associated with the source handle to the data structure associated with the target handle.
Describe column attributes (SQLDescribeCol) returns the result descriptor information (column name, type, precision) for the indicated column in the result set generated by a SELECT statement.
Describe column attributes (UTF-16 support) (SQLDescribeColW) returns the result descriptor information (column name, type, precision) for the indicated column in the result set generated by a SELECT statement.
Determine if there are more result sets (SQLMoreResults) determines whether there is more information available on the statement handle which has been associated with a stored procedure that is returning result sets.
Fetch array of rows (SQLExtendedFetch) extends the function of SQLFetch() by returning a block of data containing multiple rows (called a rowset), in the form of an array, for each bound column.
Fetch from a scrollable cursor (SQLFetchScroll) positions the cursor based on the requested orientation, then retrieves any bound columns.
Fetch next row (SQLFetch) advances the cursor to the next row of the result set, and retrieves any bound columns.
Get data from a column (SQLGetData) retrieves data for a single column in the current row of the result set.
Get data type information (SQLGetTypeInfo) returns information about the data types that are supported by the DBMSs associated with DB2 for i CLI. The information is returned in an SQL result set.
Get data type information (UTF-16 support) (SQLGetTypeInfoW) returns information about the data types that are supported by the DBMSs associated with DB2 for i CLI. The information is returned in an SQL result set.
Get functions (SQLGetFunctions) queries whether a specific function is supported.
Get general information (SQLGetInfo) returns general information (including supported data conversions) about the DBMS that the application is currently connected to.
Get general information (UTF-16 support) (SQLGetInfoW) returns general information (including supported data conversions) about the DBMS that the application is currently connected to.
Get list of procedure names (SQLProcedures) returns a list of procedure names that have been registered on the system and match the specified search pattern.
Get row count (SQLRowCount) returns the number of rows in a table affected by an UPDATE, INSERT, or DELETE statement executed against the table, or a view based on the table.
Get table information (SQLTables) returns a list of table names and associated information stored in the system catalogs of the connected data source.
Get table information (UTF-16 support) (SQLTablesW) returns a list of table names and associated information stored in the system catalogs of the connected data source.
Obtain column attributes (SQLColAttributes) obtains an attribute for a column of the result set and is also used to determine the number of columns.
Obtain column attributes (UTF-16 support) (SQLColAttributesW) obtains an attribute for a column of the result set and is also used to determine the number of columns.
Passing data value for a parameter (SQLPutData) is called following an SQLParamData() call returning SQL_NEED_DATA to supply parameter data values.
Prepare a statement (SQLPrepare) associates an SQL statement with the input statement handle and sends the statement to the DBMS to be prepared.
Prepare a statement (UTF-16 support) (SQLPrepareW) associates an SQL statement with the input statement handle and sends the statement to the DBMS to be prepared.
Process the next result set (SQLNextResult) determines whether there is more information available on the statement handle which has been associated with a stored procedure that is returning result sets.
Retrieve error information (SQLError) returns the diagnostic information associated with the most recently called DB2 for i CLI function for a particular statement, connection, or environment handle.
Retrieve error information (UTF-16 support) (SQLErrorW) returns the diagnostic information associated with the most recently called DB2 for i CLI function for a particular statement, connection, or environment handle.
Retrieve length of a string value (SQLGetLength) is used to retrieve the length of a large object value referenced by a large object locator that has been returned from the data source (as a result of a fetch or an SQLGetSubString() call) during the current transaction.
Retrieve portion of a string value (SQLGetSubString) retrieves a portion of a large object value referenced by a large object locator that has been returned from the data source (returned by a fetch or a previous SQLGetSubString() call) during the current transaction.
Retrieve portion of a string value (UTF-16 support) (SQLGetSubStringW) retrieves a portion of a large object value referenced by a large object locator that has been returned from the data source (returned by a fetch or a previous SQLGetSubStringW() call) during the current transaction.
Return a column attribute (SQLColAttribute) obtains an attribute for a column of the result set and is also used to determine the number of columns. SQLColAttribute() is a more extensible alternative to the SQLDescribeCol() function.
Return diagnostic information (concise) (SQLGetDiagRec) returns the diagnostic information associated with the most recently called DB2 for i CLI function for a particular statement, connection, or environment handle.
Return diagnostic information (concise, UTF-16 support) (SQLGetDiagRecW) returns the diagnostic information associated with the most recently called DB2 for i CLI function for a particular statement, connection, or environment handle.
Return diagnostic information (extensible) (SQLGetDiagField) returns the diagnostic information associated with the most recently called DB2 for i CLI function for a particular statement, connection, or environment handle.
Return diagnostic information (extensible, UTF-16 support) (SQLGetDiagFieldW) returns the diagnostic information associated with the most recently called DB2 for i CLI function for a particular statement, connection, or environment handle.