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.
Data structures for smart large objects
The LO-pointer structure

The LO-pointer structure

To open a smart large object for read and write operations, the program must have an LO-pointer structure for the smart large object. This structure contains the disk address and a unique hexadecimal identifier for a smart large object.

To create an LO-pointer structure for a new smart large object, use the ifx_lo_copy_to_file() function. The ifx_lo_copy_to_file() function performs the following tasks:

It initializes an LO-pointer structure, whose pointer you provide as an argument, for the new smart large object.
This new smart large object has the storage characteristics that the LO-specification structure you provide specifies.
It opens the new smart large object in the specified access mode and returns an LO file descriptor that is needed for subsequent operations on the smart large object.

You must call ifx_lo_def_create_spec() before you call the ifx_lo_create() function to create a new smart large object.