Displaying data
File-AID has four ways of displaying data:
The display mode in use determines the way in which records are accessed, and the facilities that are available for displaying the data set.
File-AID supports a maximum COBOL PICTURE clause of 32,767 in Browse and Edit formatted and vertical formatted modes.
- Formatted mode provides a formatted data record display that enables viewing and editing on a field-by-field basis. Records may be browsed and edited using their record layouts. Multiple record layouts are defined by an XREF for data sets with varying record types. Data from each record is divided into fields defined by the record layout. Use the CHAR command for entry into character mode, VFMT command for entry into vertical formatted mode, and UNFMT for entry into Unformatted mode.
- Character mode provides full-screen browsing and editing of data. In edit, you can make changes to the record contents by overtyping the displayed data or using the CHANGE primary command. You can use line commands, similar to those used in ISPF, to move, copy, insert, delete, repeat, and exclude records. Use the FMT command for entry into formatted mode, VFMT command for entry into vertical formatted mode, and UNFMT command for entry into unformatted mode.
- Vertical formatted mode provides a full-screen data display that uses the record layout fields as column headers. Data from each record is divided into columns under the field headings. Multiple record layout datasets (XREFs) are not supported in vertical formatted mode. Use the CHAR command to redisplay the data in character mode, the FMT command to redisplay the data in formatted mode, and the UNFMT command to redisplay the data in unformatted mode.
- Unformatted mode provides a full-screen display that enables viewing and editing of data records in a character or three-line hexadecimal format. Data is presented one record at a time with 70 characters displayed per line. Use the CHAR primary command to redisplay the data in character mode, the FMT command to use formatted mode, and the VFMT command to use vertical formatted mode.
The initial display mode is controlled by the Edit Mode field on the Browse or Edit - Dataset Specification screen. Use the CHAR, FMT, VFMT, and UNFMT primary commands to change the display mode to character, formatted, vertical formatted, or unformatted mode at any time during the edit session.
File-AID synchronizes the position of the cursor between the formatted, character, vertical formatted, and unformatted modes. If you enter the FMT command in character or vertical formatted mode, File-AID examines the cursor position, and uses the data byte in the record where the cursor is found to automatically scroll the formatted display. The layout field corresponding to the byte position of the cursor is placed at the top of the display.
If the cursor is:
- In the COMMAND field when the FMT (or MAP) command is entered, the top record on the display is selected.
- Positioned within a record field, that field is initially positioned at the top of the formatted edit display.
- Positioned to the left of a record (in the sequence field) or in the COMMAND field, the field that is displayed at the left edge of the character edit display is placed at the top of the formatted edit display.
When you enter the CHAR, VFMT, or UNFMT command in formatted mode, the cursor position in the layout fields determines the portion of record that is displayed in character, vertical formatted, or unformatted mode. If the cursor is at the COMMAND field, File-AID positions the cursor to the field at the top of the formatted display. Use the END command (PF3) to exit the Edit or Browse session.
Formatted Mode
Formatted Edit mode provides a formatted data record display that lets you view, search for, and change data on a field-by-field basis. Data from each record is divided into fields defined by the record layout. XREFs are used to define multiple record layouts for data sets with varying record types.
To display data in formatted mode, enter an F in the Edit Mode field, and specify record layout or XREF dataset information on the Edit - Dataset Specification screen. The following figure shows a sample formatted mode edit display.
The formatted mode display consists of a Header Area and a Data Area. The Header Area contains four fixed heading lines and may contain profile lines that appear immediately below the heading lines. The Data Area is divided into three areas: the Field Name Area, the Field Description Area, and the Field Value Area.
Formatted mode supports the FPRINT primary which creates the Formatted Print Report. See FPRINT-FP.
Formatted Mode Edit Display
COMMAND ===> SCROLL ===> CSR
RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198
---- FIELD LEVEL/NAME ------- -FORMAT- ----+----1----+-----2----+----3----+----4
5 EMP-NUMBER 5/AN 00090
5 EMP-LAST-NAME 15/AN MARTIN
5 EMP-FIRST-NAME 10/AN EDWARD
5 EMP-MID-INIT 1/AN M
5 FILLER 2/AN
5 EMP-TITLE 30/AN AIRPLANE MANUFACTURER
5 EMP-PERSONAL-INFO SYNC 23/GRP
10 EMP-NATL-ID-NUMBER 9/NUM 427890125
10 FILLER 1/AN
10 EMP-DATE-OF-BIRTH 6/AN 101954
10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH
10 EMP-DOB-REDEF SYNC 6/GRP
15 EMP-DOB-MM 2/NUM 10
15 EMP-DOB-DD 2/NUM 19
15 EMP-DOB-YY 2/NUM 54
10 EMP-HIRE-DATE 6/AN 920101
10 EMP-MARITAL-STATUS 1/AN M
5 EMP-WITHOLD-INFO SYNC 15/GRP
10 EMP-LIFE-INS-WITHOLD-AMT DISPLAY 30000}
Enter CHAR for character mode, VFMT for vertical format mode
An easy way to access formatted mode is to set a PF key for the FMT (or MAP) primary command. Then, on the character, vertical formatted, or unformatted mode display, simply position the cursor on a byte of data within any record and use the FMT (or MAP) PF key to go to the formatted mode. See FMT or MAP for information on these primary commands.
Header Area
The heading lines occupy the top four lines of the formatted mode display:.
- Line 1: Indicates the data set being accessed and the record columns currently displayed. In Formatted Mode Edit Display: USERID9.FASAMP.EMPLOYEE. The first 101 bytes of the record are displayed in this example.
- Line 2: Contains the COMMAND and SCROLL fields. Primary commands are entered in the COMMAND field. In Formatted Mode Edit Display, the SCROLL field is set to PAGE. Scrolling up or down the record displays a full page of fields at a time.
Line 3. Contains the record number, record layout name (level 1 data name), and the record length. In Formatted Mode Edit Display, the record number is 1, the record layout is EMPLOYEE-MASTER-FILE, and the total record length is 198 bytes.
When a non-data set record is selected, a special record name is displayed instead of the record number. If a mask line is edited, the word MASK is displayed. See MASK for a description. When inserting new records, the word INPUT is displayed. See INPUT-INSERT-I for more information.
- Line 4: Provides titles for the three columns of the Data Area. In Formatted Mode Edit Display, the title FIELD LEVEL/NAME indicates that the Field Name Area contains the level number of each data item.
The title FORMAT indicates that the Field Description area contains the field length and current field format. These heading options are set using the SHOW LEVEL and SHOW FORMAT commands.
Data Area
The Data Area contains the record layout information and record data. It begins with the *** TOP OF DATA *** line that indicates that an attempt was made to scroll UP above the beginning of the record. It also indicates that the selected record layout is aligned with the beginning of the record. Each following data line contains the layout field name, field description, and the data value in that field.
The Data Area is divided into three areas:
- Field Name area
- Field Description area
- Field Data Value area.
Special information lines may also be displayed at the top or bottom of the data area.
Field Name Area
The Field Name Area displays the data item names declared in the record layout. Each line of this area contains one item name and the corresponding data item level number (or field number). One or more subscripts are displayed if the item is one occurrence of an item with multiple occurrences.
If the field name information is longer than the width of the Field Name Area, it is continued across the line. If the field name information extends at all into the Field Description Area, the contents of the Field Description and Field Value area are moved to the following line.
The SHOW command with the LEVEL or NUMBER parameter selects whether File-AID displays level numbers or field numbers in the Field Name Area. When level numbers are displayed, each successive level is indented two character positions to highlight the record structure.
Field Description Area
The Field Description Area displays one of three types of information for each data item: data format, field offset, or source code declaration (picture). The information type is selected with the SHOW command and its FORMAT, OFFSET, or PICTURE parameter. The current information type in the Field Description Area is identified by the FORMAT or PICTURE heading, and in the case of OFFSET the heading can be:
COLUMNS
(default for SHOW OFFSET) and OFFSET COLS.
RELATIVE
SHOW OFFSET, then OFFSET REL.
REL(HEX)
SHOW OFFSET, then OFFSET HEX.
The most recently selected information type is retained between display modes, and is also carried from one session to another in the profile.
Format abbreviations are used in this area to allow all data to be displayed within it. The abbreviations are described in Data Format Abbreviations.
Field Data Value Area
The Field Value area contains the value of elementary items and optional information for group items. Values of elementary items are displayed in a form that is appropriate for the item declaration.
File-AID displays numeric items as a decimal value with a leading sign and decimal places if appropriate. Only negative signs are shown. A display item is also displayed in this form if its picture shows it to be numeric.
When a data item is the object of an OCCURS DEPENDING ON (COBOL) or REFER (PL/I) clause, its maximum legal value is displayed at the right side of the Field Value area.
The maximum number of characters displayed on one line is 40 or 92 (Mod 5 terminal). File-AID adjusts the display to take advantage of the terminal capabilities. File-AID displays a ruler at the top of the Field Value area.
File-AID displays non-numeric items as alphanumeric characters. When the length of the field exceeds the width of the Field Value area, File-AID shows the entire field contents in as many extra Field Value Area lines as needed. The Field Description Area of each extra line contains the offset (from the beginning of the field) of the first byte of data on that line. For example, (POS 41-80).
File-AID displays any field that contains invalid data for the declared data type entirely in highlighted hexadecimal characters. The TOO MANY INTEGER PLACES message indicates that the newly entered numeric value does not fit in the record field.
In formatted mode, the TOP OF DATA and BOTTOM OF DATA information lines indicate the top and bottom of the displayed record.
When the currently selected record layout defines more or fewer bytes of information than the currently selected record, or if the layout is not positioned at the first data byte, additional information lines are displayed as follows:
*** START OF DATA - LAYOUT PRECEDES DATA BY nn BYTES ***
*** END OF DATA - LAYOUT EXCEEDS DATA BY nn BYTES ***
*** START OF LAYOUT - DATA PRECEDES LAYOUT BY nn BYTES ***
*** END OF LAYOUT - DATA EXCEEDS LAYOUT BY nn BYTES ***
Data Format Abbreviations
In formatted and vertical formatted modes, abbreviations are used for the data format descriptions to enable them to fit in the Field Description area. See the following table for a list of COBOL abbreviations, and PL/I Data Format Abbreviations for a list of PL/I abbreviations.
COBOL Data Format Abbreviations
Abbrev. | COBOL Data Type |
---|---|
AN | USAGE DISPLAY (PICTURE contains at least one non-numeric symbol) |
UT16 | USAGE NATIONAL (PICTURE contains at least one non-numeric Unicode symbol) |
UT8B | USAGE UTF-8 (PICTURE U with BYTE-LENGTH) |
UT8C | USAGE UTF-8 (PICTURE U without BYTE-LENGTH) |
BOOL | USAGE DISPLAY (PICTURE contains all 1s) |
BIT | USAGE BIT (PICTURE contains all 1s) |
DBCS | USAGE DISPLAY (PICTURE contains all DBCS symbols) |
NUM | USAGE DISPLAY (PICTURE contains all numeric symbols, unsigned) |
UNUM | USAGE NATIONAL (PICTURE contains all Unicode numeric symbols, unsigned) |
P | USAGE COMPUTATIONAL-3, unsigned |
PS | USAGE COMPUTATIONAL-3, signed |
BI | USAGE COMPUTATIONAL, signed and unsigned |
BIS | USAGE COMPUTATIONAL SYNCHRONIZED, signed and unsigned |
SPFP | USAGE COMPUTATIONAL-1 (single precision floating point) |
DPFP | USAGE COMPUTATIONAL-2 (double precision floating point) |
HEX | Does not correspond to any COBOL data type. This format abbreviation indicates that the data is displayed in hexadecimal format. This occurs when the field format has been explicitly set by a DISPLAY field-number HEX command or when USAGE HEX is specified in the layout. |
PTR | POINTER item |
PL/I Data Format Abbreviations
Abbrev. | PL/I Data Type |
---|---|
AREA | AREA item |
BFL | BINARY FLOAT item |
BFX | BINARY FIXED item |
BIT | BIT item |
CHAR | CHARACTER item |
DBCS | GRAPHIC item |
DFL | DECIMAL FLOAT item |
DFX | DECIMAL FIXED item |
HEX | Does not correspond to any PL/I data type. This format abbreviation indicates that the data is displayed in a hexadecimal format. This occurs when the field format has been explicitly set by a DISPLAY field-number HEX command. |
OFST | OFFSET item |
PFL | Floating Point numeric PICTURE item (signed) |
PFLU | Floating Point numeric PICTURE item (unsigned) |
PFX | Fixed Point numeric PICTURE item (signed) |
PFXU | Fixed Point numeric PICTURE item (unsigned) |
PTR | POINTER item |
UT8C | UCHAR Unicode UTF-8 Item |
VBIT | BIT VARYING item |
VCHR | CHAR VARYING item |
Positioning a Formatted Display
The UP and DOWN primary commands are used to move through a layout when all fields do not fit on the display simultaneously. If the UP command is entered with the first record field already displayed, or the DOWN command is entered with the last layout field already displayed, an information line is displayed. The LEFT and RIGHT commands select and display the previous or next data set record. BACK and FORWARD function similarly.
If you enter a number in the COMMAND field before the LEFT or RIGHT command is invoked, that number of records is skipped in moving forward or backward through the data set. No error message is displayed if you attempt to scroll past the beginning or end of the data set. Enter the letter M (for maximum) in the COMMAND field before scrolling in any direction to move to the opposite end of the layout (UP/DOWN) or data set (LEFT/RIGHT).
Edit Record Length
You can modify the LRECL of a variable length record by typing over the record length displayed on the screen.
- If the new record length is shorter than the current length, data will be truncated.
- If the new record length is longer than the current length, the extra bytes will be padded with the PAD character in your profile (see also PAD).
Character Mode
Character mode data displays are similar to ISPF/PDF displays of a data set. The command structure and display layout are similar to those of the ISPF/PDF editor. The displayed or edited data can consist of the entire data set or be restricted to a selected subset of records by applying selection criteria.
Enter a C in the Edit Mode field on the Edit - Dataset Specification screen to display the data in character mode. The following figure shows a character mode edit display. The number of records and data bytes displayed depends on the terminal type used. If the terminal type supports more than 24 lines by 80 columns, File-AID automatically adjusts the data display to take advantage of the capabilities of the terminal.
Character Mode Edit Display
COMMAND ===> SCROLL ===> PAGE
****** ***************************** TOP OF DATA *******************-CAPS OFF-*
000001 00090MARTIN EDWARD M AIRPLANE MANUFACTURER 427890125
000002 00100MULSTROM ROBERTA A HOLLYWOOD SEAMSTRESS 346573656
000003 00200JACKSON JOSEPH C ORATOR 275587177
000004 10000ANDREWS GEORGE ACTOR 576312032
000005 15000MURPHY RONALD L PAINTER 987654321
000006 18034SCHNEIDER ELLEN C NURSE 341559549
000007 21035JONES GEORGE B COUNTRY SINGER 463813456
000008 25100ROBERTS WILLIAM R POLITICIAN 879563325
000009 27007ALLEN JOYCE M AUTHOR 783458334
000010 30001RICHARDS REX W RODEO CLOWN 632764534
000011 31000SAVAGE JONATHON C ELECTRICIAN 348567992
000012 34010SMITH JANET AIRLINE ATTENDANT 557782984
000013 34011JACOBS DIANA DOCTOR 225368395
000014 36010SIMPSON ALEX CARTOONIST 123456789
000015 39310BARNETT EDWARD E SALESMAN 543789142
000016 39500WILLIAMS EDITH A DESIGNER 987654321
000017 41000RICHARDSON MARJORIE M PROGRAMMER ANALYST 346583656
000018 41400MOORE THOMAS M SYSTEMS ADMINISTRATOR 226373646
000019 42017BENNETT WILLIAM D SALES SUPPORT 146573556
000020 44018WILHELM HEINRICH L DIPLOMAT 466573356
Enter FMT (formatted mode), VFMT (vertical format), UNFMT (unformatted mode)
The top line of the display contains the name of the data set and the columns currently being displayed. In Browse, the current line number is also included. The second line includes the COMMAND field for entering commands that direct the Browse or Edit operation. The second line also has the SCROLL field that determines the number of lines (vertically) or columns (horizontally) to move each time a scrolling command (LEFT, RIGHT, UP, or DOWN) is used. Lines 3 and below contain data lines or information lines about the Edit or Browse session.
The character mode Edit display acts as a window into a collection of records. The records are ordered in the sequence in which they exist in the file. File-AID allows reordering of the records; it detects and flags sequence errors in keyed data sets.
The File-AID Edit character mode display provides a six-digit sequence field that can be used to enter line commands. The remainder of the line is record data. The sequence field contains numbers that start at 1 and are incremented by 1. The actual sequence number in storage is not limited to six digits. If there are more than 999,999 records in storage, the sequence number grows as large as necessary. The number displayed in the sequence field represents the last six digits of the actual sequence number.
If a keyed (VSAM KSDS) data set is edited, the record key field is preceded and followed by a blank column and is highlighted and protected (see the following figure). The P (protect) and U (unprotect) line commands allow modification of a record key.
Character Mode Edit Display - Keyed Data set
COMMAND ===> SCROLL ===> CSR
****** ***************************** TOP OF DATA ******************-CAPS OFF-*
000001 00090 MARTIN EDWARD M AIRPLANE MANUFACTURER 42789012
000002 00100 MULSTROM ROBERTA A HOLLYWOOD SEAMSTRESS 34657365
000003 00200 JACKSON JOSEPH C ORATOR 27558717
000004 10000 ANDREWS GEORGE P ACTOR 57631203
000005 15000 MURPHY RONALD L PAINTER 98765432
000006 18034 SCHNEIDER ELLEN C NURSE 34155954
000007 21035 JONES GEORGE B COUNTRY SINGER 46381345
000008 25100 ROBERTS WILLIAM R POLITICIAN 87956332
000009 27007 ALLEN JOYCE M AUTHOR 78345833
Vertical Formatted Mode
The following figure is the same as the character mode edit screen except that it displays column headings with the data arranged in columns under the column headings. Enter a V in the Edit Mode field and specify a record layout dataset on the Edit - Dataset Specification screen to display the data in vertical formatted mode.
File-AID does not allow the use of an XREF in Vertical Formatted mode.
Graphic-defined DBCS data is supported in Vertical Formatted mode of Browse and Edit. File-AID adds dummy shift characters to display the values as DBCS.
Vertical formatted mode supports the VPRINT primary which creates the Vertical Formatted Print Report. See VPRINT-VP.
Vertical Formatted Edit Display
COMMAND ===> SCROLL ===> PAGE
EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT FILLER
5/AN 15/AN 10/AN 1/AN 2/AN
(1-5) (6-20) (21-30) (31-31) (32-33)
1--------- 2-------------- 3------------- 4----------- 5-------
****** ***************************** TOP OF DATA ******************-CAPS OFF-*
000001 00090 MARTIN EDWARD M
000002 00100 MULSTROM ROBERTA A
000003 00200 JACKSON JOSEPH C
000004 10000 ANDREWS GEORGE
000005 15000 MURPHY RONALD L
000006 18034 SCHNEIDER ELLEN C
000007 21035 JONES GEORGE B
000008 25100 ROBERTS WILLIAM R
000009 27007 ALLEN JOYCE M
000010 30001 RICHARDS REX W
000011 31000 SAVAGE JONATHON C
000012 34010 SMITH JANET
000013 34011 JACOBS DIANA
000014 36010 SIMPSON ALEX
000015 39310 BARNETT EDWARD E
000016 39500 WILLIAMS EDITH A
Enter FMT for formatted mode, CHAR for character mode, HEX ON for Hex
Unformatted Mode
The following figure displays the data one record at a time without using a record layout. 70 characters of data are displayed per line until all data for the record is shown or the screen is filled. If a keyed (VSAM KSDS) data set is edited, the record key field is preceded and followed by a blank column and is highlighted and protected (see the following figure). Enter a U in the Edit Mode field on the Edit - Dataset Specification screen to display the data in unformatted mode.
File-AID does not use a record layout or XREF in unformatted mode.
Use the HEX ON primary command to display the record in a three-line vertical hexadecimal format.
Unformatted Edit Display - Keyed Data set
COMMAND ===> SCROLL ===> PAGE
RECORD: 1 LENGTH: 198
----+ ----1----+----2----+----3----+----4----+----5----+----6----+----
1 00090 MARTIN EDWARD M AIRPLANE MANUFACTURER 427890
*----+----*----+----*----+----*----+----*----+----*----+----*----+----
70 125 101954920101M30000} & & 859 O'FARREL ST. SAN FRANCISC
*----+----*----+----*----+----*----+----*----+----*----+----*----+----
140 O CA 12121BILL JONES 40855558974155556981
Enter FMT (formatted mode), VFMT (vertical format), CHAR (character mode)
In Browse, the current line number is also included as shown in the following figure.
Unformatted Browse Display - Non-keyed Data set
COMMAND ===> SCROLL ===> PAGE
RECORD: 1 LENGTH: 198
----+----1----+----2----+----3----+----4----+----5----+----6----+----7
1 00090MARTIN EDWARD M AIRPLANE MANUFACTURER 4278901
----+----*----+----*----+----*----+----*----+----*----+----*----+----*
71 25 101954920101M30000} & & 859 O'FARREL ST. SAN FRANCISCO
----+----*----+----*----+----*----+----*----+----*----+----*----+----*
141 CA 12121BILL JONES 40855558974155556981
Edit Record Length
You can modify the LRECL of a variable length record by typing over the record length displayed on the screen.
- If the new record length is shorter than the current length, data will be truncated.
- If the new record length is longer than the current length, the extra bytes will be padded with the PAD character in your profile (see also PAD).
Related topics