Try OpenEdge Now
skip to main content
Managing Change Data Capture in Databases
Managing Change Data Capture in a Database : Creating a Change Data Capture policy : Selecting Change Data Capture fields
 

Selecting Change Data Capture fields

The Create Change Data Capture policy page allows you to add CDC fields to a CDC policy when the policy level is defined as Minimal with BitMap (1), Medium (2), or Maximum (3). Adding CDC fields to a CDC policy creates a CDC field policy for that policy.
To add CDC fields to a CDC policy:
1. In the Create Change Data Capture policy page, select Level as Minimal with BitMap (1), Medium (2), or Maximum (3).
The Select Change Data Capture Fields section appears and lists all the fields of the selected table and provides the following information:
*Field name — The name of the field.
*Data type — The type of data the data element stores.
*Enable identifying field — Sets the field as an Identifying field.
*Field order — Defines the order of the Identifying field.
*Description — The description of the field.
2. Select the fields you want to add to the CDC policy.
3. To set the selected field as an Identifying field, click the toggle box in the Enable identifying field column and set it to YES.
To enable this column, select the Identifying fields check box. Selecting this check box allows you to set the fields as Identifying fields and creates an index on the change table.
To disable this column, clear the Identifying fields check box. The selected fields will no longer be set as Identifying fields.
Note: For a CDC field policy, you can add up to 15 Identifying fields.
4. To define the order of the Identifying fields, select or type a value (1 to 15) in the Field order column.
The Field order column is enabled only when the Enable identifying field column is set to YES.
Note: If you deselect few CDC fields after defining the field order values, ensure that you reset the values for the selected Identifying fields in a sequential order.