ADD_CDCG_WATCH_BDΒΆ

Add BDomain spcific settings to a CDCG watcher.

Parameter Name

Required

DefaultValue

Description

p_cdc_group

yes

cdc group

p_bdomain

yes

bdomain

p_src_db_name

yes

source database name

p_src_connection

yes

source connection

p_bdate_change_offset

yes

bdate change offset

p_src_where_clause

yes

source where clause

p_active

yes

true

active

p_cdc_min_intv

yes

cdc min interval

Example

EXECUTE SCRIPT api_dbiadm.add_cdcg_watch_bd
           ( 'MYTEST'         -- p_cdc_group
           , 'R33'            -- p_bdomain
           , 'testsrcdbname'  -- p_src_db_name
           , 'ZDW_R32_A'      -- p_src_connection
           , 10               -- p_bdate_change_offset
           , '1=2'            -- p_src_where_clause
           , false            -- p_active
           , 10               -- p_cdc_min_intv
           );