ADD_CDCG_WATCHΒΆ

Add new CDC Watch Group.

Table: DBIADM.DBI_CDCG_WATCH (Definition of the event that triggers data capture)

Parameter Name

Properties

Default Value

Parameter Description

p_cdc_group

(PK)(NN)

Change data capture group: the name for a group of objects (e.g. tables) that will be loaded together

p_src_schema

Schema name on the source system that holds the object (column SRC_TABLE) that needs to be monitored for the triggering event

p_src_table

Object name on the source system that needs to be monitored for the triggering event

p_src_watch_id_expr

(NN)

SQL expression to be executed on the source object (SRC_TABLE) to check if the triggering event occurred

Example

EXECUTE SCRIPT api_dbiadm.add_cdcg_watch
            ( 'XXXXXXXXXXXX'    -- p_cdc_group
            , 'XXXXXXXXXXXX'    -- p_src_schema
            , 'XXXXXXXXXXXX'    -- p_src_table
            , 'XXXXXXXXXXXX'    -- p_src_watch_id_expr
            );