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.

personal options actions tab, explained below

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.