TV 3.7.0
¶ 1. Add a CDC group
To add a change data capture (cdc) group one needs to provide the name of the cdc group as well as if a bdate is needed or not as true or false to the script API_DBIADM.ADD_CDC_GROUP.
Additionally a description can also be added as can be seen in the example below.
¶ Example
EXECUTE SCRIPT API_DBIADM.ADD_CDC_GROUP(
'tst_cdc_grp' -- p_cdc_group
,'Test CDC group for Person' -- p_description
,false -- p_bdate_needed
);
By running the command above a new entry is added to the table DBIADM.DBI_CDC_GROUPS.
| cdc_group | description | bdate_needed |
|---|---|---|
| tst_cdc_grp | Test CDC group for Person | false |
¶ 2. Modify a CDC group
To modify the parameters of a cdc group one has to provide the name of the cdc group that should be modified to the script API_DBIADM.MODIFY_CDC_GROUP. To retain the value of any of the parameters a null value has to be provided, otherwise the value will be overwritten.
In the example below the description is changed.
¶ Example
EXECUTE SCRIPT API_DBIADM.MODIFY_CDC_GROUP(
'tst_cdc_grp' -- p_cdc_group
,'Changed description' -- p_description
,null -- p_bdate_needed
);
The change, after having issued the command above, can be seen in the entry for the cdc group 'tst_cdc_grp' in the table DBIADM.DBI_CDC_GROUPS, as is shown below.
| cdc_group | description | bdate_needed |
|---|---|---|
| tst_cdc_grp | Changed description | false |
¶ 3. Remove a CDC group
If a cdc group should be removed, one only has to provide the name to the script API_DBIADM.REMOVE_CDC_GROUP as can be seen in the example below. Additionally a bdomain can be provided as well, to remove the cdc group from one specific bdomain. By providing an empty string the cdc group is removed from all bdomains.
¶ Example
EXECUTE SCRIPT API_DBIADM.REMOVE_CDC_GROUP(
'tst_cdc_grp' -- p_cdc_group
,'' -- p_bdomain
);
After the command above has been issued, the entry for the cdc group 'tst_cdc_grp' is deleted from the table DBIADM.DBI_CDC_GROUPS.