This ABL procedure dumps Change Data Capture (CDC) policies from your database.
Note: Before you begin, ensure that the database is running and Change Data Capture is enabled.
Run the following procedure from your Procedure Editor window:
Syntax
run prodict/dump_cdc.p( policy-name,output-dir,codepage ).
Parameters
policy-name
Specify the policy name(s) to dump. All valid values must be surrounded by quotations and they include:
"ALL" — Dump all current policies for the database.
"policy-name" — Dump the named policy.
"policy-list" — Dump the policy list. The list must be a comma-separated list.
Note: If you specify a non-existing policy to dump, the dumping procedure reports an error.
output-dir
Specify the directory where the .cd file that has the dump data of the specified policies is to be created. This directory is relative to your defined working directory.
codepage
Specify the code page format in which you want the CDC policies to be dumped. Valid values include:
? — No code page conversions occur.
"" — Default code page conversions occur.
"target-codepage" — The code page to which the target object is converted.
Example
You can also run the dump procedure from the proenv command line. The following example demonstrates dumping all the policies from a database named cdc_sample_db, to the working directory with the default code page.
"ALL" — Dump all current policies for the database.
