Crate ibm_db[−][src]
Expand description
IBM_DB
ibm_db
is a library for connecting to DB2.
Re-exports
Structs
Represents a connection to an ODBC data source
Used to retrieve data from the fields of a query result
Holds name and description of a datasource
ODBC Diagnostic Record
Struct holding information available on a driver.
Handle to an ODBC Environment
A Statement
can be used to execute queries and retrieves results.
Enums
Statement
state used to represent a freshly allocated connection
Governs behaviour of EnvironmentAttribute
Codes used for FetchOrientation in SQLFetchScroll
, SQLDataSources
and in SQLDrivers
SQL Free Statement options
Represented in C headers as SQLSMALLINT
Statement
state used to represent a statement with a result set cursor. A statement is most
likely to enter this state after a SELECT
query.
Information requested by SQLGetInfo
Used by SQLBindParameter
.
Statement
state used to represent a statement with no result set. A statement is likely to
enter this state after executing e.g. a CREATE TABLE
statement
Used by SQLDescribeCol
.
ODBC verions
Statement
state used to represent a statement compiled into an access plan. A statement will
enter this state after a call to Statement::prepared
Holds a Statement
after execution of a query.Allocated
Indicates the overall success or failure of the function
Supported SQLBulkOperations
operations
The 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
Statics
Traits
Allows retrieving a diagnostic record, describing errors (or lack thereof) during the last operation.
Reflects the ability of a type to expose a valid handle
Indicates that a type can be retrieved using Cursor::get_data
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 information
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 information
Lists 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.
SQLGetTypeInfo returns information about data types supported by the data source. The driver returns the information in the form of an SQL result set. The data types are intended for use in Data Definition Language (DDL) statements.
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
Creates an ODBC Environment and declares specification of version 3.0 are used
Type Definitions
Statement
state used to represent a statement with a result set cursor. A statement is most
likely to enter this state after a SELECT
query.
Result type returned by most functions in this crate
The connection handle references storage of all information about the connection to the data source, including status, transaction state, and error information.
Environment state used to represent that environment has been set to odbc version 3
Define fixed size integer types.