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.
Data structures for smart large objects
Declare a host variable

Declare a host variable

Declare HCL OneDB™ ESQL/C host variables for database columns of type CLOB or BLOB as a fixed binary host variable with the ifx_lo_t structure (called an ifx_lo_t data type) as follows:

EXEC SQL include locator;
⋮

EXEC SQL BEGIN DECLARE SECTION;
   fixed binary 'clob' ifx_lo_t clob_loptr;
   fixed binary 'blob' ifx_lo_t blob_loptr;
EXEC SQL END DECLARE SECTION;
⋮

EXEC SQL select blobcol into :blob_loptr from tab1;

Tip: For more information about the fixed binary HCL OneDB ESQL/C data type, see Access a fixed-length opaque type.

To access smart large objects, you must include the locator.h header file in your HCL OneDB ESQL/C program. This header file contains definitions of data structures and constants that your program needs to work with smart large objects.