If the table is not open for your user ID, you are shown a Status
of Table panel (Figure 1) with the
value NOT OPEN in the "Status for this screen" field.
Figure 1. Status of table panel with
table not open (ISPYTPS1) ┌──────────────────────────────── Dialog Test ────────────────────────────────┐
│ Menu Utilities Help │
│ ────────────────────────────────────────────────────────────────────────── │
│ Status of Table ISPKEYS │
│ More: + │
│ Status for this screen : NOT OPEN Date created : 1995/01/17 │
│ Table available : YES Time created : 13:47:06 │
│ Last date modified : 2002/06/03 │
│ Last time modified : 22:10:26 │
│ Last modified by : JPHILP │
│ Original row count : 1 │
│ Current row count : 7 │
│ Modified row count : 7 │
│ Update count : 83 │
│ │
│ Virtual storage │
│ Command ===> │
│ F1=Help F2=Split F3=Exit F4=Expand F5=Rfind │
│ F6=Resize F7=Backward F8=Forward F9=Swap F10=Actions │
└─────────────────────────────────────────────────────────────────────────────┘
Option ===> 7
F1=Help F2=Split F3=Exit F7=Backward F8=Forward F9=Swap
F10=Actions F12=Cancel
The panel contains these fields:
- Status for this screen
- Shows
that the table is NOT OPEN for this logical screen.
- Table available
- YES
or NO; whether you can open the table.
- Date created
- Date
the table was created; shown in national format.
- Time created
- Time
the table was created.
- Last date modified
- Date
the table was last modified; shown in national format.
- Last time modified
- Time
the table was last modified.
- Last modified by
- User ID
of the user who last changed the table.
- Original row count
- The
number of rows that were added to a newly created table before closing
the table for the first time.
- Current row count
- The
number of rows currently in the table.
- Modified row count
- The
number of rows in the table that have been changed at least once.
A row that has been added to an existing table is also considered
a changed row.
- Update count
- Number
of times the table has been modified. One or more updates during any
table open or close sequence increments this counter by one.
- Virtual storage
- The
number of bytes of virtual storage required by the table when it is
open.
The Modify row option on the Tables panel allows you to change
a key of a keyed table by adding the new row and deleting the old
row. The row counts thus reflect this processing when changing a key
value.