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 topics explain how to use HCL OneDB™ ESQL/C, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. The HCL® OneDB® ESQL/C Programmer's Manual explains how to use HCL OneDB™ ESQL/C, 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.
Duration of an open on a smart large object

Duration of an open on a smart large object

After you open a smart large object with the ifx_lo_create() function or the ifx_lo_open() function, it remains open until one of the following events occurs:

The ifx_lo_close() function closes the smart large object.
The session ends.

The end of the current transaction does not close a smart large object. It does, however, release any lock on a smart large object. Have your applications close smart large objects as soon as they finish with them. Leaving smart large objects open unnecessarily consumes system memory. Leaving a sufficient number of smart large objects open can eventually produce an out-of-memory condition.