Use the options on the Actions tab
to select preferences for printing Column Map procedures, displaying
tabs in Action Request Editors, updating the Progress dialog, formatting
numeric values, and retaining process reports.
Column Map Procedure
- Max Print Lines
- Specify the maximum number of
lines to route to a process report. If the number of lines exceeds
this maximum, a warning message indicates that the output is incomplete.
- Warn if Missing Function
- Clear this check box to suppress the warning message
generated in the process report when a Load, CmStartTable, CmEndTable,
or UnLoad function is omitted from a Column Map Procedure.
Note: The CmTransform function
must be included in a Column Map Procedure.
- Prefix Output with Name
- Select the check box to include the name of the
Column Map procedure with the print output (default).
Note: When you
choose to include the name of the Column Map procedure with the print
output, and a Local (that is, unnamed) Column Map procedure is used,
a name for the Local Column Map procedure is automatically generated.
The name is generated using the corresponding table name, column name,
and a unique number as follows: tablename.columnname.n
Use the following options to modify
parts of the generated name for a Local Column Map procedure. By default
the full table name and column name are used.
- Show Full Table Name When Local Proc
- Select this check box to include the full table
name in the generated Local Column Map procedure name.
If
you clear this check box, use the From Left and From
Right controls to specify a subset of the table name. From
Left indicates the number of bytes to use from the beginning
of the table name. From Right indicates the
number of bytes to use from the end of the table name. (For example,
if the table name is CUSTOMERS, and you specify 4 for From
Left and 2 for From Right, the
subset of the table name used is CUSTRS.)
- Show Full Column Name When Local Proc
- Select this check box to include the full column
name in the generated Local Column Map procedure name.
If
you clear this check box, use the From Left and From
Right controls to specify a subset of the column name. From
Left indicates the number of bytes to use from the beginning
of the column name. From Right indicates the
number of bytes to use from the end of the column name. (For example,
if the column name is SALESMAN_ID, and you specify 0 for From
Left and 2 for From Right, the
subset of the column name used is ID.)
Note: You can specify 0 for From Left and
0 for From Right to indicate that no part of
the name is used. However, you must use part of either the table name
or the column name.
Column Map
- Max Shuffle Retries
- Default number of times the Column Map Shuffle Function
re-fetches a replacement value until a value that does not match the
source row is found (a "retry"). The Shuffle Function retry parameter
overrides this default.
Enter a value from 0-1000.
Enter 0 to allow a replacement value to match the source. The default
is 10.
Note: Using a high retry value with columns that contain
many duplicate value increases the processing time. For these columns,
it may be best to use a retry value of zero.
Action Display Defaults
- Show Currency Tab Page
- Select to display the Currency tab
in the Convert, Insert, and Load Request Editors.
- Show Age Tab Pages
- Select to display the Age
Function and Global Aging tabs
in the Convert, Insert, and Load Request Editors.
Note: You can override
these selections with commands available from the Options menu
in each Action Request Editor.
Monitor Update Frequency
- Rows
- Specify the number of rows (100 to 5000) to process
before updating the status message on the Progress dialog. The default
value is 100.
- Seconds
- Specify the number of seconds (5 - 60) to pass before
updating the process time on the Progress dialog. The default value
is 5.
Format Numeric Values
Select this check box to format
numeric values displayed on progress dialogs and in process reports
for all actions. Clear this check box to display numeric values without
formatting (that is, 99888).
For example, if you
select this check box and run the Extract Process, the Extract Request
Progress dialog would display 99,888 for the total number of rows
extracted, depending on the numeric format defined for Windows.
Note: To view the numeric format
for your workstation, select Regional Options from
the Control Panel and review the Numbers tab.
Report Retention
- Report Levels
- Specify the maximum number of reports
you can retain for each type of process. You can specify a value from
0 through 200. A value of 0 (default) disables the report retention
feature.
When the number of retained reports for
a particular type of process exceeds the maximum, the oldest report
is deleted and the current report is saved.
- Retain Scheduler/Command Line Reports
- Select to retain reports generated by processes
started using the Scheduler or the Command Line Interface. This check
box is cleared by default.
- Report Retention Directory
- Specify the complete path to the default directory
in which you want to store reports. Leave blank (default) to use the
Temporary Work Directory specified on the General tab.
To select from your system directories, click the browse button.
Note: It is recommended that each user
specify a private directory for storing reports.