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:
    • SQLColumnPrivileges
    • SQLDescribeParam (if EnableDescribeParam=1)
    • SQLForeignKeys
    • SQLTablePrivileges

    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 driver automatically determines whether the PostgreSQL database is a Unicode database.

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

  • Isolation and lock levels: The driver supports isolation levels 0 (read uncommitted), 1 (read committed), 2 (repeatable read), and 3 (serializable). The default is 1. In addition, it supports record-level locking.

    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.