Object List Options (1 of 2) panel

Panel and field definitions

  Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)     FM/Db2 Object List Options (1 of 2)          Global Settings

 Object List Utility Options:
    Enter "/" to select option
       Show all catalog table columns
       Show "unused" catalog table columns
       Show "internal use only" catalog table columns
    /  Use automatic column sizing
       Use extended column name headings
    /  Interpret columns containing codes
    /  Modify order of columns displayed

    Row count . . . . . 1000           Maximum number of rows to fetch

 More Options:
    Enter "/" to select option
    /  Display widths, filtering


 Command ===>                                                                   
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=PrvPage  F11=NxtPage  F12=Cancel

Show all catalog table columns

Display of catalog table information includes every available column, including any columns marked as "unused" or "internal use only" in the DB2 for z/OS SQL Reference. This option overrides any settings for the Show "unused" catalog table columns and Show "internal use only" catalog table columns options.

The default is not selected.

Show "unused" catalog table columns

Display of catalog table information includes columns marked as "unused" in the DB2 for z/OS SQL Reference. This option can be overridden by selecting the Show all catalog table columns option.

The default is not selected.

Show "internal use only" catalog table columns

Display of catalog table information includes columns marked as "internal use only" in the DB2 for z/OS SQL Reference. This option can be overridden by selecting the Show all catalog table columns option.

The default is not selected.

Use automatic column sizing

Varying-length (VARCHAR) columns of the catalog table being displayed may be automatically sized, based on the data stored within the column. Automatic column sizing determines the longest data value in each varying column as the data is read from Db2®. This value is then used to set the display width for the column, prior to the data being displayed.

The default is selected.

Use extended column name headings

Column names for the catalog table being processed are replaced by longer, more meaningful, column headings.

The default is selected.

Interpret columns containing codes

Selected columns in the Db2® catalog table being processed are expanded, based on the value stored within the column. This feature typically operates on one-character columns that contain a code. As an example, the TYPE column in SYSIBM.SYSTABLES is a one-character code containing A,G,M,T,V, or X. The expanded text for these codes is "Alias", "Created global temporary table", "Materialized query table", "Table", "View", and "Auxiliary Table".

This option is useful if you are not familiar with the meanings of the codes in the various Db2® catalog tables. Selecting this option overrides any setting for the Use extended column name headings option, and sets that option on.

The default is selected.

Modify order of columns displayed

Columns in the Db2® catalog table may be re-ordered from the order as defined in the Db2® catalog. In addition certain columns may be marked as held. This feature is intended to place the most important columns from the catalog table on the left of the display, in the most logical order. These columns are held, and do not move when scrolling left and right.

The default is selected.

Row count

Limits the number of rows fetched from the Db2® catalog. The value entered applies to:

• Object List selection panels displayed by FM/Db2 functions such as the editor, print, copy, import, export, and data create. For more information on object list selection, see Specifying a Db2 object name. Note that FM/Db2 functions such as edit, copy, print, and so on also have a Row count field on the function entry panel. Once an object has been selected, the function entry Row count field acts to control the number of rows processed in the specified Db2® object.
• Object lists displayed by these FM/Db2 functions:
  • Object List Utility (3.4).
  • Object Privileges Utility (3.5).
  • Explain Utilities (4.5).

A value of 0 or ALL specifies no limit; all rows from the relevant catalog tables are fetched and displayed. When you specify 0, FM/Db2 accesses the Db2® catalog using large mode, thereby minimizing storage usage for the list of Db2® objects.

If you experience "insufficient storage" conditions, you can specify a value to limit the number of rows fetched from Db2®. Another way to limit the number of rows fetched in the Object List utility (option 3.4) is to specify selection criteria on the function entry panel.

The default is 1000.

Display widths, filtering

Select this option to navigate to the second Object List Options panel. The default is selected. The Object List utility displays information in Db2® catalog tables. Some of the columns within those tables are defined as varying columns with potentially very long maximum lengths.

You can use the Use automatic column sizing option to reduce the maximum display width for varying columns to the maximum that is needed to display the data for each column.

Additional control can be achieved by specifying minimum and maximum display widths for the various column types shown on the panel. All values are optional. (See Object List Options (2 of 2) panel. A minimum value ensures that the display width is at least the value specified, even if there is no displayable data for the column in all rows processed. Specifying a minimum value does not prevent the display width expanding, if needed, to accommodate longer data.