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
that is 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 the
name of the Column Map procedure is included 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 by 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 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.
The From Left entry indicates the number of
bytes to use from the beginning of the table name. The From
Right entry 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 that is 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.
The From Left entry indicates the number of
bytes to use from the beginning of the column name. The From
Right entry 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 that is 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
refetches 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 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 increases the processing time. For these columns,
it might 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
Specify the frequency with which
a progress dialog is updated during processing. (Increasing this value
might 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 - 60) to pass before
the process time is updated on the progress dialog. The default value
is 5.
Format Option
- Format Numeric Values
- Select this check box to format numeric
values that are displayed on progress dialogs and in process reports
for all actions. Clear this check box to display numeric values without
formatting (such as 99888).
Here is an 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 that are extracted, depending on the numeric format
that is 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
in 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 that are generated by processes
that are started with 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 (the default value)
to use the Temporary Work Directory that is 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.