Working with scrollable input fields

On panels where you can enter the name of:
  • The owner (or creator),
  • A Db2® object, or
  • A column
FM/Db2 provides scrollable input fields that allow you to enter values longer than length of the displayed entry field.
You can recognise a scrollable field by the presence of one of the following adjacent to the end of the entry 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 length of the input field displayed on the panel is insufficient for the value you want to enter, perform one of these actions:
  • Progressively scroll to the right as you enter the value with the Right function key (F11) or by entering the RIGHT primary command (with the cursor positioned within the entry field),
  • Press the Expand function key (F4), or enter the EXPAND primary command, to display a window that allows you to enter the full length of the value
Db2 View panel: format displayed when connected to a Db2 V8 system shows the format of the Db2® View panel. The + symbol adjacent to the Owner and the Name input fields indicates that both are scrollable fields.
Figure 1. Db2® View panel: format displayed when connected to a Db2® V8 system
  Process   Options   Utilities   Help
────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                     Db2 View

 Specify the Db2 Object:
    Location  . . . . .                         Database . .          (optional)
    Owner . . . . . . .                   +     Table space           (optional)
    Name  . . . . . . .                                                     +

    Row count . . . . . 100            Number of rows to browse

 Template:
    Data set name . . . 'FMNUSER.TEMPLATE'                            
    Member  . . . . . . SALARY  

 Processing Options:
    Template usage                     Enter "/", "A"lways to select option
    3  1. Above                           Edit options
       2. Previous                        Edit template
       3. Generate from table             Re-edit template
       4. Generate/Replace


 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F5=Actions   F7=Backward
  F8=Forward   F9=Swap     F10=Left     F11=Right    F12=Cancel

The Owner input field displayed on the panel allows for up to 16 characters to be entered. To enter the name of an owner that is longer than 16 characters, you must use the scrolling or expand capabilities of the Owner input field.

For example, to enter the 21-character name HANSCHRISTIANANDERSON, you can perform either of these actions:
  • Type the first 16 characters of the name (HANSCHRISTIANAND) in the Owner field, use the left arrow key (◄) to position the cursor back in the Owner input field, press the Right function key (F11) to scroll right, and then type the remainder of the name (ERSON) in the Owner field,
  • Press the Expand function key (F4), or enter the EXPAND primary command, to display a window that allows you to enter the full name, and then press the Exit function key (F3) to return to the Db2® View panel.
    Window when entering a long input name shows the window for the Owner field with the full name entered.
    Figure 2. Window when entering a long input name
     ┌──────────────────────────────── FMN2ECRE+0 ─────────────────────────────────┐
     │                                                          Line   1 of      2 │
     │                                                                             │
     │ HANSCHRISTIANANDERSON                                                       │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │                                                                             │
     │ 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                  │
     └─────────────────────────────────────────────────────────────────────────────┘
When you press the Exit function key (F3) to return to the Db2® View panel, the Owner input field shows the first 16 characters of the name you entered:
⋮

 Specify the Db2 Object:
    Location  . . . . .                         Database . .          (optional)
    Owner . . . . . . . HANSCHRISTIANAND  +     Table space           (optional)
    Name  . . . . . . .                                                     +

⋮
To see the rest of the name in the Owner input field, scroll right by either pressing the Right function key (F11) or entering the RIGHT primary command (ensuring the cursor is positioned within the Owner input field):
⋮

 Specify the Db2 Object:
    Location  . . . . .                         Database . .          (optional)
    Owner . . . . . . . ERSON             +     Table space           (optional)
    Name  . . . . . . .                                                     +

⋮