The Change Data Capture API does not directly support the
retrieval of smart large object column data from a captured BLOB or
CLOB row. You must use the DataBlade
API or
client API smart large object read functions to retrieve smart large
objects.
To retrieve the data in a smart large object column,
follow these general steps:
- Retrieve the data row that contains the smart large object
with the Change Data Capture API.
- Extract the values of columns that uniquely identify the
data row, such as the primary key or a unique constraint.
- Run an SQL SELECT statement with the identifying values
to retrieve the data row.
- Open the smart large object from the column in the data
row.
- Retrieve the smart large object data by using one of the
following types of smart large object functions:
- DataBlade
API functions,
such as mi_lo_read(), mi_lo_to_buffer(),
or mi_lo_to_file()
- SQL functions such as LOTOFILE()
- ESQL/C functions such as ifx_lo_read()
- Close the smart large object.