This window allows you to change thread assignments and other optional control flags.

Global Controls

You can use the Global Controls drop down menus to multi-select and configure Source Tables, Thread #, Gen Queue Records, Process Queue Records, and Include/Exclude. If you use the Select All Source Tables option, then all of the tables that are listed are selected and are affected by your following actions. This includes tables on multiple pages.

Source Tables

The Source Tables column consists of the mapped and cross-referenced tables that are mapped in the Mapping section.

Thread #

The Thread # specifies which thread the table is in. Mapped tables can be shared with up to five separate threads. By default, all mapped tables are put in queue 1.

Gen Queue Records

The Gen Queue Records is used to stop/start generating replqueuerecords for the selected table (i.e., turn off replication but leave triggers in schema), as well as disable CDC policies or triggers depending on the method you are using. It sets ReplTableXref.genqrecto FALSE for this table. Default is checked. If it is desired do this for an entire database, the following ABL code can be run from the Progress Editor to stop generating queue records for all tables: FOR EACH ReplTableXref: genqrec = FALSE. END.
Note: If Generate Queue Record is off, replication queue records is skipped for that table even if Process Queue Records is on.

Process Queue Records

Process Queue Records is used to monitor on any replqueue records that are generated. If the checkbox is unchecked, the Replqueue records are not processed (i.e., replicated). Queue records stay in queue until Process Queue Recordsis selected. It is selected by default. Process Queue Records functions similarly to the option for Generate Queue Record but sets ReplTableXref.procqrec to FALSE.

Include/Exclude

Include/Exclude is selected by default. If this is unchecked, any changes to the schema for this table will not be included in the Differential Schema generated by the Generate Schema window.