Working with scrollable display fields

Many FM/Db2 panels show data displayed in scrollable fields. FM/Db2 uses such fields where the length of the field containing the data to be displayed is longer than the field displayed on the panel.

You can recognise a scrollable field by the presence of one of the following adjacent to the end of the display field:

+: Plus sign. Indicates the field is scrollable to the right
-: Minus sign. Indicates the field is scrollable to the left
+-: Plus sign and minus sign. Indicates the field is scrollable to the right or left

If the data to be displayed is longer than the length of the display field on the panel, you can view the rest of the data by performing either of these actions:

Progressively scrolling to the right by pressing the Right function key (F11) or by entering the RIGHT primary command (with the cursor positioned within the display field),
Pressing the Expand function key (F4) or entering the EXPAND primary command to display a window that allows you to view the entire contents of the field.

Table Details panel: example showing scrollable fields shows the Table Details panel which includes a number of scrollable display fields (those with a + symbol adjacent to the end of the field: Table owner, Table name, Created by, Created, and Altered). Scrollable display fields indicate that, possibly, not all of the data held in the field is being displayed.

Note: The presence of a + symbol indicates that the field is scrollable and may contain more data than is currently being displayed. It does not necessarily mean that more data exists than is currently being shown.

Figure 1. Table Details panel: example showing scrollable fields

  Process   Options   Utilities   Help
────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                   Table Details
                                                                    More:     +

    Details about table (label) : KPS8610LO1234567890123456789012345678901234567

 General Data:
    Table owner . . . . : KPS8610LO  +  Table name  . . . . : DUMMY_TABLE_WI  +
    Created by  . . . . : SHRIKES    +  Database name . . . : DSNDB04
    Table space name  . : DUMMYRTA      DB ID for database  : 4
    Object ID for table : 3             Primary key OBID  . : N/A
    Maximum row length  : 69            Primary key columns : N/A
    Number of columns . : 4             Edit procedure name : N/A
    Validation proc.  . : N/A           Check pending flag  : No
    Parent relations  . : 0             Check constraints . : None
    Child relations . . : 0             Encoding scheme . . : E - EBCDIC
    Auditing  . . . . . : AUDIT NONE    Status  . . . . . . : No primary key
    Data capture  . . . : No            Created . . . . . . : 2004-05-10-11.  +
    Restrict on DROP  . : No            Altered . . . . . . : 2004-05-10-11.  +
    Release created . . : L             Dep. query tables . : 0
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F5=Actions   F7=Backward
  F8=Forward   F9=Swap     F10=Left     F11=Right    F12=Cancel

For example, to see more of the data in the Created display field (in the bottom righthand part of the Table Details panel), you can perform either of these actions:

Scroll right by either pressing the Right function key (F11) or entering the RIGHT primary command (ensuring the cursor is positioned within the Created field).
The Created display field now shows more data:
```
⋮
    Data capture  . . . : No            Created . . . . . . : 1.40.08.268623  -
⋮
```
Note that the scroll symbol has changed from a + to a -, indicating that, in this case, you have scrolled to end of the field.

Press the Expand function key (F4) or enter the EXPAND primary command to display a window that shows the entire contents of the Created display field:

Figure 2. Window showing entire contents of display field

 ┌──────────────────────────────── CREATEDT+0 ─────────────────────────────────┐
 │                                                          Line   1 of      1 │
 │                                                                             │
 │ 2004-09-24-11.40.08.268623                                                  │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │ Command ===>                                             Scroll ===> PAGE   │
 │  F1=Help     F2=Split    F3=Exit     F5=Rfind    F6=Rchange  F7=Up          │
 │  F8=Down     F9=Swap    F10=Left    F11=Right   F12=Cancel                  │
 └─────────────────────────────────────────────────────────────────────────────┘