The following table lists ODBC functions, grouped by type of task, and includes the conformance designation and a brief description of the purpose of each function. For more information about conformance designations, see “ODBC and the Standard CLI” in Chapter 1, “Introduction.” For more information about the syntax and semantics for each function, see Chapter 21, “ODBC API Reference.”
An application can call the SQLGetInfo function to obtain conformance information about a driver. To obtain information about support for a specific function in a driver, an application can call SQLGetFunctions.
| Task | Function name | Conformance | Purpose |
| Connecting to a data source | SQLAllocHandle | ISO 92 | Obtains an environment, connection, statement, or descriptor handle. |
| SQLConnect | ISO 92 | Connects to a specific driver by data source name, user ID, and password. | |
| SQLDriverConnect | ODBC | Connects to a specific driver by connection string or requests that the Driver Manager and driver display connection dialog boxes for the user. | |
| SQLBrowseConnect | ODBC | Returns successive levels of connection attributes and valid attribute values. When a value has been specified for each connection attribute, connects to the data source. | |
| Obtaining information about a driver and data source | SQLDataSources |
ISO 92 ODBC |
Returns the list of available data sources. Returns the list of installed drivers and their attributes. |
| SQLGetInfo | ISO 92 | Returns information about a specific driver and data source. | |
| SQLGetFunctions | ISO 92 | Returns supported driver functions. | |
| SQLGetTypeInfo | ISO 92 | Returns information about supported data types. | |
| Setting and retrieving driver attributes | SQLSetConnectAttr | ISO 92 ISO 92 |
Sets a connection attribute. Returns the value of a connection attribute. |
| SQLSetEnvAttr | ISO 92 | Sets an environment attribute. | |
| SQLGetEnvAttr | ISO 92 | Returns the value of an environment attribute. | |
| SQLSetStmtAttr | ISO 92 | Sets a statement attribute. | |
| SQLGetStmtAttr | ISO 92 | Returns the value of a statement attribute. | |
| Setting and retrieving descriptor fields | SQLGetDescField | ISO 92 ISO 92 |
Returns the value of a single descriptor field. Returns the values of multiple descriptor fields. |
| SQLSetDescField | ISO 92 | Sets a single descriptor field. | |
| SQLSetDescRec | ISO 92 | Sets multiple descriptor fields. | |
| Preparing SQL requests | SQLPrepare | ISO 92 | Prepares an SQL statement for later execution. |
| SQLBindParameter | ODBC | Assigns storage for a parameter in an SQL statement. | |
| SQLGetCursorName | ISO 92 | Returns the cursor name associated with a statement handle. | |
| SQLSetCursorName | ISO 92 | Specifies a cursor name. | |
| SQLSetScrollOptions | ODBC | Sets options that control cursor behavior. | |
| Submitting requests | SQLExecute | ISO 92 ISO 92 |
Executes a prepared statement. Executes a statement. |
| SQLNativeSql | ODBC | Returns the text of an SQL statement as translated by the driver. | |
| SQLDescribeParam | ODBC | Returns the description for a specific parameter in a statement. | |
| SQLNumParams | ISO 92 | Returns the number of parameters in a statement. | |
| SQLParamData | ISO 92 | Used in conjunction with SQLPutData to supply parameter data at execution time. (Useful for long data values.) | |
| SQLPutData | ISO 92 | Sends part or all of a data value for a parameter. (Useful for long data values.) | |
| Retrieving results and information about results | SQLRowCount |
ISO 92
|
Returns the number of rows affected by an insert, update, or delete request. Returns the number of columns in the result set. |
| SQLDescribeCol | ISO 92 | Describes a column in the result set. | |
| SQLColAttribute | ISO 92 | Describes attributes of a column in the result set. | |
| SQLBindCol | ISO 92 | Assigns storage for a result column and specifies the data type. | |
| SQLFetch | ISO 92 | Returns multiple result rows. | |
| SQLFetchScroll | ISO 92 | Returns scrollable result rows. | |
| SQLGetData | ISO 92 | Returns part or all of one column of one row of a result set (useful for long data values). | |
| SQLSetPos | ODBC | Positions a cursor within a fetched block of data, and allows an application to refresh data in the rowset, or update or delete data in the result set. | |
| SQLBulkOperations | ODBC | Performs bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark. | |
| SQLMoreResults | ODBC | Determines whether there are more result sets available and, if so, initializes processing for the next result set. | |
| SQLGetDiagField | ISO 92 | Returns additional diagnostic information (a single field of the diagnostic data structure). | |
| SQLGetDiagRec | ISO 92 | Returns additional diagnostic information (multiple fields of the diagnostic data structure). | |
| Obtaining information about the data source’s system tables (catalog functions) | SQLColumnPrivileges | ODBC
|
Returns a list of columns and associated privileges for one or more tables. Returns the list of column names in specified tables. |
| SQLForeignKeys | ODBC | Returns a list of column names that make up foreign keys, if they exist for a specified table. | |
| SQLPrimaryKeys | ODBC | Returns the list of column names that make up the primary key for a table. | |
| SQLProcedureColumns | ODBC | Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures. | |
| SQLProcedures | ODBC | Returns the list of procedure names stored in a specific data source. | |
| SQLSpecialColumns | X/Open | Returns information about the optimal set of columns that uniquely identifies a row in a specified table, or the columns that are automatically updated when any value in the row is updated by a transaction. | |
| SQLStatistics | ISO 92 | Returns statistics about a single table and the list of indexes associated with the table. | |
| SQLTablePrivileges | ODBC | Returns a list of tables and the privileges associated with each table. | |
| SQLTables | X/Open | Returns the list of table names stored in a specific data source. | |
| Terminating a statement | SQLFreeStmt | ISO 92 | Ends statement processing, discards pending results, and, optionally, frees all resources associated with the statement handle. |
| SQLCloseCursor | ISO 92 | Closes a cursor that has been opened on a statement handle. | |
| SQLCancel | ISO 92 | Cancels an SQL statement. | |
| SQLEndTran | ISO 92 | Commits or rolls back a transaction. | |
| Terminating a connection | SQLDisconnect | ISO 92 ISO 92 |
Closes the connection. Releases an environment, connection, statement, or descriptor handle. |