MODIFY_CDCG_WATCH_BD

Modify BDomainsettings for a CDCG watcher.

Parameter Name

Required

DefaultValue

Description

p_cdc_group

yes

cdc group

p_bdomain

yes

p_src_db_name

yes

(null to keep unchanged, ‘ ‘ to clear value)

p_src_connection

yes

(null to keep unchanged, ‘ ‘ to clear value)

p_bdate_change_offset

yes

(null to keep unchanged, ‘ ‘ to clear value)

p_src_where_clause

yes

(null to keep unchanged, ‘ ‘ to clear value)

p_active

yes

(null to keep unchanged)

p_cdc_min_intv

yes

(null to keep unchanged, ‘ ‘ to clear value)

Example

EXECUTE SCRIPT api_dbiadm.modify_cdcg_watch_bd
           ( 'MYTEST'             -- p_cdc_group
           , 'R33'                -- p_bdomain
           , 'neusrourec'         -- p_src_db_name
           , null                 -- p_src_connection
           , null                 -- p_bdate_change_offset
           , 'WHERE clause here'  -- p_src_where_clause
           , null                 -- p_active
           , '10'                 -- p_cdc_min_intv
           );