Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
ESQL/C GuideThe HCL OneDB™ ESQL/C Programmer's Manual explains how to use , the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
What is HCL OneDB™ 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 HCL OneDB™ Guide to SQL: Syntax.