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?
Simple large objectsA simple large object is a large object that is stored in a blobspace on disk and is not recoverable.
The dispcat_pic programThe dispcat_pic program uses the ifx_loc_t locator structure to retrieve two simple-large-object columns. The program retrieves the cat_descr TEXT simple-large-object column and the cat_picture BYTE column from the catalog table of the stores7 demonstration database.
Load the simple-large-object images
Choose the image filesThe five cat_picture images are provided in the Graphics Interchange Format files, which have the .gif file extension.

Choose the image files

The five cat_picture images are provided in the Graphics Interchange Format files, which have the .gif file extension.

provides the images in .gif files to provide them in a standard format that can be displayed on all platforms or translated into other formats with filter programs that other vendors supply. The right column of the following table shows the names of the .gif files for the simple-large-object images.

Table 1. Image files for simple-large-object demo
Image	Graphics Interchange Format (.gif files)
Baseball glove	cn_10001.gif
Bicycle crankset	cn_10027.gif
Bicycle helmet	cn_10031.gif
Golf balls	cn_10046.gif
Running shoe	cn_10049.gif

The numeric portion of the image file name is the catalog_num value for the row of the catalog table to which the image is to be updated. For example, cn_10027.gif should be updated to the cat_picture column of the row where 10027 is the value of catalog_num.