Db2 ODBC support for ODBC features

Db2 ODBC supports ODBC 3.0 features with certain exceptions.

Db2 ODBC support should be viewed as consisting of most of ODBC 3.0 along with IBM® extensions. Where differences exist, applications should be written to the specifications defined in this publication.

Db2 ODBC supports the following ODBC functionality:
  • ODBC core conformance with the following exceptions:
    • Manipulating fields of descriptors is not supported. Db2 ODBC does not support SQLCopyDesc(), SQLGetDescField(), SQLGetDescRec(), SQLSetDescField(), or SQLSetDescRec().
    • Driver management is not supported. The ODBC driver manager and support for SQLDrivers() is not applicable in the Db2 for z/OS® ODBC environment.
  • ODBC level 1 conformance with the following exceptions:
    • Asynchronous execution of ODBC functions for individual connections is not supported.
    • Connecting interactively to data sources is not supported. Db2 ODBC does not support SQLBrowseConnect() and supports SQLDriverConnect() with SQL_DRIVER_NOPROMPT only.
  • ODBC level 2 conformance with the following exceptions:
    • Asynchronous execution of ODBC functions for individual statements is not supported.
    • Bookmarks are not supported. Db2 ODBC does not support SQLFetchScroll() with SQL_FETCH_BOOKMARK; SQLBulkOperations() with SQL_UPDATE_BY_BOOKMARK, SQL_DELETE_BY_BOOKMARK, or SQL_FETCH_BY_BOOKMARK; or retrieving bookmarks on column 0 with SQLDescribeColumn() and SQLColAttribute().
    • The SQL_ATTR_LOGIN_TIMEOUT connection attribute, which times out login requests, and the SQL_ATTR_QUERY_TIMEOUT statement attribute, which times out SQL queries, are not supported.
  • Some X/Open CLI functions
  • Some Db2 specific functions
.
The following Db2 features are available to both ODBC and Db2 ODBC applications:
  • The double-byte (graphic) data types
  • Stored procedures
  • Distributed unit of work (DUW) as defined by DRDA, two-phase commit
  • Distinct types
  • User-defined functions
  • Unicode and ASCII support
Db2 ODBC contains extensions to access Db2 features that can not be accessed by ODBC applications:
  • SQLCA access for detailed Db2 specific diagnostic information
  • Control over nul-termination of output strings
  • Support for large objects (LOBs) and LOB locators