Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
ESQL/C GuideThe Informix® ESQL/C Programmer's Manual explains how to use Informix® ESQL/C, the Informix® implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
What is Informix® ESQL/C?
Smart large objectsA smart large object is a data type that stores large, non-relational data objects such as images, sound clips, documents, graphics, maps and other large objects, and allows you to perform read, write, and seek operations on those objects.
Accessing a smart large object
Open a smart large objectWhen you open a smart large object, you obtain an LO file descriptor for the smart large object. Through the LO file descriptor, you can access the data of a smart large object as if it were in an operating-system file.
Access modesWhen you open a smart large object, you specify the access mode for the data.
Set dirty read access mode

Set dirty read access mode

To set dirty read isolation mode for a smart large object, set it for the transaction with the SET ISOLATION statement, or set the LO_DIRTY_READ access mode when you open the smart large object. Setting the LO_DIRTY_READ access mode when you open the smart large object affects the read mode only for the smart large object and not for the entire transaction. In other words, if your transaction is executing in committed-read mode, you can use the LO_DIRTY_READ access mode to open the smart large object in dirty-read mode, without changing the isolation mode for the transaction.

For more information about dirty read isolation mode, see the SET ISOLATION statement in the Informix® Guide to SQL: Syntax.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.