Actions tab

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.

Example of the Actions tab on the Personal Options dialog, described as follows.

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.


Feedback