Categories of DB2 UDB CLIs

 

The list shows the DB2^® UDB call level interface (CLI) functions by category.

• Connecting

  • SQLConnect - Connect to a data source

  • SQLDataSources - Get list of data sources

  • SQLDisconnect - Disconnect from a data source

  • SQLDriverConnect - (Expanded) Connect to a data source

• Diagnostics

  • SQLError - Retrieve error information

  • SQLGetDiagField - Return diagnostic information (extensible)

  • SQLGetDiagRec - Return diagnostic information (concise)

• 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 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

 

Parent topic:

DB2 UDB CLI functions