Tables (option 7.4)

The Tables option (7.4) allows you to examine and manipulate the rows of a table, and to display table structure and status. When you select this option, the panel in Figure 1 is displayed, on which you show the table function you want and the parameters needed to identify the table.

Figure 1. Tables panel (ISPYTPI)

 ┌──────────────────────────────── Dialog Test ────────────────────────────────┐
 │   Menu  Utilities  View  Help                                               │
 │ ──────────────────────────────────────────────────────────────────────────  │
 │                                   Tables                                    │
 │                                                                More:     +  │
 │ 1 Display row            3 Modify row             5 Display structure       │
 │ 2 Delete row             4 Add row                6 Display status          │
 │                                                                             │
 │ Table Name  . .           Open tables  . .          (NOWRITE or WRITE or    │
 │                                                      blank for no TBOPEN)   │
 │ Row identification:            Current row  . :                             │
 │ By row number  . . *           (* = current row)                            │
 │  Variable   Value              (Search for row if row number blank)         │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │                                                                             │
 │ DBCS column specification:                                                  │
 │ Option ===>                                                                 │
 │  F1=HELP        F2=            F3=END         F4=DATASETS    F5=FIND        │
 │  F6=CHANGE      F9=SWAP       F10=LEFT       F11=RIGHT      F12=SUBMIT      │
 └─────────────────────────────────────────────────────────────────────────────┘