|
Along with the file with results script common for all rules (see "Settings"
for details), the program allows you to create output files individual for each rule.
Use the "Output" control element to specify the file name.
"Preview sample data" feature allows you to view sample data generated by
the current rule.
Scripts tab allows you to specify prologue and epilogue SQL scripts for current rule.

The "Where" field is used for Update Mode and Scramble Mode only. It can cut down the list of
rows to be used when the rule is carried out. By default, all data rows are processed for these modes.
The "Target" field is only used for Scramble Mode to specify the table where data rows will arrive after they
are processed.
The button with the "?" sign allows you to get additional information about the table:
indexes, triggers and check constraints. This information will help you to create more
efficient rules and projects.
With local menu of the column list you can to:
- select, clear or reverse selection of the fields;
- set Ignore fill method for all selected fields. This option most useful for Update and Scramble modes.
"Sequence length" (one by default) is a number of equal values in sequence which the program will generate.
There are three quotation modes:
- By default the program uses column data type to identify quotation mode.
- No quote should be used in case the program haven't required information: formulas or another difficult cases.
- Quote always. This mode suitable in case the program could not recognize database specific data type.
Note: the program tries to find a mask or a Values Library item for some well known field names
automatically in order to make the data more realistic. Of course, you can edit automatically created
values in the "Data Rule" window.
See also: row count management, Table fill modes.
|