Expand description
Reexport odbc-sys as ffi
Structs
Enums
Governs behaviour of EnvironmentAttribute
Codes used for FetchOrientation in
SQLFetchScroll
, SQLDataSources
and in SQLDrivers
SQL Free Statement options
Represented in C headers as SQLSMALLINT
Information requested by SQLGetInfo
Used by
SQLBindParameter
.Used by
SQLDescribeCol
.ODBC verions
Indicates the overall success or failure of the function
Supported
SQLBulkOperations
operationsThe C data type is specified in the SQLBindCol and SQLGetData functions with the TargetType
argument and in the SQLBindParameter function with the ValueType argument.
Completion types for
SQLEndTrans
Connection attributes for
SQLSetConnectAttr
SQL Data Types
Options for
SQLDriverConnect
DiagIdentifier
for SQLGetDiagField
Statement attributes for
SQLSetStmtAttr
Constants
Extended C Types range 4000 and above. Range of -100 thru 200 is reserved by Driver Manager.
Maximum message length
Functions
Allocates an environment, connection, statement, or descriptor handle.
Binds application data bufferst to columns in the result set.
Binds a buffer to a parameter marker in an SQL statement
SQLBrowseConnect supports an iterative method of discovering and enumerating the attributes
and attribute values required to connect to a data source.
Each call to SQLBrowseConnect returns successive levels of attributes and attribute values.
Performs bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark.
Cancels the processing on a statement.
Cancels the processing on a connection or statement.
Closes a cursor that has been opened on a statement and discards pending results.
Returns descriptor information for a column in a result set.
Descriptor information is returned as a character string,
a descriptor-dependent value, or an integer value.
Returns a list of columns and associated privileges for the specified table.
The driver returns the information as a result set on the specified StatementHandle.
Returns the list of column names in specified tables.
The driver returns this information as a result set on the specified StatementHandle.
Can be used to determine when an asynchronous function is complete using either notification- or polling-based processing.
SQLConnect establishes connections to a driver and a data source. The connection handle
references storage of all information about the connection to the data source, including
status, transaction state, and error information.
SQLConnect establishes connections to a driver and a data source. The connection handle
references storage of all information about the connection to the data source, including
status, transaction state, and error information.
Copies descriptor information from one descriptor handle to another.
Returns information about a data source. This function is implemented only by the Driver
Manager.
Returns information about a data source. This function is implemented only by the Driver
Manager.
Returns the result descriptor for one column in the result set — column name, type, column
size, decimal digits, and nullability.
Returns the result descriptor for one column in the result set — column name, type, column
size, decimal digits, and nullability.
Returns the description of a parameter marker associated with a prepared SQL statement.
This information is also available in the fields of the IPD.
Closes the connection associated with a specific connection handle.
An alternative to
SQLConnect
. It supports data sources that require more connection
information than the three arguments in SQLConnect
, dialog boxes to prompt the user for
all connection information, and data sources that are not defined in the system informationAn alternative to
SQLConnect
. It supports data sources that require more connection
information than the three arguments in SQLConnect
, dialog boxes to prompt the user for
all connection information, and data sources that are not defined in the system informationLists driver descriptions and driver attribute keywords. This function is implemented only
by the Driver Manager.
Lists driver descriptions and driver attribute keywords. This function is implemented only
by the Driver Manager.
Requests a commit or rollback operation for all active operations on all statements associated with a handle.
Executes 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 one-time execution
Executes 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 one-time execution
Executes a prepared statement, using the current values of the parameter marker variables
if any paramater markers exis in the statement.
SQLFetch fetches the next rowset of data from the result set and returns data for all bound
columns.
Fetches the specified rowset of data from the result set and returns data for all bound columns.
Rowsets can be specified at an absolute or relative position or by bookmark.
Can return:
Frees resources associated with a specific environment, connection, statement, or
descriptor handle.
Stops processing associated with a specific statement, closes any open cursors associated
with the statement, discards pending results, or, optionally, frees all resources
associated with the statement handle.
Returns the current setting of a connection attribute.
Returns the cursor name associated with a specified statement.
Returns the current setting or value of a single field of a descriptor record.
Returns the current settings or values of multiple fields of a descriptor record.
The fields returned describe the name, data type, and storage of column or parameter data.
Returns the current value of a field of a record of the diagnostic data structure (associated with a specified handle) that contains error, warning, and status information.
Return the current values of multiple fields of a diagnostic record that contains eror,
warning, and status information.
Return the current values of multiple fields of a diagnostic record that contains eror,
warning, and status information.
Gets attributes that govern aspects of environments
Returns general information about the driver and data source associated with a connection
Returns general information about the driver and data source associated with a connection
Returns the current setting of a statement attribute.
Determines whether more results are available on a statement
containing SELECT, UPDATE, INSERT, or DELETE statements and, if so, initializes processing for those results.
Returns the number of columns in a result set
Compiles the statement and generates an access plan.
Compiles the statement and generates an access plan.
Returns the number of rows affected by an UPDATE, INSERT, or DELETE statement; an
SQL_ADD
,
SQL_UPDATE_BY_BOOKMARK
, or SQL_DELETE_BY_BOOKMARK
operation in SQLBulkOperations; or an
SQL_UPDATE
or SQL_DELETE
operation in SQLSetPos
.Sets attributes that govern aspects of connections.
Sets attributes that govern aspects of connections.
Sets attributes that govern aspects of environments
Sets attributes related to a statement.
Sets attributes related to a statement.
Returns the list of table, catalog, or schema names, and table types, stored in a specific
data source. The driver returns the information as a result set
Returns the list of table, catalog, or schema names, and table types, stored in a specific
data source. The driver returns the information as a result set
Type Definitions
The connection handle references storage of all information about the connection to the data
source, including status, transaction state, and error information.