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.
The ifx_lo functionsThis section describes how to select, open, delete, modify, and close a smart large object by using ifx_lo functions.
Duration of an open operation on a smart large objectAfter you open a smart large object with the ifx_lo_create() function or the ifx_lo_open() function, it remains open until certain events occurs.

Duration of an open operation 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 certain events occurs.

A smart large object remains open until one of these events occur:

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

Important: The end of the current transaction does not close a smart large object. It does, however, release any lock on a smart large object.

Close smart large objects as soon as you finish with them. Leaving smart large objects open unnecessarily uses system memory. Leaving many smart large objects open can eventually produce an out-of-memory condition.