The Level 1 interface conformance level provides functionality that
allows application developers to build a wider variety of full-featured applications than
is possible with Core level functionality. It includes all of the Core interface
conformance level functionality, plus additional features that are usually available in
On-Line Transaction Processing (OLTP) relational DBMSs. A Level 1
interface conformant driver, in addition to the features in the Core interface
conformance level, lets the application do the following:
- Specify the schema of database tables and views (using two-part naming
conventions).
- Invoke true asynchronous execution of ODBC functions, where applicable.
ODBC functions can either be all synchronous or all asynchronous on a given connection.
- Use scrollable cursors, and thereby obtain access to a result data set in
directions other than forward-only by calling SQLFetchScroll with the FetchOrientation
argument other than SQL_FETCH_NEXT.
- Obtain primary keys of tables by calling SQLPrimaryKeys
- Use stored procedures (through the ODBC escape sequence for procedure
calls) and query the data dictionary for information about stored procedures by calling SQLProcedureColumns
and SQLProcedures.
- Connect to a data source by interactively browsing a list of available
servers by calling SQLBrowseConnect
- Use ODBC functions instead of SQL statements to perform certain database
operations. For example, use SQLSetPos with SQL_POSITION and SQL_REFRESH.
- Gain access to the contents of multiple result data sets generated by
batch SQL submissions and stored procedures by calling SQLMoreResults
- Delimit transactions spanning several ODBC functions with true atomicity.
- Roll back a transaction by calling SQLEndTran with SQL_ROLLBACK.