The following table provides a list of properties for ICdcTablePolicy interface:
Table 1. ICdcTablePolicy properties
Property Data type Access Description
Name CHARACTER Readable, Writeable The name of the policy provided by the user.
CdcPolicyId CHARACTER Readable The UUID generated by ABL Virtual Machine (AVM). This is a case-sensitive system field.
Description CHARACTER Readable, Writeable (Optional) The description of the policy provided by the user.
State CdcTablePolicyStateEnum Readable, Writeable The internal state of the policy.

Set the value to CDCTablePolicyStateEnum: Active or CDCTablePolicyStateEnum: Inactive to make the policy active or inactive respectively.

Instance CdcTablePolicyInstanceEnum Readable The policy on the source table. This is a system field.

The instance values are 0, 1, and 2 for Current policy, Previous policy, and Pending policy respectively.

Table ITable Readable, Writeable The source table from which the changes are captured.

The source table can be a PUB or non-PUB table.

ChangeTable CHARACTER Readable, Writeable The name of the change table created by AVM for this policy. This is a system field.
Note: The value will be unknown until the policy is made active and the _Level column is greater than 0.
ChangeTableOwner CHARACTER Readable, Writeable (Optional) The name of the non-PUB or PUB owner of the change table.

If the non-PUB owner value is not set, the property chooses the PUB owner value as the default value.

IdentifyingField LOGICAL Readable, Writeable Set the value to YES to create an index on the change table for the fields in the related _Cdc-Field-Policy records that have a non-zero value in the _Identifying-Field column of the _Cdc-Field-Policy.
Level CdcTablePolicyLevelEnum Readable, Writeable The level of data that is captured on the source table.
The levels are:
  • Minimal(0)
  • MinimalWithBitMap(1)
  • Medium(2)
  • Maximum(3)
EncryptPolicy LOGICAL Readable, Writeable The encryption policy used for the change table.

When the source table is encrypted and the value is set to YES, the AVM uses the same encryption policy of the source table to encrypt the change table.

DataArea IArea Readable, Writeable The storage area where the change table is created by AVM. This is a Type II area.

The AVM creates a change table when the value of _Level column is 1, 2 or 3.

IndexArea IArea Readable, Writeable The storage area where the change table indices are created by AVM. This is a Type II area.

The AVM creates change table indices when the value of _Level column is 1, 2 or 3 and the _Identifying-Field is set to YES.

FieldPolicies ICdcFieldPolicySet Readable, Writeable The collection of CDC field policies of a CDC table policy.
LastModified DateTime-TZ Readable The time the _Policy-Instance was last modified.