To display the Table Utility Options panel, select Table Utility Options from the Options menu on the action bar. This panel allows you to set options that control certain behaviors within the ISPF Table Utility.

These options on the first section of the panel affect the Edit and Browse functions:

Open table in SHARE mode

Select this option if the table you are to process is already open on another logical screen or if you might need to share the table with another logical screen.

Use EDIT as default to process selected table

When you select this option, you will default to Edit mode if you do not specify either the Edit or Browse functions on the table utility entry panel or the table selection panel. You will default to browse mode when this option is not selected.

Always save table in originating data set

When this option is selected: If the table you are editing was specified on the table utility entry panel but the Table data set was not specified, the table is automatically saved in the original data set.

When this option is cleared: When you first attempt to save the table, the table output data set selection panel will be displayed. This panel allows you to choose within the table DD the data set where the table will be saved.

Maximum rows searched to determine column width

To determine the width required to display each column field, the table utility scans the table rows and checks the length of the table variable values. This option allows you to specify a number which acts as the limit for the number of rows scanned in this process. If you leave this value blank, all rows will be scanned.

Note: Because the table utility uses an efficient method to scan a table, you can leave this option blank for all but extremely large tables.

Color used to display table key values

Use this option to specify the color (BLUE, RED, PINK, GREEN, TURQ, YELLOW, or WHITE) used to display the values for the key variable in the table. The default is GREEN.

Intensity used to display table key values

Use this option to specify the intensity (HIGH or LOW) used to display the values for the key variables in the table. The default is HIGH.

These options on the second section of the panel affect the Import function:

Warn if table exists in the output library

When this option is selected, a warning message will be displayed if you try to import data into a table that already exists in the specified output data set. You can then choose either to overwrite the existing table or to cancel the import process. If you don't want to receive warning messages in this situation, clear this option.

Use Edit to view the imported table

When this option is selected, the table utility uses the Edit function to display the table that was created or updated by the Import function. If this option is not set, the Browse function will be used to display the table.

These options on the final section of the panel affect the Export function:

Warn if export data set exists

When this option is selected, a warning message will be displayed if the data set you are exporting table data into already exists. You can then choose either to overwrite the data set or to cancel the export process. If you don't want to receive warning messages in this situation, clear this option.

Display mode for export data set

This option allows you to choose whether to use either the ISPF Browse, View, or Edit function to display the export data set after the export process has completed.