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

File-AID - Edit - USERID9.FASAMP.EMPLOYEE ---------------- COLUMNS 000001 000101
 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.

Important

No line commands are available in formatted edit mode.

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.

Important

UTF-8 PICTURE U with DYNAMIC length is not supported.

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

File-AID - Edit - USERID9.FASAMP.EMPMAST ------------------ COLUMNS 00001 00072
 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

File-AID - Edit - USERID9.FASAMP.EMPLOYEE --------------- COLUMNS 000001 000071
 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

File-AID - Edit - USERID9.FASAMP.EMPLOYEE ----------------- COLUMNS 00001 00033
 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.

Important

If your double byte character spans the boundary of the display line, it will not display in Unformatted mode. To view this data, switch to Character mode and scroll the record to the desired position, then return to Unformatted mode to view the character 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

File-AID - Edit - USERID9.FASAMP.EMPLOYEE --------------- COLUMNS 000001 000198
 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

File-AID - Browse - USERID9.FASAMP.EMPMAST --------------- LINE 0001 COL 1  198
 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).


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*