Dirty Read isolation level and smart large objects

You can use the Dirty Read isolation level for smart large objects.

For information about how Dirty Reads affects consistency, see Dirty Read isolation.

Set the Dirty Read isolation level for smart large objects in one of the following ways:
  • Use the SET TRANSACTION MODE or SET ISOLATION statement.
  • Use the LO_DIRTY_READ flag in one of the following functions:
    • For DB-Access:mi_lo_open()
    • For ESQL/C:ifx_lo_open()

If consistency for smart large objects is not important, but consistency for other columns in the row is important, you can set the isolation level to Committed Read, Cursor Stability, or Repeatable Read and open the smart large object with the LO_DIRTY_READ flag.