Handling smart large objects

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.

Procedure

To retrieve the data in a smart large object column, follow these general steps:
  1. Retrieve the data row that contains the smart large object with the Change Data Capture API.
  2. Extract the values of columns that uniquely identify the data row, such as the primary key or a unique constraint.
  3. Run an SQL SELECT statement with the identifying values to retrieve the data row.
  4. Open the smart large object from the column in the data row.
  5. 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()
  6. Close the smart large object.