ODBC commands
This table lists the ODBC commands:
Command | Options | Description |
---|---|---|
odbc sqlallochandle |
|
Allocates memory for one of the four types of OBDC handles: environment, connection, statement, or descriptor. |
odbc sqlbindcol |
|
Assigns the storage and data type for a column in a result set. |
odbc sqlbindparameter |
|
Binds a buffer to a parameter marker in an SQL statement. |
odbc sqlbrowseconnect |
|
Supports an iterative method of discovering and enumerating the attributes and attribute values required to connect to a data source. |
odbc sqlbulkoperations |
|
Performs bulk insertions and bulk bookmark operations: update, delete, retrieve by bookmark. |
odbc sqlcancel |
hstmt
|
Cancels the processing on a statement. |
odbc sqlclosecursor |
StatementHandle
|
Closes a cursor that has been opened on a statement and discards pending results. |
odbc sqlcolattribute |
|
Returns descriptor information for a column in a result set. |
odbc sqlcolumnprivileges |
|
Supplies a list of columns and associated privileges for the specified table. |
odbc sqlcolumns |
|
Supplies a list of column names in specified tables. |
odbc sqlconnect |
|
Loads a driver and establishes a connection to a data source. |
odbc sqlcopydesc |
|
Copies descriptor information from one descriptor handle to another. |
odbc sqldatasources |
|
Lists data source names. |
odbc sqldescribecol |
|
Supplies a description of one column in the result set. |
odbc sqldescribeparam |
|
Supplies the description of a parameter marker that is associated with a prepared SQL statement. |
odbc sqldisconnect |
hdbc
|
Closes the connection that is associated with a specific connection handle. |
odbc sqldriverconnect |
|
An alternative to SQLConnect for connecting to a data source. Use if more connection information than the three arguments in SQLConnect are required. |
odbc sqldrivers |
|
Lists driver descriptions and driver attribute keywords. |
odbc sqlendtran |
|
Requests a commit or rollback operation for active operations on statements that are associated with a connection or all connections associated with an environment. |
odbc sqlexecdirect |
|
Runs a preparable statement using the current values of the parameter marker variables, if any parameters exist in the statement. This is the fastest way to submit an SQL statement for running one instance. |
odbc sqlexecute |
hstmt
|
Runs a prepared statement, using the current values of the parameter marker variables, if any parameter markers exist in the statement. |
odbc sqlfetch |
hstmt
|
Retrieves a row of data from a result
set. The driver provides data for all columns that were bound to storage
locations with SQLBindCol . |
odbc sqlfetchscroll |
|
Retrieves the specified rowset of data from the result set and returns data for all bound columns. |
odbc sqlforeignkeys |
|
This supplies:
|
odbc sqlfreehandle |
|
Frees resources that are associated with a specific environment, connection, statement, or descriptor handle. |
odbc sqlfreestmt |
|
Stops processing that is associated with
a specific statement. It also closes any open cursors associated with
hstmt , discards pending results, and,
optionally, frees all resources associated with the statement handle.
|
odbc sqlgetconnectattr |
|
Returns the current setting of a connection attribute. |
odbc sqlgetcursorname |
|
Supplies the cursor name that is associated with a specific statement. |
odbc sqlgetdata |
|
Provides result data for a single unbound column in the current row. |
odbc sqlgetdescfield |
|
Returns the current setting or value of a single field of a descriptor record. |
odbc sqlgetdescrec |
|
Returns the current setting or values of multiple fields of a descriptor record. |
odbc sqlgetdiagfield |
|
Returns the current value of a field of the diagnostic data structure that is associated with a specific handle containing error, warning, and status information. |
odbc sqlgetdiagrec |
|
Returns the current values of multiple fields of a diagnostic record that contains error, warning, and status information. |
odbc sqlgetenvattr |
|
Returns the current setting of an environment attribute. |
odbc sqlgetfunctions |
|
Supplies information about whether a driver supports a specific ODBC function. |
odbc sqlgetinfo |
|
Supplies general information about the driver and data source that are associated with a connection. |
odbc sqlgetstmtattr |
|
Returns the current setting of a statement attribute. |
odbc sqlgettypeinfo |
|
Supplies information about data types supported by the data source. |
odbc sqlmoreresults |
hstmt
|
Determines whether there are more
results available on an hstmt containing
SELECT, UPDATE, INSERT, or DELETE statements. If so, then it initializes
processing for those results. |
odbc sqlnativesq |
|
Supplies the SQL string as translated by the driver. |
odbc sqlnumparams |
|
Supplies the number of parameters in an SQL statement. |
odbc sqlnumresultcols |
|
Supplies the number of columns in a result set. |
odbc sqlnumresultcols |
|
Supplies the number of columns in a result set. |
odbc sqlparamdata |
|
Used in conjunction with SQLPutData to supply parameter data at
statement running time. |
odbc sqlprepare |
|
Prepares an SQL string for running. |
odbc sqlprimarykeys |
|
Returns the column names that makes up the primary key for a table. |
odbc sqlprocedurecolumns |
|
Returns the list of input and output parameters, including the columns that make up the result set for the specified procedures. |
odbc sqlprocedures |
|
Returns the list of procedure names that are stored in a specific data source. |
odbc sqlputdata |
|
Sends data for a parameter or column to the driver at statement running time. |
odbc sqlrowcount |
|
Returns the number of rows that are affected by an UPDATE, INSERT, or DELETE statement or by a SQL_UPDATE, SQL_ADD, or SQL_DELETE operation in SQLSetPos. |
odbc sqlsetconnectattr |
|
Sets attributes that govern aspects of connections. |
odbc sqlsetcursorname |
|
Associates a cursor name with an active statement. |
odbc sqlsetdescfield |
|
Sets the value of a single field of a descriptor record. |
odbc sqlsetdescrec |
|
Sets multiple descriptor fields that affect the data type and buffer that are bound to a column or parameter. |
odbc sqlsetenvattr |
|
Sets attributes that govern aspects of environments. |
odbc sqlsetpos |
|
Sets the cursor position in a rowset and refreshes, updates, deletes, or adds data to the rowset. |
odbc sqlspecialcolumns |
|
Retrieves this information about columns
within a specified table:
|
odbc sqlsetstmtattr |
|
Sets attributes that are related to a statement. |
odbc sqlstatistics |
|
Retrieves a list of statistics about a single table and the indexes that are associated with the table. |
odbc sqltableprivileges |
|
Returns a list of tables and the privileges that are associated with each table. |
odbc sqltables |
|
Returns the list of table names that are stored in a specific data source. |