Dirty Read and Smart Large Objects

You can use the Dirty Read isolation level for smart large objects. For information on 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:
  • mi_lo_open()
  • 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.