A SELECT statement on a CLOB, BLOB, or opaque-type column
retrieves an LO handle for a smart large object. It does not retrieve
the actual data for the smart large object because this data is in
an sbspace.
To select a smart large object:
- Use a SELECT statement to retrieve the LO handle from the
CLOB, BLOB, or opaque-type column.
The LO handle identifies
the location of the smart large object on disk.
- Read the smart-large-object data from the sbspace of the
smart large object.
The LO handle identifies the smart
large object to open. After you open the smart large object, you obtain
an LO file descriptor, which you can use to read data from the sbspace
of the smart large object.