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 update Thread #, Gen Queue Records, Process Queue Records, and Include/Exclude flags by selecting source tables. 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.

Table List

Click the Table List button to enter a list of comma-separated table names that you want to update. The checkboxes for only the tables specified in the list are selected, and you can then perform actions on the selected tables. You can change the Thread #, Gen Queue Records, Process Queue Records, and Include/Exclude parameters for the given list of tables by using the Table List button.

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 assigned to thread 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 can be used to set the ReplTableXref.genqrec flag to FALSE for this table. The default setting for ReplTableXref.genqrec is True. If you need to change ReplTableXref.genqrec to False 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 Repl_TableXRef: GenQRec = FALSE. END.
Note: If Generate Queue Record is off, replication queue records is not generated 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 replqueue until Process Queue Records flag is 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.

The following video, you learn how to use the Pro2 Advanced Configuration tab to change thread assignments and other optional control flags: