The Set Loader Rules In Set tab is designed to provide information on the rules contained in the current loader set. Note that the Set Loader application has no ability to save changes back to the loader set. All updates to the loader rules and loader set structure must be made using the Set Designer application. The primary function of the Set Loader application is to run the rules and, although the rules can be temporarily disabled in the Set Loader, those changes cannot be saved back to the loader set.

The DataBee Set Loader Rules In Set Tab

The panel at the top of the Rules In Set tab lists the rules contained within the currently active loader set. Be aware that the order of the rules in the display is not necessarily the order in which the rules will execute - the rules can be sorted by the various columns which dramatically changes the order presented visually on the screen. To adjust the execution order of the loader rules, use rule blocks.

There are five vertical columns in the loader rule display. These columns provide summary information on the configuration of the rule. Double click on any rule to fully view it's contents.

What the columns in the Rules Panel mean

Rule#

This column indicates the rule block and ID number of the rule and also contains a small icon which indicates the loader rule type.

Rule Controller

Load Manager rule

Truncate Manager rule

Foreign Key Enable Rule

Foreign Key Disable Rule

Trigger Enable Rule

Trigger Disable Rule

Command rule

The rule block and ID number are displayed as a sequence of digits in the form XX-YYYY. The XX value is the rule block and the YYYY component is the rule ID. The ID of the rule is not particularly significant and serves only to provide a unique identification number for the rule. The rule block, however, is of considerable significance since it controls the execution order of the rule. The DataBee Set Loader software is multi-threaded and can run up to eight rules in parallel. It is almost always the case within a loader set that most rules cannot run simultaneously and must run sequentially one after the other as a chain. The rule block value controls the execution sequence. Please see the discussion of Rule Blocks in the loader set overview help page and view the Creating a New Loader Set tutorial [(local) (internet)] in order to understand how to explicitly control the execution order of the loader rules. Note that the loader rules can be sorted in any order by clicking on the column headers. The presentation order on the display will not change the execution order in any way since the execution order is totally dependent on the rule block configuration. The rule block and the rule ID can be modified in the Set Designer application (not in the Set Loader) by clicking it with the mouse and editing the value as appropriate.

Rule Type

This column contains descriptive text indicating the type of loader rule which is represented by that line of the display.

Source

Some descriptive text describing the actions for each rule.

Target

This area lists the object on which the loader rule will operate. For most loader rules, this is the schema name associated with the Rule Controller which owns the rule.

Description

All rule types can have an optional description associated with them. Descriptions are useful documentation which clarifies the purpose of a rule.

What the buttons do

Disable Rule

This button disables a loader rule in the loader set. This change is only temporary as the Set Loader application has no way to save any changes to the loader set on disk. All permanent updates to the loader set must be performed by the Set Designer application.

View Rule

Launches the rule in a separate form to its contents can be viewed. Double clicking with the mouse on the rule also perform this operation.