Read and write smart large objects on an optical disc (UNIX)

Within a table, rows that include smart-large-object data do not include the smart-large-object data in the row itself. Instead, the smart-large-object column contains the LO-pointer structure. The LO-pointer structure can point to an sbpage in an sbspace or to a platter in an optical storage subsystem.

However, you can store smart large objects on optical disc only if this media is mounted as a UNIX™ file system and is write many (WMRM). The optical disc must contain the sbspaces for the smart large objects. Your application can use the HCL OneDB™ ESQL/C API for smart large objects to access the smart large objects on the mounted optical disc.

The database server does not provide support for a write-once-read-many (WORM) optical-storage subsystem as a location for smart large objects. However, it does support access to simple large objects (BYTE and TEXT) on WORM media.

For details about the optical subsystem, see your HCL® OneDB Administrator's Guide and the HCL OneDB Optical Subsystem Guide.