The ifx_lo functions
This section describes how to select, open, delete, modify, and close a smart large object by using ifx_lo functions.
- Select a smart large object using ifx_lo functions
A SELECT statement does not perform the actual output for the smart-large-object data. It does, however, establish a means for the application to identify a smart large object so that the application can then perform operations on the smart large object. - Open a smart large object using ifx_lo functions
When you open a smart large object, you obtain a smart-large-object file descriptor for the smart large object. - Lightweight I/O
When the database server accesses smart large objects, it uses buffers from the buffer pool for buffered access. Unbuffered access is called lightweight I/O. - Smart-large-object locks
To prevent simultaneous access to smart-large-object data, the database server locks a smart large object when you open it. - 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. - Delete a smart large object
A smart large object cannot be deleted until certain conditions are met. - Modifying a smart large object
You can modify a smart large object by using either an UPDATE or INSERT statement. - Close a smart large object
After you finish modifying a smart large object, call ifx_lo_close() to deallocate the resources that are assigned to it. - Example of retrieving a smart large object from the database using ifx_lo functions
The code example, loselect.c, shows how to retrieve a smart large object from the database.
Parent topic: Access a smart large object