|
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.
|