This topic describes the primary commands available on the Table
Utility Edit/Browse panel:
Browse and Edit primary commands are entered in the Command field.
All the primary commands except SAVE are available in both the Edit
and Browse functions. The SAVE command is only available in Edit.
- CANCEL
- Terminate Edit without Saving Changes.
The CANCEL command (F12) terminates table editing without saving the
table data to the output data set.
CAN can be used as an abbreviation
for the CANCEL command.
- DOWN
- Scroll Down. The standard ISPF DOWN command (F8|F20) can be used
to vertically scroll the table display towards the bottom of the table.
ISPF supported scroll amount values used for the DOWN command
can be entered in the Scroll field. You can also enter a valid scroll
amount in the Command field.
- EXPAND
- Expand
Display of Scrollable Field. The standard ISPF EXPAND command (F4)
can be used to display a table variable value in a popup window containing
a scrollable dynamic area. To do this, enter EXPAND while the cursor
is placed on the field displaying a table variable value.
- EXPORT
- Display
Table Export Layout. The Export Layout panel is displayed when the
EXPORT primary command is entered on the Edit/Browse panel. This panel
shows the structure used to format the table data written to the export
output data set. You can make changes to the structure to alter the
format of the data written to the output data set.
Figure 1. Table Export Layout panel (ISRUTBP7) Options Help
───────────────────────────────────────────────────────────────────────────────
Table BLG0CMDS Export Layout Row 1 to 9 of 9
Command ===> ________________________________________________ Scroll ===> CSR
Overtype the Order column and press ENTER to rearrange the fields into the
order in which you would like them to be dumped. Change Width as required.
Only fields with an Order value less than 999 will be dumped.
Use the FILE primary command to write the table data to the export data set.
Cumulative
Order Name Field Heading Width Width
----- -------- ---------------------------------- ------- ----------
001 ZEDPTYPE ZEDPTYPE 8 9
002 ZEDPLRCL ZEDPLRCL 8 18
003 ZEDPRCFM ZEDPRCFM 8 27
004 ZEDPFLAG ZEDPFLAG 24 52
005 ZEDPBNDL ZEDPBNDL 8 61
006 ZEDPBNDR ZEDPBNDR 8 70
007 ZEDPTABC ZEDPTABC 8 79
008 ZEDPMASK ZEDPMASK 8 88
009 ZEDPTABS ZEDPTABS 8 97
******************************* Bottom of data ********************************
F1=Help F2=Split F3=Exit F7=Backward F8=Forward F9=Swap
F10=Actions F12=Cancel
The screen shows the current structure used to format the
table data written to the export data set. The list contains these
fields:
- Order
- This input field
allows you to enter a number which defines the sequence in which the
table variables for each row are placed in the export data set. For
example, assigning an Order of 001 to a table variable makes it the
first to be written to each table data record in the export data set.
Note: Only table variables that have an Order value less than 999
are written to the export data set.
- Name
- The name of the table variable.
- Field Heading
- This
input field allows you to define a heading for each table variable
written to the export data set. It is initialized with the name of
the associated table variable.
- Width
- This input field allows you to define the number of characters
allocated to the column used to print a table variable value. This
field is initialized to the display length of the table variable value
on the table display screen.
- Cumulative Width
- This field shows the total number of characters required in the
export data set record to accommodate this variable and all the preceding
table variables.
When you are happy you
have the correct format defined, use the FILE primary command to write
the table data to the export data set.
These abbreviations
can be used for the EXPORT command:
EX
EXP
EXPO
EXPOR
- FILE
- The FILE command
causes the table data to be written to the export data set in the
format defined on the export layout panel.
The name of the export
output data set can be specified as a parameter to the FILE command.
You can enter any fully qualified data set name by enclosing it in
apostrophes. If you omit the apostrophes, your TSO prefix or user
ID (if no TSO prefix is defined in your TSO user profile) is added
to the beginning of the data set name. For example, if a user whose
TSO prefix is LSACKV issues the command FILE TAB1.DATA,
the table data report is written to the export data set LSACKV.TAB1.DATA.
If
you do not specify an export data set name on the FILE command, a
default name is generated according to these rules:
- If no TSO prefix is defined in your TSO user profile: userid.tblname.TBLDUMP
- If your TSO prefix and user ID are the same: tsopref.tblname.TBLDUMP
- If your TSO prefix and user ID are not the same: tsopref.userid.tblname.TBLDUMP
tsopref is
your TSO prefix. userid is your TSO user
ID. tblname is the name of the table you
are processing.
Note: If the ISPF configuration table field USE_ADDITIONAL_QUAL_FOR_PDF_DATA_SETS
is set to YES, an additional qualifier defined with the ISPF_TEMPORARY_DATA_SET_QUALIFIER
field is included before the tblname qualifier.
A
warning message might be displayed if the export data set already
exists. You then have the option of terminating the command to avoid
overwriting the data set. If you don't want to receive these warnings
in future, clear the "Warn if export data set exists" check box
on the Table Utility Options panel.
When the FILE command
has finished, the export data set is displayed. The "Display mode
for export data set" option on the Table Utility Options panel
allows you to choose either the ISPF Browse, View, or Edit functions
to display the export data set.
These abbreviations can be
used for the FILE command:
FI
FIL
- FEXPORT
- Fast EXPORT Command. The FEXPORT command writes
the table data to the export output data set without displaying the
export layout panel.
The name of the export output data set can
be specified as a parameter to the FEXPORT command. You can enter
any fully qualified data set name by enclosing it in apostrophes.
If you omit the apostrophes, your TSO prefix or user ID (if no TSO
prefix is defined in your TSO user profile) is added to the beginning
of the data set name. For example, if a user whose TSO prefix is LSACKV
issues the command FEXPORT TAB1.DATA, the table data
report is written to the export data set LSACKV.TAB1.DATA.
If
you do not specify an export data set name on the FEXPORT command,
a default name is generated according to these rules:
- If no TSO prefix is defined in your TSO user profile: userid.tblname.TBLDUMP
- If your TSO prefix and user ID are the same: tsopref.tblname.TBLDUMP
- If your TSO prefix and user ID are not the same: tsopref.userid.tblname.TBLDUMP
tsopref is
your TSO prefix. userid is your TSO user
ID. tblname is the name of the table you
are processing.
Note: If the ISPF configuration table field USE_ADDITIONAL_QUAL_FOR_PDF_DATA_SETS
is set to YES, an additional qualifier defined with the ISPF_TEMPORARY_DATA_SET_QUALIFIER
field is included before the tblname qualifier.
If
the export data set exists when the FEXPORT command is issued and
you have selected "Warn if export data set exists" on the Table
Utility Options panel, a warning popup panel is displayed. You then
have the option of terminating the command to avoid overwriting the
data set.
When the FEXPORT command has finished, the export
data set is displayed. The "Display mode for export data set" option
on the Table Utility Options panel allows you to choose either the
ISPF Browse, View, or Edit functions to display the export data set.
These
abbreviations can be used for the FEXPORT command:
FE
FEX
FEXP
FEXPO
FEXPOR
- FIND
- Search for String in Table. The FIND
command can be used to search for the occurrence of a character string
in a specified column in the table. If the string is found, the row
in which it is found is positioned at the top of the display.
The
FIND command has these formats:
FIND varname string
FIND n string
where:
- varname
- The name of any of the table variables.
- n
- The ordinal number of any column displayed on the current screen.
- string
- The character string to be searched for. The search is not case
sensitive.
These abbreviations can
be used for the FIND command:
F
FI
FIN
- INSERT
- Insert
a Blank Row at the Top of the Table. Use the INSERT command to create
a new blank row as the first row in the table. This command allows
you to create a row in an empty table.
- LEFT
- Scroll Left. The LEFT command (F10|F22) can be used to scroll
the table display horizontally towards the first table column.
The
scroll amount values used for the LEFT command can be entered in the
Shift field. You can also enter one of these valid scroll amounts
in the Command field:
- PAGE
- Causes the display to scroll left by the width of the screen.
- MAX
- Causes the display to scroll left so that the first column for
the table is the leftmost displayed.
- 0 to 9999
- Causes the display to scroll left the specified number of columns.
Note: Table variable values
are displayed in scrollable fields. Therefore if the cursor is placed
in a field displaying a table variable value, the LEFT command operates
on that field, not on the whole table display.
- RFIND
- Repeat
Last FIND Command. The RFIND command (F5|F17) is used to repeat the
last FIND command. It is most useful when assigned to a function key.
R can be used as an abbreviation for the RFIND command.
- RIGHT
- Scroll Right. The RIGHT command (F11|F23) can be used to scroll
the table display horizontally towards the last table column.
The
scroll amount values used for the RIGHT command can be entered in
the Shift field. You can also enter one of these valid scroll amounts
in the Command field:
- PAGE
- Causes the display to scroll right by the width of the screen.
- MAX
- Causes the display to scroll right so that the last column for
the table is the rightmost displayed.
- 0 to 9999
- Causes the display to scroll right the specified number of columns.
Note: Table variable values
are displayed in scrollable fields. Therefore if the cursor is placed
in a field displaying a table variable value, the RIGHT command operates
on that field, not on the whole table display.
- SAVE
- Save Table
Changes. The SAVE command causes the changes to the table data to
be written to the table output library. Normally the changes would
be saved to the originating data set.
If you specified the table
name and a Table DD on the ISPF Table Utility panel, and the "Always
save table in originating data set" check box on the Table Utility
Options panel is not selected, ISPF prompts you to specify the output
data set. See Table output data set selection for more
information.
SAV can be used as an abbreviation for the SAVE
command.
- SORT
- Display Table Sort Definition. The Sort
Specification panel is displayed when the SORT primary command is
entered on the Edit/Browse panel. This panel allows you to sort the
table according to the values of one or more table variables.
Figure 2. Table Sort Specification panel
(ISRUTBP8) Options Help
───────────────────────────────────────────────────────────────────────────────
Table BLSGEDIT Sort Specification Row 1 to 9 of 9
Command ===> ________________________________________________ Scroll ===> CSR
Overtype the Order column and press ENTER to rearrange the table variables
into the order in which you would like them to be sorted. Change Sequence to A
(Ascending) or D (Descending) as required. Table BLSGEDIT will only be sorted
using table variable with an Order less than 999.
Order Name Sequence (A/D)
----- -------- --------------
999 ZEDPTYPE A
999 ZEDPLRCL A
999 ZEDPRCFM A
999 ZEDPFLAG A
999 ZEDPBNDL A
999 ZEDPBNDR A
999 ZEDPTABC A
999 ZEDPMASK A
999 ZEDPTABS A
F1=Help F2=Split F3=Exit F7=Backward F8=Forward F9=Swap
F10=Actions F12=Cancel
The screen displays a list of the table variables and contains
these fields:
- Order
- This input field
allows you to enter a number which defines the sort priority for the
associated table variable. For example, assigning an Order of 001
makes the associated table variable the primary sort key.
Note: The
table will only be sorted on those variables that have an Order value
less than 999.
- Name
- The name of the table variable.
- Sequence (A/D)
- This input
field allows you to define whether to sort in ascending (A) or descending
(D) sequence for the associated table variable.
When you press Exit (F3)
to return to the Edit/Browse panel it is sorted based on changes made
on the table sort display.
Note: If you are using Edit, the sort
criteria entered on this screen are saved with the table.
These
abbreviations can be used for the SORT command:
SO
SOR
- STATS
- Display
Table Statistics. The table statistics display is invoked when the
STATS primary command is entered on the browse/edit table display.
This screen shows the statistical information that ISPF maintains
for the table.
Figure 3. Table statistics
panel (ISRUTBP6) ┌─────────────────────────────────────────────────────────────────────────────┐
│ Statistics for Table BLG0CMDS │
│ Command ===> __________________________________________________________ │
│ The following information is returned by the TBSTATS service: │
│ │
│ Created on . . . : 1997/01/14 at 13:26:23 │
│ Last updated on : 2004/08/27 at 09:37:02 by LSACKV │
│ │
│ Initial number of rows when created . . . . . . : 101 │
│ Current number of rows . . . . . . . . . . . . . : 101 │
│ Number of existing rows which have been updated : 2 │
│ Number of times table has been updated . . . . . : 7 │
│ Virtual storage size (bytes) . . . . . . . . . . : 8,072 │
│ │
│ Last TABLE SERVICES command . . . . . . . . . . : TBTOP │
│ Return code from above service . . . . . . . . . : 0 │
│ │
│ Status 1 : 1 - table exists in input library chain │
│ Status 2 : 3 - table is open in WRITE mode in this logical screen │
│ Status 3 : 2 - table is not available for WRITE mode │
│ │
│ F1=Help F2=Split F3=Exit F7=Backward F8=Forward │
│ F9=Swap F10=Actions F12=Cancel │
└─────────────────────────────────────────────────────────────────────────────┘
The screen shows these fields:
- Created on
- The
date and time the table was originally created.
- Last updated on
- The date and time the table was last modified.
- by
- User ID of the last user who modified the table.
- Initial number of rows when created
- Number of rows that were added during the session when the table
was first created and then closed.
- Current number of rows
- Number of rows currently in the table.
- Number of existing rows which have been updated
- Number of rows that have been modified in the table at least once.
A row that is added to an existing table is considered a modified
row.
- Number of times table has been updated
- Number of editing sessions during which the table has been modified.
Opening a table, then making one or more updates, then closing and
saving the table increments this count by one.
- Virtual storage size (bytes)
- Number
of bytes of virtual storage required by the table.
- Last TABLE SERVICES command
- The name of the last table service called.
- Return code from above service
- The return code issued by the last table service called.
- Status 1
- The status
of the table in the table input library chain.
- Status 2
- The status of the table in this logical screen.
- Status 3
- The availability of the table to be used in WRITE mode.
- STRUCT
- Display
Table Structure. The table structure panel is invoked when the STRUCT
primary command is entered on the Edit/Browse panel. This panel shows
the structure used to format the browse/edit table display. You can
change the data displayed on this screen to alter the format of the
table display.
Figure 4. Table structure
panel (ISRUTBP5) Options Help
───────────────────────────────────────────────────────────────────────────────
Structure of Table BLSGEDIT Row 1 to 7 of 9
Command ===> ________________________________________________ Scroll ===> CSR
Rows scanned to produce
Number of Rows . . : 17 structure . . . . . . . . . . : 17
Number of Keys . . : 0
Number of Names . : 9
────────────────────────────────────────────────────────────────────────────
ZEDPTYPE ZEDPLRCL ZEDPRCFM ZEDPFLAG ZEDPBNDL ZEDPBNDR
────────────────────────────────────────────────────────────────────────────
Column Name Type Length Display Area
------ -------- ---- ------ ------------------------------
001 ZEDPTYPE Name 8 <= start of display
002 ZEDPLRCL Name 8 <= displayed
003 ZEDPRCFM Name 8 <= displayed
004 ZEDPFLAG Name 24 <= displayed
005 ZEDPBNDL Name 8 <= displayed
006 ZEDPBNDR Name 8 <= end of display
007 ZEDPTABC Name 8
F1=Help F2=Split F3=Exit F7=Backward F8=Forward F9=Swap
F10=Actions F12=Cancel
The top area of this screen shows this information about
the table:
The next area of the screen shows
the current column headings for the table display.
The bottom
area of the screen shows the current structure used to format the
table display. This is a list containing these fields:
- Column
- This input field shows a number representing the relative position
of the associated table variable in the table display. You can change
the position of a variable in the table display by altering this number.
- Name
- The name of the table variable.
- Type
- Shows a value of Key if the associated variable is defined as
a key for the table. Otherwise shows a value of Name.
- Length
- This input field shows the number of characters used to display
the table variable value. The table utility calculates this number
by scanning the table rows and finding the largest length value for
each table variable.
Note: If you have specified a value for the "Maximum
rows searched to determine column width" option on the Table Utility
Options panel, the table utility might not scan all the table rows
and therefore the calculated length value might not be large enough
for all variable values.
- Display Area
- Identifies the table
variables currently shown on the table display screen.
When you press Exit (F3)
to return to the Edit/Browse panel it is reformatted based on changes
made on the table structure display.
These abbreviations can
be used for the STRUCT command:
STR
STRU
STRUC
- UP
- Scroll Up. The standard ISPF UP command (F7|F19) can be used to
vertically scroll the table display towards the top of the table.
ISPF supported scroll amount values used for the UP command can
be entered in the Scroll field. You can also enter a valid scroll
amount in the Command field.