Data for capture

You can capture most HCL OneDB™ data types. You can specify the data to capture at the column level.

The following data types are not supported for data capture:
  • Simple large objects (TEXT and BYTE data types)
  • User-defined data types
  • Collection data types (SET, MULTISET, LIST, and ROW data types)

Specifying what data to capture

You specify a table and which columns from that table to capture with the cdc_startcapture() function. You must run the cdc_startcapture() function once for each table that you want to capture. For information about which tables and columns are currently being captured, look in the syscdctabs table.

Ending capture of a table

To stop data capture of a specific table, run the cdc_endcapture() function. After you run cdc_endcapture() function, information about that table is removed from the syscdctabs table.