Categories of Db2 for i CLI functions
The list shows the Db2® for i CLI functions by category.
- Connecting
- Diagnostics
- MetaData
- SQLColumns - Get column information for a table
- SQLColumnPrivileges - Get privileges associated with the columns of a table
- SQLForeignKeys - Get the list of foreign key columns
- SQLGetInfo - Get general information
- SQLGetTypeInfo - Get data type information
- SQLLanguages - Get SQL dialect or conformance information
- SQLPrimaryKeys - Get primary key columns of a table
- SQLProcedureColumns - Get input/output parameter information for a procedure
- SQLProcedures - Get list of procedure names
- SQLSpecialColumns - Get special (row identifier) columns
- SQLStatistics - Get index and statistics information for a base table
- SQLTablePrivileges - Get privileges associated with a table
- SQLTables - Get table information
- Processing SQL statements
- SQLBindCol - Bind a column to an application variable
- SQLBindFileToCol - Bind LOB file reference to LOB column
- SQLBindFileToParam - Bind LOB file reference to LOB parameter
- SQLBindParam - Bind a buffer to a parameter marker
- SQLBindParameter - Bind a parameter marker to a buffer
- SQLCancel - Cancel statement
- SQLCloseCursor - Close cursor statement
- SQLColAttributes - Obtain column attributes
- SQLDescribeCol - Describe column attributes
- SQLDescribeParam - Return description of a parameter marker
- SQLEndTran - Commit or roll back a transaction
- SQLExecDirect - Execute a statement directly
- SQLExecute - Execute a statement
- SQLExtendedFetch - Fetch array of rows
- SQLFetch - Fetch next row
- SQLFetchScroll - Fetch from a scrollable cursor
- SQLGetCursorName - Get cursor name
- SQLGetData - Get data from a column
- SQLGetDescField - Get descriptor field
- SQLGetDescRec - Get descriptor record
- SQLMoreResults - Determine whether there are more result sets
- SQLNativeSql - Get native SQL text
- SQLNextResult - Process the next result set
- SQLNumParams - Get number of parameters in an SQL statement
- SQLNumResultCols - Get number of result columns
- SQLParamData - Get next parameter for which a data value is needed
- SQLParamOptions - Specify an input array for a parameter
- SQLPrepare - Prepare a statement
- SQLPutData - Pass data value for a parameter
- SQLRowCount - Get row count
- SQLSetCursorName - Set cursor name
- SQLTransact - Commit or roll back a transaction
- Working with attributes
- SQLGetCol - Retrieve one column of a row of the result set
- SQLGetConnectAttr - Get the value of a connection attribute
- SQLGetConnectOption - Return current setting of a connect option
- SQLGetCursorName - Get cursor name
- SQLGetData - Get data from a column
- SQLGetDescField - Get descriptor field
- SQLGetDescRec - Get descriptor record
- SQLGetEnvAttr - Return current setting of an environment attribute
- SQLGetFunctions - Get functions
- SQLGetInfo - Get general information
- SQLGetLength - Retrieve length of a string value
- SQLGetPosition - Return starting position of string
- SQLGetStmtAttr - Get the value of a statement attribute
- SQLGetStmtOption - Return current setting of a statement option
- SQLGetSubString - Retrieve portion of a string value
- SQLGetTypeInfo - Get data type information
- SQLSetConnectAttr - Set a connection attribute
- SQLSetConnectOption - Set connection option
- SQLSetCursorName - Set cursor name
- SQLSetDescField - Set a descriptor field
- SQLSetDescRec - Set a descriptor record
- SQLSetEnvAttr - Set environment attribute
- SQLSetParam - Set parameter
- SQLSetStmtAttr - Set a statement attribute
- SQLSetStmtOption - Set statement option
- Working with handles
- SQLAllocConnect - Allocate connection handle
- SQLAllocEnv - Allocate environment handle
- SQLAllocHandle - Allocate handle
- SQLAllocStmt - Allocate a statement handle
- SQLCopyDesc - Copy description statement
- SQLFreeConnect - Free connection handle
- SQLFreeEnv - Free environment handle
- SQLFreeHandle - Free a handle
- SQLFreeStmt - Free (or reset) a statement handle
- SQLReleaseEnv - Release all environment resources