Home | Previous Page | Next Page   Overview of IBM Informix ODBC Driver > Partially Supported and Unsupported ODBC Features >

Transaction Processing

IBM Informix ODBC Driver implementation of transaction isolation levels and transaction modes is slightly different from the Microsoft ODBC implementation of these features. The following sections describe the implementation of transaction isolation levels and transaction modes in IBM Informix ODBC Driver.

Transaction Isolation Levels

The following table lists the transaction isolation levels that IBM Informix ODBC Driver supports for these Informix database servers.

Database Servers Transaction Isolation Levels
Dynamic Server
  • SQL_TXN_READ_COMMITTED
  • SQL_TXN_READ_UNCOMMITTED
  • SQL_TXN_SERIALIZABLE
IBM Informix Extended Parallel Server
  • SQL_TXN_READ_COMMITTED
  • SQL_TXN_READ_UNCOMMITTED
  • SQL_TXN_SERIALIZABLE

Cursor stability. To use this isolation level, call SQLSetConnectOption() with the fOption value set to 1040 and vParam set to 1.

The default transaction isolation level is SQL_TXN_READ_COMMITTED. To change the transaction isolation level, call SQLSetConnectOption() with an fOption value of SQL_TXN_ISOLATION.

For more information about transaction isolation levels, see the SQL_DEFAULT_TXN_ISOLATION and SQL_TXN_ISOLATION_OPTION descriptions in the IBM Informix: Microsoft ODBC 3.0 Programmer's Reference.