Driver specifications

This section describes the general functionality supported by the driver.

• ODBC compliance: The driver is Level 1 compliant, that is, it supports all ODBC Core and Level 1 functions.
  In addition, the following functions are supported:

  • SQLProcedures
  • SQLProcedureColumns

  Refer to ODBC API and scalar functions in the Progress DataDirect for ODBC Drivers Reference for a list of supported API functions.

• Unicode support: The Db2 Wire Protocol driver supports Unicode data types if the database was created with a multi-byte character set.

  The driver maps the Db2 data types to Unicode data types as shown in the following table:

  Db2 Data Type	Mapped to. . .
  Dbclob1	SQL_WLONGVARCHAR
  Graphic	SQL_WCHAR
  Long Vargraphic	SQL_WLONGVARCHAR
  Vargraphic	SQL_WVARCHAR

  Refer to Internationalization, localization, and Unicode in the Progress DataDirect for ODBC Drivers Reference for details.

• Isolation and lock levels: The driver supports isolation level 0 (read uncommitted), isolation level 1 (read committed), isolation level 2 (repeatable read), isolation level 3 (serializable), and, on Db2 for i only, isolation level 4 (none).

  Refer to Locking and isolation levels in the Progress DataDirect for ODBC Drivers Reference for details.

• Connections and statements supported: The driver supports multiple connections and multiple statements per connection.