Object List Options (2 of 2) panel

Panel and field definitions

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

 Display width for varying columns:
    Enter minimum and maximum values for each column type
                                    Min    Max
       Databases  . . . . . . . . . 8      8  
       Column names . . . . . . . . 8      30 
       Authorization identifiers  . 8      16 
       Object names . . . . . . . . 8      30 
       Remarks . . . . . .. ..  . . 8      60 
       Other  . . . . . . . . . . . 8      60  


Filtering:
  Enter "/" to select option
    Reposition to first matching row



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

Allows you to specify the minimum and maximum display widths for the various column types shown on the object list panel. All values are optional.

Min

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.

Max

Limits the maximum display width to the value specified, even if data in some rows has a longer width. Specifying a maximum value does not prevent the display width being set to a smaller value, if no rows have data exceeding the value specified.

The following column types are available:

Databases

The name of a Db2® database or table space. The default minimum and maximum values are both 8.

Column names

The name of a Db2® column. The default minimum and maximum values are 8, 30.

Authorization identifier

A Db2® authorization identifier, for example the current SQLID. The default minimum and maximum values are 8, 16.

Object Names

The name of a Db2® object, such as a table, view or alias. The default minimum and maximum values are 8, 30.

Remarks

Applies to columns that are used to store data that is entered by using the COMMENT ON or LABEL ON statements. The default minimum and maximum values are 8, 60.

Other

Applies to any column that does not match the preceding types. The default minimum and maximum values are 8, 60.

Reposition to first matching row

This setting affects how data is displayed after you change the filter values for one or more columns. Use filters to limit the rows that are displayed. The default is not selected.

When you select this setting, the data that is shown after you change the filter values is repositioned to the first matching row.