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 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 (i.e. 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
The following options allow you to
modify parts of the generated name for a Local Column Map procedure
(the full table name and column name are used by default).
- 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
will refetch 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 values will increase 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
Allows you to specify the frequency
with which a progress dialog is updated during processing. (Note that
increasing this value may enhance performance.)
- 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 to 60) to pass
before updating the process time on the progress dialog. The default
value is 5.
Format Options
- 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
(e.g., 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.
To view the numeric format for your workstation, select Regional
Options from the Control Panel and review the Numbers tab.
- View Report via .TXT application
- This check box is selected by default. It formats
the report as a .TXT file and opens automatically using an application
such as Notepad.
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
invoked 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.