Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ ODBC Driver GuideThe HCL OneDB™ ODBC Driver Programmer's Manual serves as a user guide and reference for HCL OneDB™ ODBC Driver, which is the HCL OneDB™ implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Smart large objectsThese topics describe how to store, create, and access a smart large object; how to transfer smart-large-object data; how to retrieve the status of a smart large object; and how to read or write a smart large object to or from a file.
Access a smart large objectThis section describes how to select, open, delete, modify, and close a smart large object by using either the standard ODBC API or by using ifx_lo functions.
Smart-large-object automationInstead of accessing smart large objects with the ifx_lo functions, you can access smart large objects by using the standard ODBC API.
Select smart large objects using the ODBC APIWhen you select a CLOB data type, the application binds the C type of the column as SQL_C_CHAR. When you select a BLOB data type, the C type is bound as SQL_C_BINARY.

Select smart large objects using the ODBC API

When you select a CLOB data type, the application binds the C type of the column as SQL_C_CHAR. When you select a BLOB data type, the C type is bound as SQL_C_BINARY.

HCL OneDB™ ODBC Driver selects smart large objects in the following way:

The driver sends a request to the database server to open the smart large object as a file on the server side.
The driver gets back the file descriptor (for example, lofd) of this file from the database server.
The driver sends the preceding lofd and a read request to the database server to read the smart-large-object data from the file.
The database server reads the data from the corresponding file by using the preceding lofd and sends it to the driver.
The driver writes the data to the buffer that was bound by the application with SQLBindParameter.