Table open

If the table is open for your user ID, you are shown a Status of Table panel (Figure 1) with the value OPEN in the Status for this screen field.

Figure 1. Status of table panel with table open (ISPYTPS1)

 ┌──────────────────────────────── Dialog Test ────────────────────────────────┐
 │   Menu  Utilities  Help                                                     │
 │ ──────────────────────────────────────────────────────────────────────────  │
 │                          Status of Table ISPKEYS                            │
 │                                                                More:     +  │
 │ Status for this screen  : OPEN            Date created  . . . : 1995/01/17  │
 │ Open option . . . . . . : NOWRITE         Time created  . . . : 13:47:06    │
 │ Table on disk . . . . . : YES             Last date modified. : 2002/06/03  │
 │ Last table service  . . : TBQUERY         Last time modified. : 22:10:26    │
 │ Last service return code: 00              Last modified by  . : JPHILP      │
 │ Current row pointer . . : TOP             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

This panel contains these fields:

Status for this screen: Shows that the table is OPEN for this logical screen.
Open option: Option used to open the table; this value can be WRITE, NOWRITE, SHR WRITE, or SHR NOWRITE.
Table on disk: Whether the table has been saved on disk; this value can be YES or NO.
Last table service: Name of the last table service called.
Last service return code: Last table services return code.
Current row pointer: Current position in 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.

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.