Chapter 2. Browsing a Data File
File-AID enables you to browse a file created through any standard MVS access method (including IAM files). You can display the entire dataset or a selected subset of records. You can supply record layouts and view your data in three display modes:- Character
- Formatted
- Vertical formatted.
Character Mode
The character browse mode provides a full-screen view of the data. From character mode, you can use the FMT primary command to redisplay the data in formatted mode or use the VFMT primary command to redisplay the data in vertical formatted mode.Formatted Mode
The formatted browse mode lets you view data using a record layout. This mode presents data one record at a time and formats each record field-by-field. Record layouts can be either COBOL (FD: 01 level) or PL/I (Declare). Cross references (XREFs) are used to define automatic selection of record layouts for datasets with multiple record types. From formatted mode, you can use the CHAR primary command to redisplay the data in character mode or use the VFMT primary command to redisplay the data in vertical formatted mode.Vertical Formatted Mode
The vertical formatted browse mode also provides a full-screen view of the data. This mode, however, uses the record layout fields as column headers. From vertical formatted mode, you can use the CHAR primary command to redisplay the data in character mode or use the FMT primary command to redisplay the data in formatted mode.2.1 Accessing the Browse Function (Option 1)
The Browse function is shown as option 1 on the File-AID Primary Option Menu.Steps:
- Enter a 1 in the OPTION field on the File-AID Primary Option Menu (not shown here).
- Press <Enter>. File-AID displays the Browse - Dataset Specification screen as illustrated in Figure 2-1.
2.2 Selecting Records to Browse
Figure 2-1. Browse - Dataset Specification Screen. Using a Pattern Dataset Name.+------------------------------------------------------------------------------- | File-AID -------------- Browse - Dataset Specification ---------------------| | COMMAND ===> | | | | Browse Mode ===> F (F=Formatted; C=Char; V=Vertical) | | | | Specify Browse Information: | | Browse dataset name ===> FASAMP.* | | Member name ===> (Blank or pattern for member list)| | Volume serial ===> (If dataset is not cataloged) | | | | | | Specify Record Layout and XREF Information: | | Record layout usage ===> S (S = Single; X = XREF; N = None) | | Record layout dataset ===> FASAMP.LAYOUTS | | Member name ===> EMPLOYEE (Blank or pattern for member list)| | XREF dataset name ===> | | Member name ===> (Blank or pattern for member list)| | | | Specify Selection Criteria Information: (E = Existing; T = Temporary; | | Selection criteria usage ===> T M = Modify; Q = Quick; N = None) | | Selection dataset name ===> | | Member name ===> (Blank or pattern for member list)| | | | | +-------------------------------------------------------------------------------
Use the Browse - Dataset Specification screen to define your browse request, which consists of:
- Browse Mode
- Browse Dataset
- Record Layout and XREF Information
- Selection Criteria Usage Information.
Steps:
- Type an F in the Browse Mode field to request the Formatted mode for viewing your data records.
- Type the dataset name and pattern character FASAMP.* in the Browse
dataset field.
The asterisk is a pattern character. It represents any
single-level qualifier, or partial-level qualifier when it is preceded by 1 to 7
characters. When you use a pattern character in a dataset name, File-AID
displays a list of dataset names that match the pattern you specified. You can
then use the S line command to select a dataset from this list. Other valid
pattern characters include question mark (?) and percent (%) (single character),
as well as plus () and slash (/). Refer to the File-AID MVS Online
Reference Manual (SPF and XE) for more information on pattern dataset
names.
- Type an S in the Record layout usage field to indicate that you are using a single layout member to describe your data records.
- Type the dataset name FASAMP.LAYOUTS in the Record layout dataset
field.
The record layout dataset is a dataset containing the source code for one or
more record layouts. You can use a layout that is embedded in a source program.
An XREF member is used to extract an embedded layout from a source member. A
record layout dataset can be a sequential, partitioned, PANVALET, or LIBRARIAN
dataset. File-AID Release 6 map libraries are fully supported. The record
layout must be a valid COBOL or PL/I declaration. Otherwise, the displayed data
may be invalid.
- Type the member name EMPLOYEE in the layout Member name field.
If you do not specify a member, File-AID displays a list of members. You can
then select a member from this list.
- Type a T in the Selection criteria usage field to indicate that you
want to create a new temporary selection criteria specification.
Selection criteria enables you to select specific records in a data file for
processing. Usage option T (Temporary) dynamically invokes the Selection
Criteria function and presents the selection criteria menu (see Figure
2-3).
When you specify either T or Q in the Selection criteria usage field on the Browse - Dataset Specification screen, File-AID permits you to save your temporary selection criteria by issuing the SAVE command. File-AID displays a screen to give you the opportunity to save your criteria permanently in a selection criteria dataset. Your sample training file, userid.FASAMP.SELCRIT, may be used to save selection criteria you create.
- Press <Enter>. File-AID displays the Dataset List illustrated in Figure 2-2.
2.2.1 Selecting the Browse Input Dataset
Since you entered an asterisk pattern character as part of the dataset name in the Dataset name field on the Browse - Dataset Specification screen, File-AID displays a list of datasets that match the pattern you specified. Select the dataset you want to use from this list.Steps:
- Enter the S (select) line command next to the dataset
userid.FASAMP.EMPMAST.
In the figure below, userid is shown as USERID9. Your TSO ID should
appear on your list.
- Press <Enter>. File-AID displays the Selection Criteria Menu screen illustrated in Figure 2-3.
+------------------------------------------------------------------------------- | File-AID ------------- Catalog Utility Dataset List ---- Select BROWSE Input| | COMMAND ===> SCROLL ===> PAGE| | ----- D A T A S E T N A M E -------------- --Type-- -Volume- -Status- | | USERID9.FASAMP.COMPARE CLUSTER PRD928 | | USERID9.FASAMP.EMPLOYEE CLUSTER PRD928 | | USERID9.FASAMP.EMPLOYE2 NON-VSAM PRD925 | | S USERID9.FASAMP.EMPMAST NON-VSAM PRD925 | | USERID9.FASAMP.INVFILE NON-VSAM PRD925 | | USERID9.FASAMP.INVFILE2 NON-VSAM PRD925 | | USERID9.FASAMP.JCL NON-VSAM PRD925 | | USERID9.FASAMP.LAYOUTS NON-VSAM PRD925 | | USERID9.FASAMP.ORDRFILE NON-VSAM PRD925 | | USERID9.FASAMP.RFMTDEF NON-VSAM PRD925 | | USERID9.FASAMP.SEGFILE NON-VSAM PRD925 | | USERID9.FASAMP.SELCRIT NON-VSAM PRD925 | | USERID9.FASAMP.XREF NON-VSAM PRD925 | | ******************************* BOTTOM OF DATA *******************************| | | | | | | | | | | | | +-------------------------------------------------------------------------------
More About the Catalog Utility Dataset List
- S is the only valid line command and may be specified for only one dataset.
- The Dataset List of matching names is displayed whenever you use a pattern character to specify a dataset name on any File-AID screen.
2.2.2 Specifying Temporary Selection Criteria
Figure 2-3. File-AID Selection Criteria Menu Screen+------------------------------------------------------------------------------- | File-AID - Selection Criteria Menu - TEMPORARY -------------------------------| | OPTION ===> 1 | | - Status - | | 1 OPTIONS - Enter selection criteria options default | | 2 FORMATTED - Edit formatted selection criteria 0 sets | | 3 UNFORMATTED - Edit unformatted selection criteria 0 sets | | | | | | Member list description ===> SC FOR EMPMAST________________ | | | | Long ===> LIMIT TO 12 RECORDS MEETING THE FOLLOWING: SINGLE AND LOCAL_| | Description ===> TAX LE 7 OR LIVING IN AREA CODES 404, 408 OR 415_____________| | | | | | | | | | | | | | Use VIEW command to display selection criteria summary | | Use SAVE command to write selection criteria request | | Use END to continue processing | | Use CANCEL to return to main panel | | | | | +-------------------------------------------------------------------------------
Use the Selection Criteria Menu screen to access facilities for defining selection conditions based on formatted or unformatted field selection criteria and/or options for reading records.
Option 1 (Enter selection criteria options) displays the Selection Criteria Options screen. Here you can tell File-AID where you want to begin selecting records, establish a random read pattern, and set limits on the number of records processed.
Steps:
- Enter a 1 in the OPTION field.
- Enter the description SC FOR EMPMAST in the Member list description
field.
Since this is temporary selection criteria the description is optional.
However, if you decide to SAVE this criteria permanently, File-AID displays this
description on the Member List screen.
- Enter the description LIMIT TO 12 RECORDS MEETING THE FOLLOWING: SINGLE
AND LOCAL TAX LE 7 OR LIVING IN AREA CODES 404, 408, OR 415 in the Long
Description field.
Once again, since this is temporary criteria, descriptions are not needed
unless you SAVE your temporary criteria,
- Press <Enter>. File-AID displays the Selection Criteria Options screen as shown in Figure 2-4.
More About Temporary Selection Criteria
- From the criteria menu you can access selection options or either of the two types of field selection criteria: formatted and unformatted.
- Formatted selection criteria allow you to select records based on data within a field as specified by a record layout.
- Unformatted selection criteria allow you to select records based on freeform data specifications without using a record layout.
- Processing of your temporary selection criteria occurs when you END from the menu.
- If you specify usage option Q (Quick) on the Browse - Dataset Specification screen, File-AID creates temporary criteria but bypasses the Selection criteria menu screen and takes you directly to the unformatted selection criteria screen. When you END from the unformatted screen, your selection criteria is applied immediately. With usage Q, default options are used and all records are read and selected based on the defaults you establish in your 0.2 Selection Parameters for number of records to search and select.
2.2.3 Specifying the Selection Criteria Options
Figure 2-4. Selection Criteria Options Screen+------------------------------------------------------------------------------- | File-AID -------------- Selection Criteria Options -------------------------| | COMMAND ===> FMT | | | | Specify Selection Criteria Options: | | Start at the following record key | | (both blank for start of dataset) | | Starting record key ===> | | - OR - OR at the following RBA or RRN | | Starting RBA or RRN ===> | | | | Initial records to skip ===> 0 then skip this many records | | | | Subsequent Selection Interval: then repeat the following | | Records to select ===> 1 - select this many records | | Records to skip ===> 0 - then skip this many records | | until | | Number of records to search ===> ALL you have read this many records | | Number of records to select ===> 12 or selected this many records | | | | SEQ/VSAM processing direction ===> F (F = Forward; B = Backward) | | | | | | Use ENTER to return to selection criteria menu | | | +-------------------------------------------------------------------------------
The Selection Criteria Options screen allows you to control the selection of records based on a starting record key, RBA or RRN, and record counts. File-AID reads and selects records in a file based on the values you specify on this screen. File-AID then compares the selected records to any formatted and unformatted selection criteria to determine if any of the selected records match the selection criteria.
In this example, you limit the number of selected matching records to 12.
Steps:
- Type a value of 12 in the Number of records to select field.
The value you specify in this field sets the limit for the total number of
records that File-AID selects from the dataset. Valid values are ALL (the
default), 0 (means all), and 1 through 999999.
- Type FMT in the COMMAND field.
The FMT primary command invokes the Formatted Selection Criteria screen.
- Press <Enter>. File-AID displays the EMPLOYEE record layout as illustrated in Figure 2-5.
More About Selection Criteria Options
- If no command is issued, both END or ENTER produce the same result: you are returned to the selection criteria menu.
- The "Starting record key" field enables you to specify a random starting point for File-AID to begin selecting records. You can specify this field for VSAM KSDS, keyed BDAM, and ISAM files. All records before the starting record key are not selected, regardless of matching formatted or unformatted field selection criteria.
- The "Starting RBA or RRN" field enables you to specify a random starting point for record selection in a VSAM or BDAM dataset. All records before the specified starting RBA or RRN are not selected, regardless of matching formatted or unformatted field selection criteria.
- The "Initial records to skip" field tells File-AID how many records to skip before processing the dataset. Valid values are 0 through 999999. A value of 0 (zero) tells File-AID to process all records in the dataset.
- The Subsequent Selection Interval: "Records to select" field tells File-AID
how many records to retrieve from the dataset per interval. Valid values are 1
through 999999. The default value is 1. File-AID applies all field selection
criteria after it retrieves each record.
The Subsequent Selection Interval: "Records to skip" field tells File-AID how
many records to skip after it reaches the value you specified in the "Records to
select" field. A value greater than 0 (zero) establishes the selection interval.
Valid values are 0 through 999999. A value of 0 (zero) tells File-AID to ignore
the "Interval Records to select" value.
- The "Number of records to search" field tells File-AID the maximum number of records to read from the dataset. This parameter can prevent excessive I/O processing when searching large files. Valid values are ALL and 0 through 999999. The default for the field is ALL. Both ALL and 0 (zero) indicate to search the entire file.
- The "Number of records to select" field tells File-AID the maximum number of records to select if the records match the selection criteria. Valid values are ALL and 0 through 999999. The default for the field is ALL. Both ALL and 0 (zero) indicate no limit on the number of records selected. You may establish your own default value for these fields by using option 0.2 (Selection Criteria Parameters).
- The "SEQ/VSAM processing direction" field indicates the direction in which File-AID is to read the file (sequential or VSAM). Valid values are F (forward) and B (backward). If you specify a value of B when processing a file other than a sequential or VSAM file, File-AID ignores the value and starts processing at the beginning of the file.
2.2.4 Formatted Selection Criteria Screen
Figure 2-5. Formatted Selection Criteria Screen+------------------------------------------------------------------------------- | File-AID --- Formatted Selection Criteria ----------------- COLUMNS 00001 00098| | COMMAND ===> SCROLL ===> PAGE| | SC010- Valid commands are: INSERT, DELETE, REPEAT, VIEW, SAVE, CANCEL, PROFILE | | ---- FIELD LEVEL/NAME ------- -FORMAT- RO ----+---1----+---2----+---3----+ | | ******************************* TOP OF DATA ******************************** | | 5 EMP-NUMBER 5/AN | | 5 EMP-LAST-NAME 15/AN | | 5 EMP-FIRST-NAME 10/AN | | 5 EMP-MID-INIT 1/AN | | 5 FILLER 2/AN | | 5 EMP-TITLE 30/AN | | 5 EMP-PERSONAL-INFO SYNC 23/GRP | | 10 EMP-NATL-ID-NUMBER 9/NUM | | 10 FILLER 1/AN | | 10 EMP-DATE-OF-BIRTH 6/AN | | 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH | | 10 EMP-DOB-REDEF SYNC 6/GRP | | 15 EMP-DOB-MM 2/NUM | | 15 EMP-DOB-DD 2/NUM | | 15 EMP-DOB-YY 2/NUM | | 10 EMP-HIRE-DATE 6/AN | | 10 EMP-MARITAL-STATUS 1/AN | | 5 EMP-WITHOLD-INFO SYNC 15/GRP | | Use VIEW command to browse selection criteria summary | +-------------------------------------------------------------------------------
General Information About Formatted Selection Criteria
On initial entry to the formatted screen, a message is displayed on line 3 and lists some of the valid commands you can use. In addition to the commands listed, valid commands include:| CAPS | Use CAPS OFF to establish exact case testing for character fields. Default CAPS ON provides tests for any case and translates entered lowercase characters to uppercase. |
| DISPLAY | Control fields displayed and format of fields. |
| END | Return to the Selection Criteria Menu screen. |
| SHOW | Control information displayed in center column (OFFSET, FORMAT, PICTURE). |
| OFFSET | Control format of offset shown (COLUMNS, RELATIVE, HEX). |
| OPTIONS | Jump to Selection Criteria Options screen. |
| UNFMT | Jump to Unformatted Selection Criteria screen. |
| ZERO | Control zero suppress for numeric fields. |
| Profile tailoring commands | See Table 2-1 for a complete list of the user profile options and the corresponding profile commands. |
2.2.5 Viewing Layout in Column Location Order
Issue the SHOW OFFSET command to see the offset of each layout field. (To define unformatted field criteria later in this example, you need to know the offset of the EMP-CON-HOME-PHONE field.)Figure 2-6. Formatted Selection Criteria Screen (SHOW OFFSET Command)
+------------------------------------------------------------------------------- | File-AID --- Formatted Selection Criteria -------------- | | COMMAND ===> SHOW OFFSET | | SC010- Valid commands are: INSERT, DELETE, REPEAT, VIEW, | | ---- FIELD LEVEL/NAME ------- -FORMAT- RO ----+---1---- | | ******************************* TOP OF DATA ************ | | 5 EMP-NUMBER 5/AN | +-------------------------------------------------------------------------------
Steps:
- Type SHOW OFFSET in the COMMAND field.
- Press <Enter>. File-AID redisplays the Formatted Selection Criteria screen as shown in Figure 2-7 displaying the column position of the first byte of each field.
Formatted Selection Criteria - Field Offsets
Figure 2-7. Formatted Selection Criteria - Field Offset Information+------------------------------------------------------------------------------- | File-AID --- Formatted Selection Criteria ----------------- COLUMNS 00001 00098| | COMMAND ===> SCROLL ===> PAGE| | CRITERIA NUMBER: 1 OF 1 EMPLOYEE-MASTER-FILE LAYOUT LENGTH: 198| | ---- FIELD LEVEL/NAME ------- COLUMNS- RO ----+---1----+---2----+---3----+ | | ******************************* TOP OF DATA ******************************** | | 5 EMP-NUMBER 1 | | 5 EMP-LAST-NAME 6 | | 5 EMP-FIRST-NAME 21 | | 5 EMP-MID-INIT 31 | | 5 FILLER 32 | | 5 EMP-TITLE 34 | | 5 EMP-PERSONAL-INFO SYNC 64 | | 10 EMP-NATL-ID-NUMBER 64 | | 10 FILLER 73 | | 10 EMP-DATE-OF-BIRTH 74 | | 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH | | 10 EMP-DOB-REDEF SYNC 74 | | 15 EMP-DOB-MM 74 | | 15 EMP-DOB-DD 76 | | 15 EMP-DOB-YY 78 | | 10 EMP-HIRE-DATE 80 | | 10 EMP-MARITAL-STATUS 86 | | 5 EMP-WITHOLD-INFO SYNC 87 | | Use VIEW command to browse selection criteria summary | +-------------------------------------------------------------------------------
2.2.6 Suppressing the Display of Field Redefinitions
Issue the REDEFINES OFF command to suppress the display of field redefinitions. REDEFINES can be abbreviated REDEF.Note: The REDEFINES profile setting command issued during selection criteria definition is temporary and does not affect the browse/edit formatted display profile setting. Most other profile setting commands will affect the browse/edit profile. Upon initial entry to the formatted selection criteria screen, File-AID temporarily sets REDEFINES ON.
Figure 2-8. Suppress Redefinitions (REDEF OFF Command)
+------------------------------------------------------------------------------- | File-AID --- Formatted Selection Criteria -------------- | | COMMAND ===> REDEF OFF | | CRITERIA NUMBER: 1 OF 1 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- COLUMNS- RO ----+---1---- | | ******************************* TOP OF DATA ************ | | 5 EMP-NUMBER 1 | +-------------------------------------------------------------------------------
Steps:
- Type REDEF OFF in the COMMAND field.
- Press <Enter>. File-AID redisplays the Formatted Selection Criteria screen as shown in Figure 2-9 and suppresses the EMP-DOB redefinitions of EMP-DATE-OF-BIRTH.
Formatted Selection Criteria - Without Redefines
Figure 2-9. Formatted Selection Criteria Entry Screen - Without Redefines+------------------------------------------------------------------------------- | File-AID --- Formatted Selection Criteria ----------------- COLUMNS 00001 00098| | COMMAND ===> SCROLL ===> PAGE| | CRITERIA NUMBER: 1 OF 1 EMPLOYEE-MASTER-FILE LAYOUT LENGTH: 198| | ---- FIELD LEVEL/NAME ------- COLUMNS- RO ----+---1----+---2----+---3----+ | | ******************************* TOP OF DATA ******************************** | | 5 EMP-NUMBER 1 | | 5 EMP-LAST-NAME 6 | | 5 EMP-FIRST-NAME 21 | | 5 EMP-MID-INIT 31 | | 5 FILLER 32 | | 5 EMP-TITLE 34 | | 5 EMP-PERSONAL-INFO SYNC 64 | | 10 EMP-NATL-ID-NUMBER 64 | | 10 FILLER 73 | | 10 EMP-DATE-OF-BIRTH 74 | | 10 EMP-HIRE-DATE 80 | | 10 EMP-MARITAL-STATUS 86 | | 5 EMP-WITHOLD-INFO SYNC 87 | | 10 EMP-LIFE-INS-WITHOLD-AMT 87 | | 10 EMP-NATL-TAX-WITHOLD-PCT 93 | | 10 EMP-REGION-TAX-WITHOLD-PCT | | 96 | | 10 EMP-LOCAL-TAX-WITHOLD-PCT | | Use VIEW command to browse selection criteria summary | +-------------------------------------------------------------------------------
2.2.7 Defining Formatted Field Selection Criteria
You can selectively choose records for processing by defining one or more conditions that a record must meet in order to be selected. With formatted selection criteria, you can select records based on the value of a specified field within the record layout. To search for a specific field value, you must define a test condition for that field. The test condition consists of the field name, a relational operator (RO), and the value for which you want to test.The relational operator is entered under the RO column on the screen and can be specified in a letter or symbolic format (for example, "equal to" can be specified as EQ or =). The field value is entered to the right of the relational operator. Numeric field data is always entered as a decimal value (digits 0-9) with a decimal point if needed.
Steps:
- Type EQ in the RO column next to the field name EMP-MARITAL-STATUS.
- Type an S in the data area (to the right of the EQ you just typed) to define the test "MARITAL-STATUS EQUAL TO S".
- Type DOWN in the COMMAND field and press <Enter> (or use PF8) to view more layout fields. File-AID scrolls the Formatted Selection Criteria screen down one full page as shown in Figure 2-11.
+------------------------------------------------------------------------------- | File-AID --- Formatted Selection Criteria ----------------- COLUMNS 00001 00098| | COMMAND ===> DOWN SCROLL ===> PAGE | | CRITERIA NUMBER: 1 OF 1 EMPLOYEE-MASTER-FILE LAYOUT LENGTH: 198| | ---- FIELD LEVEL/NAME ------- COLUMNS- RO ----+---1----+---2----+---3----+ | | ******************************* TOP OF DATA ******************************** | | 5 EMP-NUMBER 1 | | 5 EMP-LAST-NAME 6 | | 5 EMP-FIRST-NAME 21 | | 5 EMP-MID-INIT 31 | | 5 FILLER 32 | | 5 EMP-TITLE 34 | | 5 EMP-PERSONAL-INFO SYNC 64 | | 10 EMP-NATL-ID-NUMBER 64 | | 10 FILLER 73 | | 10 EMP-DATE-OF-BIRTH 74 | | 10 EMP-HIRE-DATE 80 | | 10 EMP-MARITAL-STATUS 86 EQ S | | 5 EMP-WITHOLD-INFO SYNC 87 | | 10 EMP-LIFE-INS-WITHOLD-AMT 87 | | 10 EMP-NATL-TAX-WITHOLD-PCT 93 | | 10 EMP-REGION-TAX-WITHOLD-PCT | | 96 | | 10 EMP-LOCAL-TAX-WITHOLD-PCT | | Use VIEW command to browse selection criteria summary | +-------------------------------------------------------------------------------
More About Selection Criteria
- Other relational operators (RO) supported include:
NE Not equal LE Less than or equal LT Less than GT Greater than GE Greater than or equal EQ Equal CO Contains NC Not contains BT Between (specify value1:value2 - endpoints inclusive) NB Not between (specify value1:value2 - endpoints exclusive) VA Valid NV Not Valid - To specify a search argument that contains case-sensitive data, you must enter the CAPS OFF primary command.
- Multiple values can be tested in non-numeric fields using the CO and EQ operators by separating the values with commas. For example: EQ ABC,DEF,GHI
- You can use the REPEAT or INSERT command to add a new selection criteria set. Sets are ORed together and only one of the test sets must be true. If a record fails to match CRITERIA NUMBER 1 in an ORed condition, File-AID tests the record to see if CRITERIA NUMBER 2 matches. As soon as a record matches any set, File-AID selects it. If a record fails to match any formatted set, it is checked against each unformatted set. If the record fails all tests, it is not selected.
2.2.8 Defining a Compound AND Condition
When you specify test conditions for more than one field in a criteria set, File-AID links the tests together (the tests are ANDed) and requires that all the conditions be true before it selects a record. You can use the REPEAT or INSERT command to add a new selection criteria set. Sets are ORed.Figure 2-11. Formatted Selection Criteria - Compound AND Condition
+------------------------------------------------------------------------------- | File-AID --- Formatted Selection Criteria ----------------- COLUMNS 00099 00198| | COMMAND ===> UNFMT SCROLL ===> PAGE | | CRITERIA NUMBER: 1 OF 1 EMPLOYEE-MASTER-FILE LAYOUT LENGTH: 198| | ---- FIELD LEVEL/NAME ------- COLUMNS- RO ----+---1----+---2----+---3----+ | | 10 EMP-LOCAL-TAX-WITHOLD-PC 99 LE 7 | | 5 EMP-HOME-ADDRESS SYNC 102 | | 10 EMP-STREET-ADDRESS 102 | | 10 FILLER 127 | | 10 EMP-CITY 128 | | 10 EMP-STATE-PROV-CNTY SYNC 143 | | 15 EMP-STATE 143 | | 15 FILLER 145 | | 10 EMP-POSTAL-CODE 147 | | 5 EMP-EMERGENCY-CONTACT SYNC 152 | | 10 EMP-CONTACT-NAME 152 | | 10 FILLER 177 | | 10 EMP-CON-WORK-PHONE 179 | | 10 EMP-CON-HOME-PHONE 189 | | ***************************** BOTTOM OF DATA ******************************* | | | | Use VIEW command to browse selection criteria summary | +-------------------------------------------------------------------------------
Steps:
- Type LE in the RO column next to the field name EMP-LOCAL-TAX-WITHOLD-PCT.
- Type a 7 in data area to define the test.
You have now created a compound criteria set matching records with
MARITAL-STATUS EQUAL TO S and EMP-LOCAL-TAX-WITHOLD-PCT LESS THAN OR
EQUAL TO 7.
- Notice the column offset (189) of the EMP-CON-HOME-PHONE field. In Figure 2-12 you define a test to select records based on the value of the area code (first three characters of the PHONE field) using unformatted selection criteria.
- Type UNFMT in the COMMAND field.
Instead of entering the UNFMT command, you could enter the END primary
command to return to the Selection Criteria Menu and then select option 3
(Unformatted). Or, you could have entered the 3 command. 3 is an alias for
UNFMT.
- Press <Enter> to display the Unformatted Selection Criteria screen as shown in Figure 2-12.
2.2.9 Defining Unformatted Field Selection Criteria
Without using a record layout, you can define a test condition based on the known position of a field or you can scan for a data value contained within the record. In this example, you want to select records that have area code 404, 408, or 415 in the EMP-CON-HOME-PHONE field, which starts at column position 189. You can test for data matching any one of a list of values by separating each test value with a comma.Figure 2-12. Unformatted Selection Criteria Screen. Testing for a List of Values
+------------------------------------------------------------------------------- | File-AID ------------- Unformatted Selection Criteria --- ROW 1 TO 16 OF 25| | COMMAND ===> END SCROLL ===> PAGE| | | | Use END command to continue, use CANCEL command to return to main screen. | | | | AND | | Cmd /OR Position Length RO Data Value | | --- --- -------- ------ -- ---------------------------------------------------| | ___ 189__ _____ EQ 404,408,415________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| | ___ AND _____ _____ EQ ___________________________________________________| +-------------------------------------------------------------------------------
Steps:
- Type 189 on the first entry line under the Position column.
The Position tells File-AID where in the record to begin the search.
- Verify that the value of the relational operator is "equal to" (either
EQ or =).
The relational operator default value is EQ. Use option 0.2 Selection
Defaults if you want to change the default.
- Type 404,408,415 in the Data Value column.
File-AID interprets a comma in the search argument as an OR condition within
the current set. To search for a comma as data, you must enclose the comma in
double quotes (for example, "data,contains,commas").
- Type END in the COMMAND field.
- Press <Enter>. File-AID returns to the Selection Criteria Menu screen as shown in Figure 2-13.
2.3 Processing Your Selection
Use the END primary command from the Selection Criteria Menu to indicate that you have finished creating and reviewing your temporary selection criteria and are now ready to see the results. Before processing, you may optionally use the VIEW command to review your selection criteria.Figure 2-13. Selection Criteria Menu - END to Initiate Processing
+------------------------------------------------------------------------------- | File-AID - Selection Criteria Menu - TEMPORARY -------------------------------| | OPTION ===> END | | - Status - | | 1 OPTIONS - Enter selection criteria options not default | | 2 FORMATTED - Edit formatted selection criteria 1 sets | | 3 UNFORMATTED - Edit unformatted selection criteria 1 sets | | | | | | Member list description ===> SC FOR EMPMAST________________ | | | | Long ===> LIMIT TO 12 RECORDS MEETING THE FOLLOWING: SINGLE AND LOCAL_| | Description ===> TAX LE 7 OR LIVING IN AREA CODES 404, 408 OR 415_____________| | | | | | | | Use VIEW to display selection criteria summary | | Use SAVE to write selection criteria request | | Use END to continue processing | | Use CANCEL to return to main panel | | | +-------------------------------------------------------------------------------
Steps:
- Type END in the OPTION field.
- Press <Enter>. File-AID displays the Browse formatted screen for the first selected record in the dataset USERID9.FASAMP.EMPMAST as shown in Figure 2-14.
2.3.1 Formatted Display of First Selected Record
After File-AID reads the data file and applies your selection criteria, the first record that matches your selection criteria is displayed in formatted mode as shown in Figure 2-14. Recall that you specified F (formatted) as the value in the Browse Mode field on the Browse - Dataset Specification screen (Figure 2-1).The length of the record is indicated in the LENGTH field at the right on line three of the display heading. (You can type over this value when using the Edit function on variable length records.)
Figure 2-14. Browse - Formatted Mode - First Selected Record
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 92| | COMMAND ===> SCROLL ===> PAGE | | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198 | | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+---2----+---3----+---4| | 5 EMP-NUMBER 1 00090 | | 5 EMP-LAST-NAME 6 MARTIN | | 5 EMP-FIRST-NAME 21 EDWARD | | 5 EMP-MID-INIT 31 M | | 5 FILLER 32 | | 5 EMP-TITLE 34 AIRPLANE MANUFACTURER | | 5 EMP-PERSONAL-INFO SYNC 64 | | 10 EMP-NATL-ID-NUMBER 64 427890125 | | 10 FILLER 73 | | 10 EMP-DATE-OF-BIRTH 74 101954 | | 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH | | 10 EMP-DOB-REDEF SYNC 74 | | 15 EMP-DOB-MM 74 10 | | 15 EMP-DOB-DD 76 19 | | 15 EMP-DOB-YY 78 54 | | 10 EMP-HIRE-DATE 80 920101 | | 10 EMP-MARITAL-STATUS 86 M | | 5 EMP-WITHOLD-INFO SYNC 87 | | 10 EMP-LIFE-INS-WITHOLD-AMT 87 30000} | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
Status Display Feature
File-AID reads your data file and compares each record to your selection criteria. If your file contains a large number of records and you have not placed limits on the number of records to search and select, it may take several seconds before your selected records are presented. File-AID provides a special real-time File Processing Status screen (not shown here) to keep you informed about the number of records processed. File-AID automatically displays (refreshes) this screen whenever you have to wait more than five (5) seconds for results. You may use the ATTN key to stop processing and view partial results.2.3.2 Displaying the Next Record in the Dataset
You can use the UP, DOWN, BACK (or LEFT), and FORWARD (or RIGHT) primary commands to navigate within a formatted display of a record and to move to the next or previous record. In formatted mode, the UP and DOWN primary commands enable you to view more fields within the current record. The BACK (alias LEFT) and FORWARD (aliases: FWD, RIGHT) primary commands scroll the display to the previous and next records, respectively.Now, use the FORWARD (FWD) command to tell File-AID to scroll the display to the next record.
Figure 2-15. Display Next Record (FWD Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> FWD | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+ | | 5 EMP-NUMBER 1 00090 | +-------------------------------------------------------------------------------
Steps:
- Type FWD in the COMMAND field.
- Press <Enter>. File-AID displays the next selected record, as shown in Figure 2-16.
+-------------------------------------------------------------------------------
| File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 92|
| COMMAND ===> SCROLL ===> PAGE |
| RECORD: 2 EMPLOYEE-MASTER-FILE LENGTH: 198 |
| ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+---2----+---3----+---4|
| 5 EMP-NUMBER 1 00200 |
| 5 EMP-LAST-NAME 6 JACKSON |
| 5 EMP-FIRST-NAME 21 JOSEPH |
| 5 EMP-MID-INIT 31 C |
| 5 FILLER 32 |
| 5 EMP-TITLE 34 ORATOR |
| 5 EMP-PERSONAL-INFO SYNC 64 |
| 10 EMP-NATL-ID-NUMBER 64 275587177 |
| 10 FILLER 73 |
| 10 EMP-DATE-OF-BIRTH 74 020462 |
| 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH |
| 10 EMP-DOB-REDEF SYNC 74 |
| 15 EMP-DOB-MM 74 2 |
| 15 EMP-DOB-DD 76 4 |
| 15 EMP-DOB-YY 78 62 |
| 10 EMP-HIRE-DATE 80 920121 |
| 10 EMP-MARITAL-STATUS 86 S |
| 5 EMP-WITHOLD-INFO SYNC 87 |
| 10 EMP-LIFE-INS-WITHOLD-AMT 87 00000{ |
| Enter CHAR for character mode, VFMT for vertical format mode |
+-------------------------------------------------------------------------------
More About Navigating To Browse Your Formatted Records
- Each of the navigation commands has a corresponding PF key set as the
default in your user profile. The default settings are:
PF7 UP PF8 DOWN PF10 LEFT (BACK) PF11 RIGHT (FORWARD) - You can specify a number of records to scroll forward. For example, if record number 10 is the currently displayed record and you enter RIGHT 8, File-AID displays the 18th record in the dataset.
- You can specify a number of records to scroll backward. For example, if record number 10 is the currently displayed record and you enter BACK 8, File-AID displays the 2nd selected record in the dataset.
- Note that the number of the record is indicated in the RECORD field located in line three of the display heading.
- Another navigation command is LR n (locate record number n). For example, LR 4 displays selected record number 4.
2.3.3 Displaying the Previous Record in the Dataset
The BACK command tells File-AID to scroll the display to the previous record.Figure 2-17. Display Previous Record (BACK Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> BACK | | RECORD: 2 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+ | | 5 EMP-NUMBER 1 00200 | +-------------------------------------------------------------------------------
Steps:
- Type BACK in the COMMAND field.
- Press <Enter>. File-AID displays the previous selected record, as shown in Figure 2-18.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 9| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+---2----+---3----+---| | 5 EMP-NUMBER 1 00090 | | 5 EMP-LAST-NAME 6 MARTIN | | 5 EMP-FIRST-NAME 21 EDWARD | | 5 EMP-MID-INIT 31 M | | 5 FILLER 32 | | 5 EMP-TITLE 34 AIRPLANE MANUFACTURER | | 5 EMP-PERSONAL-INFO SYNC 64 | | 10 EMP-NATL-ID-NUMBER 64 427890125 | | 10 FILLER 73 | | 10 EMP-DATE-OF-BIRTH 74 101954 | | 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH | | 10 EMP-DOB-REDEF SYNC 74 | | 15 EMP-DOB-MM 74 10 | | 15 EMP-DOB-DD 76 19 | | 15 EMP-DOB-YY 78 54 | | 10 EMP-HIRE-DATE 80 920101 | | 10 EMP-MARITAL-STATUS 86 M | | 5 EMP-WITHOLD-INFO SYNC 87 | | 10 EMP-LIFE-INS-WITHOLD-AMT 87 30000} | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
2.4 Displaying the User Profile Options
Use the PROFILE primary command to display the current profile settings. The profile options that are displayed vary by display mode and record layout language. Table 2-1 lists all of the profile options, the type of information each option controls, the mode under which it is displayed and language dependencies (COBOL or PL/I).Figure 2-19. Browse - Formatted Mode (PROFILE Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> PROFILE | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+ | | 5 EMP-NUMBER 1 00090 | +-------------------------------------------------------------------------------
Steps:
- Type PROFILE in the COMMAND field.
- Press <Enter>. File-AID displays three profile lines at the top of the data area as shown in Figure 2-20.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST -------------------------- COL 1 9| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD LEVEL/NAME ------- -FORMAT- ----+---1----+---2----+---3----+---| | =PROF> ..CAPS OFF....FILLER ON....GROUP ON....OCCURS ON....OFFSET COLUMNS.....| | =PROF> ..PICT OFF....PROT OFF....REDEF OFF....SHOW LEVEL....SYNC ON...........| | =PROF> ..ZERO OFF....MESSAGE ON...............................................| | 5 EMP-NUMBER 1 00090 | | 5 EMP-LAST-NAME 6 MARTIN | | 5 EMP-FIRST-NAME 21 EDWARD | | 5 EMP-MID-INIT 31 M | | 5 FILLER 32 | | 5 EMP-TITLE 34 AIRPLANE MANUFACTURER | | 5 EMP-PERSONAL-INFO SYNC 64 | | 10 EMP-NATL-ID-NUMBER 64 427890125 | | 10 FILLER 73 | | 10 EMP-DATE-OF-BIRTH 74 101954 | | 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH | | 10 EMP-DOB-REDEF SYNC 74 | | 15 EMP-DOB-MM 74 10 | | 15 EMP-DOB-DD 76 19 | | 15 EMP-DOB-YY 78 54 | | 10 EMP-HIRE-DATE 80 920101 | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
More About Profile Settings
- Each option has a corresponding primary command to let you change the setting (for example, GROUP ON or GROUP OFF). A summary of profile options is shown in Table 2-1.
Table 2-1. User Profile Options
| Option | Mode | Language | Controls display of ... |
|---|---|---|---|
| ALIGN | FMT | PL/I | ALIGNED/UNALIGNED term |
| ARRAY | FMT | PL/I | ARRAY information |
| AUTOSAVE | All modes | any | ON or OFF issue SAVE on END |
| BOUNDS | CHAR,VFMT | any | current bounds settings |
| CAPS | All modes | any | ON or OFF uppercase entered text |
| COMPLEX | FMT | PL/I | COMPLEX term |
| FILLER | FMT, VFMT | COBOL, PL/I | FILLER fields |
| GROUP | FMT | COBOL, PL/I | occurrences of group-level items |
| HEX | CHAR,VFMT | any | hexadecimal display of data |
| MESSAGE | all modes | any | mode command prompt line |
| OCCURS | FMT | COBOL | array declaration lines |
| OFFSET | FMT, VFMT | COBOL, PL/I | format for display of field offset information |
| PAD | CHAR | any | PAD character for shift |
| PICTURE | FMT | COBOL, PL/I | PICTURE or DISPLAY line for numeric data fields |
| PROTECT | FMT | COBOL, PL/I | ON or OFF key data protection |
| REDEFINES | FMT, VFMT | COBOL | data item redefinitions |
| REFLNG | FMT | PL/I | field length reference lines for BIT and CHAR |
| SETUNDO | All modes | any | ON or OFF toggle UNDO support |
| SHOW | FMT, VFMT | COBOL, PL/I | LEVEL, NUMBER, FORMAT, OFFSET, or PICTURE information |
| STATS | CHAR,VFMT | any | ISPF statistics update |
| SYNC | FMT | COBOL | SYNC term for layout fields |
| ZERO | FMT, VFMT | COBOL, PL/I | leading zeros in numeric data fields. |
2.4.1 Removing the Profile Settings Information
Use the RESET command to hide the profile information lines (indicated with =PROF>).Figure 2-21. Browse - Formatted Mode (RESET Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> RESET | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+ | | =PROF> ..CAPS OFF....FILLER ON....GROUP ON....OCCURS ON | +-------------------------------------------------------------------------------
Steps:
- Type RESET in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen without the profile information lines. shown in Figure 2-22.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 9| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+---2----+---3----+---| | 5 EMP-NUMBER 1 00090 | | 5 EMP-LAST-NAME 6 MARTIN | | 5 EMP-FIRST-NAME 21 EDWARD | | 5 EMP-MID-INIT 31 M | | 5 FILLER 32 | | 5 EMP-TITLE 34 AIRPLANE MANUFACTURER | | 5 EMP-PERSONAL-INFO SYNC 64 | | 10 EMP-NATL-ID-NUMBER 64 427890125 | | 10 FILLER 73 | | 10 EMP-DATE-OF-BIRTH 74 101954 | | 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH | | 10 EMP-DOB-REDEF SYNC 74 | | 15 EMP-DOB-MM 74 10 | | 15 EMP-DOB-DD 76 19 | | 15 EMP-DOB-YY 78 54 | | 10 EMP-HIRE-DATE 80 920101 | | 10 EMP-MARITAL-STATUS 86 M | | 5 EMP-WITHOLD-INFO SYNC 87 | | 10 EMP-LIFE-INS-WITHOLD-AMT 87 30000} | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
2.5 Specifying the Type of Field Information to Display
The SHOW primary command (abbrev. S) sets the display of various types of field information for a record. You now use SHOW PICTURE to change the center column to display data element PICTURE information for each field.Figure 2-23. Browse - Formatted Mode (SHOW PICTURE Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> SHOW PICTURE | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+ | | 5 EMP-NUMBER 1 00090 | +-------------------------------------------------------------------------------
Steps:
- Type SHOW PICTURE in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen, changing the heading of the Field Description area to PICTURE and displaying the data declaration of each elementary item. The changed display is shown in Figure 2-24.
Result of SHOW PICTURE
Figure 2-24. Browse - Formatted Mode - After SHOW PICTURE Command+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 92| | COMMAND ===> SCROLL ===> PAGE | | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198 | | ---- FIELD LEVEL/NAME ------- PICTURE- ----+---1----+---2----+---3----+---4| | 5 EMP-NUMBER X(5) 00090 | | 5 EMP-LAST-NAME X(15) MARTIN | | 5 EMP-FIRST-NAME X(10) EDWARD | | 5 EMP-MID-INIT X M | | 5 FILLER XX | | 5 EMP-TITLE X(30) AIRPLANE MANUFACTURER | | 5 EMP-PERSONAL-INFO SYNC GROUP | | 10 EMP-NATL-ID-NUMBER 9(9) 427890125 | | 10 FILLER X | | 10 EMP-DATE-OF-BIRTH X(6) 101954 | | 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH | | 10 EMP-DOB-REDEF SYNC GROUP | | 15 EMP-DOB-MM 99 10 | | 15 EMP-DOB-DD 99 19 | | 15 EMP-DOB-YY 99 54 | | 10 EMP-HIRE-DATE X(6) 920101 | | 10 EMP-MARITAL-STATUS X M | | 5 EMP-WITHOLD-INFO SYNC GROUP | | 10 EMP-LIFE-INS-WITHOLD-AMT DISPLAY 30000} | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
More About the SHOW Command
- Valid syntax for the SHOW command includes:
SHOW PICTURE Change center column heading to PICTURE and information for each field to show the data declaration (see Figure 2-24). Abbrev: S P. SHOW FORMAT Change center column heading to FORMAT and shows the length and format of each field (see Figure 2-28). Abbrev: S F. SHOW OFFSET Change center column heading to COLUMNS and show the offset of each field relative to byte 1 (see Figure 2-26). Abbrev: S O. You can tailor the offset using the OFFSET primary command (see 2.5.1 , "Displaying the Offset for Each Field" for a description of the OFFSET command and its parameters). SHOW LEVEL Change left column heading to FIELD LEVEL/NAME and show the hierarchical level number (see Figure 2-24). Abbrev: S L. SHOW NUMBER Change left column heading to FIELD NUMBER/NAME and show the system-assigned field number (see Figure 2-30). Abbrev: S N.
2.5.1 Displaying the Offset for Each Field
The command SHOW OFFSET is used to change the center column to display information about the offset of each field.Figure 2-25. Browse - Formatted Mode (SHOW OFFSET Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> SHOW OFFSET | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- PICTURE- ----+---1----+ | | 5 EMP-NUMBER X(5) 00090 | +-------------------------------------------------------------------------------
Steps:
- Type SHOW OFFSET in the COMMAND field.
(tip) SHOW may be abbreviated to S. Keyword OFFSET may be abbreviated to O.
Therefore "S O" is the same as "SHOW OFFSET". Most commands can be shortened as
long as they can be uniquely identified.
- Press <Enter>. File-AID redisplays the screen, changing the heading of the Field Description area to indicate the format of the record's offset and displaying the offset of each field from the beginning of the record.
Result of SHOW OFFSET
Figure 2-26. Browse - Formatted Mode - After SHOW OFFSET Command+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 9| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+---2----+---3----+---| | 5 EMP-NUMBER 1 00090 | | 5 EMP-LAST-NAME 6 MARTIN | | 5 EMP-FIRST-NAME 21 EDWARD | | 5 EMP-MID-INIT 31 M | | 5 FILLER 32 | | 5 EMP-TITLE 34 AIRPLANE MANUFACTURER | | 5 EMP-PERSONAL-INFO SYNC 64 | | 10 EMP-NATL-ID-NUMBER 64 427890125 | | 10 FILLER 73 | | 10 EMP-DATE-OF-BIRTH 74 101954 | | 10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH | | 10 EMP-DOB-REDEF SYNC 74 | | 15 EMP-DOB-MM 74 10 | | 15 EMP-DOB-DD 76 19 | | 15 EMP-DOB-YY 78 54 | | 10 EMP-HIRE-DATE 80 920101 | | 10 EMP-MARITAL-STATUS 86 M | | 5 EMP-WITHOLD-INFO SYNC 87 | | 10 EMP-LIFE-INS-WITHOLD-AMT 87 30000} | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
More About the SHOW OFFSET Command
- Offset information can be displayed in three ways by using the OFFSET
primary profile command.
Valid syntax for the OFFSET (OFST) command includes:
OFFSET RELATIVE Change the center column to RELATIVE and show a decimal offset of each field relative to byte 0. Abbrev: O R. OFFSET HEX Change the center column to REL(HEX) and show the offset of each field in a hexadecimal format relative to byte 0. Abbrev: O H. OFFSET COLUMNS Change the center column to COLUMNS and show the offset of each field relative to byte 1 (see Figure 2-26). Abbrev: O C.
2.5.2 Displaying Current Field Length and Format
You now use SHOW FORMAT to change the center column to display data element length and usage information for each field.Figure 2-27. Browse - Formatted Mode (SHOW FORMAT Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> SHOW FORMAT | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- COLUMNS- ----+---1----+ | | 5 EMP-NUMBER 1 00090 | +-------------------------------------------------------------------------------
Steps:
- Type SHOW FORMAT in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen, changing the heading of the Field Description area to FORMAT and displaying the field length and format of each field.
Result of SHOW FORMAT
Figure 2-28. Browse - Formatted Mode - After SHOW FORMAT Command+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 10| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD LEVEL/NAME ------- -FORMAT- ----+---1----+---2----+---3----+---| | 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-HIRE-DATE 6/AN 920101 | | 10 EMP-MARITAL-STATUS 1/AN M | | 5 EMP-PERSONAL-INFO SYNC 15/GRP | | 10 EMP-LIFE-INS-WITHOLD-AMT 6/SNUM -3000.00 | | 10 EMP-NATL-TAX-WITHOLD-PCT 3/PS -74.00 | | 10 EMP-REGION-TAX-WITHOLD-PCT | | 3/PS 25.00 | | 10 EMP-LOCAL-TAX-WITHOLD-PCT | | 3/PS 5.00 | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
2.5.3 Displaying Field Numbers
File-AID assigns a sequential field number to each layout field. These field numbers can be used in several commands to control the display and to refer to specific fields more easily.Figure 2-29. Browse - Formatted Mode (SHOW NUMBER Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> SHOW NUMBER | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD LEVEL/NAME ------- -FORMAT- ----+---1----+ | | 5 EMP-NUMBER 1 00090 | +-------------------------------------------------------------------------------
Steps:
- Type SHOW NUMBER in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen, changing the heading of the Field Name area to FIELD NUMBER/NAME and displaying the File-AID-assigned number for each field. The changed display is shown in Figure 2-30.
Result of SHOW NUMBER
Figure 2-30. Browse - Formatted Mode - After SHOW NUMBER Command+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 10| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+---2----+---3----+---| | 1 EMP-NUMBER 5/AN 00090 | | 2 EMP-LAST-NAME 15/AN MARTIN | | 3 EMP-FIRST-NAME 10/AN EDWARD | | 4 EMP-MID-INIT 1/AN M | | 5 FILLER 2/AN | | 6 EMP-TITLE 30/AN AIRPLANE MANUFACTURER | | 7 EMP-PERSONAL-INFO SYNC 23/GRP | | 8 EMP-NATL-ID-NUMBER 9/NUM 427890125 | | 9 FILLER 1/AN | | 10 EMP-DATE-OF-BIRTH 6/AN 101954 | | 15 EMP-HIRE-DATE 6/AN 920101 | | 16 EMP-MARITAL-STATUS 1/AN M | | 17 EMP-PERSONAL-INFO SYNC 15/GRP | | 18 EMP-LIFE-INS-WITHOLD-AMT 6/SNUM -3000.00 | | 19 EMP-NATL-TAX-WITHOLD-PCT 3/PS -74.00 | | 20 EMP-REGION-TAX-WITHOLD-PCT | | 3/PS 25.00 | | 21 EMP-LOCAL-TAX-WITHOLD-PCT | | 3/PS 5.00 | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
2.6 Displaying Only Specific Fields by Number (The DISPLAY Command)
The DISPLAY command references the File-AID-assigned field numbers. You can use the DISPLAY primary command to display several types of information including:- All or selected fields of a record
- The display format (HEX for example) for individual layout fields
- One or all redefinitions of the same data.
Figure 2-31. Browse - Formatted Mode (DISPLAY ONLY Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> DISPLAY 1-6 16 21 ONLY | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+ | | 1 EMP-NUMBER 5/AN 00090 | +-------------------------------------------------------------------------------
Steps:
- Type DISPLAY 1-6 16 21 ONLY in the COMMAND field.
You can separate the field numbers by blanks or commas. You may specify
individual fields and/or field ranges (two fields connected by a hyphen:
a-b).
- Press <Enter>. Only the data items in fields 1 thru 6, 16, and 21 are displayed as illustrated in Figure 2-32.
Result of DISPLAY ONLY command
Figure 2-32. Browse - Formatted Mode - After DISPLAY ONLY Command+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 10| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+---2----+---3----+---| | ******************************** TOP OF DATA *********************************| | 1 EMP-NUMBER 5/AN 00090 | | 2 EMP-LAST-NAME 15/AN MARTIN | | 3 EMP-FIRST-NAME 10/AN EDWARD | | 4 EMP-MID-INIT 1/AN M | | 5 FILLER 2/AN | | 6 EMP-TITLE 30/AN AIRPLANE MANUFACTURER | | 16 EMP-MARITAL-STATUS 1/AN M | | 21 EMP-LOCAL-TAX-WITHOLD-PCT | | 3/PS 5.00 | | ****************************** BOTTOM OF DATA ********************************| | | | | | | | | | | | | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
More About the DISPLAY Command
- You can specify up to nine field numbers or field ranges, listed in any order.
- The abbreviation for DISPLAY is DIS.
- The ON, OFF, and ONLY parameters can be placed before, after, or in any position within the field list.
- In formatted mode, the set of fields that you define with the DISPLAY command is associated with a record layout and reused each time a record is mapped to that layout. You can define a separate set of fields to be displayed for each record layout if an XREF is in use.
- The SHOW NUMBER command is used to tailor the display to show the field numbers.
- The FPRINT command generates a report of one or more records and uses the current SHOW and DISPLAY settings to determine which fields are to appear on the report. (What you see is what you get.)
2.6.1 Excluding Fields from the Display
The DISPLAY OFF command can be used to hide additional fields.Figure 2-33. Browse - Formatted Mode (DISPLAY OFF Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> DIS 3-6 OFF | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+ | | 1 EMP-NUMBER 5/AN 00090 | +-------------------------------------------------------------------------------
Steps:
- Type DIS 3-6 OFF in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen, excluding fields 3-6 (EMP-FIRST-NAME, EMP-MID-INIT, FILLER, and EMP-TITLE) from the display as illustrated in Figure 2-34.
Result of DISPLAY OFF
Figure 2-34. Browse - Formatted Mode - After DISPLAY 3-6 OFF Command+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 10| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+---2----+---3----+---| | ******************************** TOP OF DATA *********************************| | 1 EMP-NUMBER 5/AN 00090 | | 2 EMP-LAST-NAME 15/AN MARTIN | | 16 EMP-MARITAL-STATUS 1/AN M | | 21 EMP-LOCAL-TAX-WITHOLD-PCT | | 3/PS 5.00 | | ****************************** BOTTOM OF DATA ********************************| | | | | | | | | | | | | | | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
2.6.2 Adding Fields to the Display
A subsequent DISPLAY command only changes what is requested by the current command.Figure 2-35. Browse - Formatted Mode (DISPLAY ON Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> DIS 34 ON | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+ | | 1 EMP-NUMBER 5/AN 00090 | +-------------------------------------------------------------------------------
Steps:
- Type DIS 34 ON in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen and adds field 34 to the set of currently displayed fields as illustrated in Figure 2-36.
Result of DISPLAY 34 ON
Figure 2-36. Browse - Formatted Mode - After DIS 34 ON Command+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 19| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+---2----+---3----+---| | ******************************** TOP OF DATA *********************************| | 1 EMP-NUMBER 5/AN 00090 | | 2 EMP-LAST-NAME 15/AN MARTIN | | 16 EMP-MARITAL-STATUS 1/AN M | | 21 EMP-LOCAL-TAX-WITHOLD-PCT | | 3/PS 5.00 | | 34 EMP-CON-HOME-PHONE 10/AN 4155556981 | | ****************************** BOTTOM OF DATA ********************************| | | | | | | | | | | | | | | | | | | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
2.6.3 Redisplaying all the Fields of a Record
To redisplay all fields, use the DISPLAY ALL command. No field numbers are allowed with this syntax.Figure 2-37. Browse - Formatted Mode (DISPLAY ALL Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> DIS ALL | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+ | | 1 EMP-NUMBER 5/AN 00090 | +-------------------------------------------------------------------------------
Steps:
- Type DIS ALL in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen with all of the fields for record 1 as illustrated in Figure 2-38.
Result of DISPLAY ALL
Figure 2-38. Browse - Formatted Mode - After DISPLAY ALL+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ------------------------- COL 1 10| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 1 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+---2----+---3----+---| | ******************************** TOP OF DATA *********************************| | 1 EMP-NUMBER 5/AN 00090 | | 2 EMP-LAST-NAME 15/AN MARTIN | | 3 EMP-FIRST-NAME 10/AN EDWARD | | 4 EMP-MID-INIT 1/AN M | | 5 FILLER 2/AN | | 6 EMP-TITLE 30/AN AIRPLANE MANUFACTURER | | 7 EMP-PERSONAL-INFO SYNC 23/GRP | | 8 EMP-NATL-ID-NUMBER 9/NUM 427890125 | | 9 FILLER 1/AN | | 10 EMP-DATE-OF-BIRTH 6/AN 101954 | | 15 EMP-HIRE-DATE 6/AN 920101 | | 16 EMP-MARITAL-STATUS 1/AN M | | 17 EMP-PERSONAL-INFO SYNC 15/GRP | | 18 EMP-LIFE-INS-WITHOLD-AMT 6/SNUM -3000.00 | | 19 EMP-NATL-TAX-WITHOLD-PCT 3/PS -74.00 | | 20 EMP-REGION-TAX-WITHOLD-PCT | | 3/PS 25.00 | | 21 EMP-LOCAL-TAX-WITHOLD-PCT | | Enter CHAR for character mode, VFMT for vertical format mode | +-------------------------------------------------------------------------------
2.7 Searching for Data Using the FIND Primary Command
The FIND primary command searches for and displays, if found, data meeting specified conditions.2.7.1 Displaying the FIND Command Screen
When you enter the FIND command without parameters, File-AID displays the FIND Command screen. Use the FIND Command screen to specify the search conditions.Figure 2-39. FIND command with no parameters
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> FIND | | RECORD: 1 EMPLOYEE-MASTER-FILE | | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+ | | 1 EMP-NUMBER 5/AN 00090 | +-------------------------------------------------------------------------------
Steps:
- Type FIND in the COMMAND field.
- Press <Enter>. File-AID displays the FIND Command screen as illustrated in Figure 2-40.
FIND Command Prompt Screen
Use the FIND Command screen to specify the search conditions.Figure 2-40. FIND Command Prompt Screen
+------------------------------------------------------------------------------- | File-AID ----------------- FIND Command ------------------------------------| | COMMAND ===> | | | | Specify FIND operands: | | Operator ===> (EQ; NE; LT; GT; LE; GE) | | Find string ===> | | Modifier ===> NEXT (NEXT; ALL; FIRST; LAST; PREV) | | Lines to search ===> (NX = Nonexcluded; X = Excluded; Blank = all)| | | | Specify the Following Fields to Limit the Range of Search for this FIND: | | Field name ===> | | or | | Field number ===> | | or | | Start column ===> End column ===> (Column number(s)) | | Start range ===> End range ===> (Label or line number)| | | | NOTE: You may bypass this screen by entering the FIND command with operands: | | FIND string (NEXT) (NX) (col-1 (col-2)) (range) | | F (op) string (ALL) (X) (/field name) | | VALID (FIRST) (/field number) | | INVALID (LAST) | | * (PREV) | +-------------------------------------------------------------------------------
2.7.2 Specifying a FIND Using The Command Prompt Screen
Figure 2-41. FIND Command Prompt Screen - FIND JONES in EMP-LAST-NAME+------------------------------------------------------------------------------- | File-AID ----------------- FIND Command -----------------------------------| | COMMAND ===> | | | | Specify FIND operands: | | Operator ===> EQ (EQ; NE; LT; GT; LE; GE) | | Find string ===> JONES | | Modifier ===> NEXT (NEXT; ALL; FIRST; LAST; PREV) | | Lines to search ===> (NX = Nonexcluded; X = Excluded; Blank = all| | | | Specify the Following Fields to Limit the Range of Search for this FIND: | | Field name ===> EMP-LAST-NAME | | or | | Field number ===> | | or | | Start column ===> End column ===> (Column number(s)) | | Start range ===> End range ===> (Label or line number| | | | NOTE: You may bypass this screen by entering the FIND command with operands: | | FIND string (NEXT) (NX) (col-1 (col-2)) (range) | | F (op) string (ALL) (X) (/field name) | | VALID (FIRST) (/field number) | | INVALID (LAST) | | * (PREV) | +-------------------------------------------------------------------------------
The fields on the FIND Command screen correspond to the FIND primary command syntax parameters. Refer to the File-AID MVS Online Reference Manual (SPF and XE) for information on the FIND command syntax. A sample of the FIND syntax is displayed on the bottom half of the screen.
Steps:
- Type EQ in the Operator field.
The relational operator EQ indicates that data must equal the value specified
in the Find string field. Other valid operators are listed to the right of the
field name. EQ is assumed when no operator is specified.
- Type JONES in the Find string field.
The Find string field contains the value that you want to match defined by
the value you specify in the Operator field.
- Type NEXT in the Modifier field.
The value you specify in the Modifier field tells File-AID where to begin and
in which direction to search. Using the NEXT value, File-AID searches forward in
the dataset starting at the current cursor position.
- Type EMP-LAST-NAME in the Field name field.
Use the Field name field to limit the search to this field only in each
record.
- Press <Enter>. File-AID searches the EMP-LAST-NAME field in each record to find the value JONES. When found, the screen is automatically scrolled to show the data found as illustrated in Figure 2-42.
Result of FIND command
Figure 2-42. Browse - FIND Result - JONES found in Record 6+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- 'JONES ' FOUND| | COMMAND ===> SCROLL ===> PAGE| | RECORD: 6 EMPLOYEE-MASTER-FILE LENGTH: 198| | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+---2----+---3----+---| | 2 EMP-LAST-NAME 15/AN JONES | | 3 EMP-FIRST-NAME 10/AN GEORGE | | 4 EMP-MID-INIT 1/AN B | | 5 FILLER 2/AN | | 6 EMP-TITLE 30/AN COUNTRY SINGER | | 7 EMP-PERSONAL-INFO SYNC 23/GRP | | 8 EMP-NATL-ID-NUMBER 9/NUM 463813456 | | 9 FILLER 1/AN | | 10 EMP-DATE-OF-BIRTH 6/AN 090944 | | 15 EMP-HIRE-DATE 6/AN 920221 | | 16 EMP-MARITAL-STATUS 1/AN S | | 17 EMP-PERSONAL-INFO SYNC 15/GRP | +-------------------------------------------------------------------------------
More About the FIND Command
- In order for File-AID to search for exact case data, you must specify the Find value as a delimited string with a C (explicit character) data type. For example, 'Jones' matches the values of Jones, jones, and JONES. However, C'Jones' matches only the value of Jones.
- The Find string parameter can be any one of the following data type strings:
Simple Value without quotes or data types specified. Matches both upper and lowercase values. The Find string, JONES, in Figure 2-41 is an example of a simple data type string. Delimited Specified with single quotes. The string can include imbedded spaces For example, 'delim ited' and T'delim ited' are equivalent. Character Expressed as C'string' explicit case Hexadecimal Expressed as X'hex digits'. Decimal A number using digits 0--9. Used when a field-name/number is also specified. Packed Expressed as P'signed decimal number'. VALID and INVALID These validity keywords are used with a field-name/number to determine if the field contains valid or invalid data based on the layout definition of the field (a layout is required).
2.8 Invoking Character Mode (CHAR) from Formatted Mode
Character mode data displays are full-screen presentations of multiple records of a dataset. The command structure and display layout are similar to those of ISPF. The displayed data can consist of the entire dataset or only a selected subset of records (when selection criteria is used).Figure 2-43. Browse - Invoking Character Mode (CHAR Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> CHAR | | RECORD: 6 EMPLOYEE-MASTER-FILE | | ---- FIELD NUMBER/NAME ------ -FORMAT- ----+---1----+ | | 2 EMP-LAST-NAME 15/AN JONES | +-------------------------------------------------------------------------------
Steps:
- Type CHAR in the COMMAND field.
- Press <Enter>. File-AID displays your data records in character mode as shown in Figure 2-44.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- LINE 0000 COL 1 8| | COMMAND ===> SCROLL ===> PAGE| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER 427890125 101954| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200JACKSON JOSEPH C ORATOR 275587177 020462| | 10000ANDREWS GEORGE ACTOR 576312032 042248| | 15000MURPHY RONALD L PAINTER 987654321 120255| | 18034SCHNEIDER ELLEN C NURSE 341559549 032960| | 21035JONES GEORGE B COUNTRY SINGER 463813456 090944| | 25100ROBERTS WILLIAM R POLITICIAN 879563325 050865| | 27007ALLEN JOYCE M AUTHOR 783458334 012132| | 30001RICHARDS REX W RODEO CLOWN 632764534 040140| | 31000SAVAGE JONATHON C ELECTRICIAN 348567992 062250| | 34010SMITH JANET AIRLINE ATTENDANT 557782984 112359| | 34011JACOBS DIANA DOCTOR 225368395 021757| | ******************************** BOTTOM OF DATA ********************-CAPS OFF-*| | | | | | | | | | | | | | Enter FMT for formatted mode, VFMT for vertical format, HEX ON for Hex | +-------------------------------------------------------------------------------
Controlling the Records Not Selected Line
When using selection criteria, records which did not match your selection criteria are indicated with an information line:- - - n RECORDS NOT SELECTED - - -The appearance of the "NOT SELECTED" information line is controlled by the 0.1 System parameter "Display records not selected line" default.
2.9 Displaying Data in Hexadecimal Format
The Character mode display shows multiple records in a full screen, unformatted display.Use the HEX ON primary command to view your data in three-line character and hexadecimal format. HEX display is valid in character mode and in vertical formatted mode (VFMT).
Figure 2-45. Display Data in Hex (HEX Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> HEX ON | | ********************************* TOP OF DATA ********** | | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER | +-------------------------------------------------------------------------------
Steps:
- Return the cursor to the COMMAND field. When switching to Character mode from Formatted or Vertical Formatted mode, the cursor is positioned on the byte of data that was at the top of the formatted display.
- Type HEX ON in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen and presents the data in its hexadecimal notation.
Result of HEX ON
Figure 2-46. Character Mode - After HEX ON+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- LINE 0000 COL 1 8| | COMMAND ===> SCROLL ===> PAGE| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER 427890125 101954| | FFFFFDCDECD444444444CCECDC4444D44CCDDDCDC4DCDECCCEEDCD444444444FFFFFFFFF4FFFFFF| | 0009041939500000000054619400004001997315504154613349590000000004278901250101954| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200JACKSON JOSEPH C ORATOR 275587177 020462| | FFFFFDCCDEDD44444444DDECDC4444C44DDCEDD444444444444444444444444FFFFFFFFF4FFFFFF| | 0020011322650000000016257800003006913690000000000000000000000002755871770020462| | -------------------------------------------------------------------------------| | 10000ANDREWS GEORGE ACTOR 576312032 042248| | FFFFFCDCDCEE44444444CCDDCC4444444CCEDD4444444444444444444444444FFFFFFFFF4FFFFFF| | 1000015495620000000075697500000001336900000000000000000000000005763120320042248| | -------------------------------------------------------------------------------| | 15000MURPHY RONALD L PAINTER 987654321 120255| | FFFFFDEDDCE444444444DDDCDC4444D44DCCDECD44444444444444444444444FFFFFFFFF4FFFFFF| | 1500044978800000000096513400003007195359000000000000000000000009876543210120255| | -------------------------------------------------------------------------------| | 18034SCHNEIDER ELLEN C NURSE 341559549 032960| | FFFFFECCDCCCCD444444CDDCD44444C44DEDEC4444444444444444444444444FFFFFFFFF4FFFFFF| | 1803423855945900000053355000003005492500000000000000000000000003415595490032960| | -------------------------------------------------------------------------------| | Enter FMT for formatted mode, VFMT for vertical format, HEX OFF for Char | +-------------------------------------------------------------------------------
2.9.1 Redisplaying Character Format from Hexadecimal Format
Use HEX OFF to return to display only the character value for each line.Figure 2-47. Display Characters Only (HEX OFF)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> HEX OFF | | ********************************* TOP OF DATA ********** | | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER | | FFFFFDCDECD444444444CCECDC4444D44CCDDDCDC4DCDECCCEEDCD44 | | 00090419395000000000546194000040019973155041546133495900 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 | +-------------------------------------------------------------------------------
Steps:
- Type HEX OFF in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen in character format as illustrated in Figure 2-48.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- LINE 0000 COL 1 8| | COMMAND ===> SCROLL ===> PAGE| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER 427890125 101954| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200JACKSON JOSEPH C ORATOR 275587177 020462| | 10000ANDREWS GEORGE ACTOR 576312032 042248| | 15000MURPHY RONALD L PAINTER 987654321 120255| | 18034SCHNEIDER ELLEN C NURSE 341559549 032960| | 21035JONES GEORGE B COUNTRY SINGER 463813456 090944| | 25100ROBERTS WILLIAM R POLITICIAN 879563325 050865| | 27007ALLEN JOYCE M AUTHOR 783458334 012132| | 30001RICHARDS REX W RODEO CLOWN 632764534 040140| | 31000SAVAGE JONATHON C ELECTRICIAN 348567992 062250| | 34010SMITH JANET AIRLINE ATTENDANT 557782984 112359| | 34011JACOBS DIANA DOCTOR 225368395 021757| | ******************************** BOTTOM OF DATA ********************-CAPS OFF-*| | | | | | | | | | | | | | Enter FMT for formatted mode, VFMT for vertical format, HEX ON for Hex | +-------------------------------------------------------------------------------
2.10 Displaying the Column Number Information Line
The COLS primary command displays the COLS information line. The information line is a ruler which allows you to identify the specific location of data in the data area of the screen.Figure 2-49. Display COLS Ruler (COLS command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> COLS | | ********************************* TOP OF DATA ********** | | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER | +-------------------------------------------------------------------------------
Steps:
- Type COLS in the COMMAND field.
- Press <Enter>. File-AID displays the ruler line at the top of the data display as illustrated in Figure 2-50.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- LINE 0000 COL 1 8| | COMMAND ===> SCROLL ===> PAGE| | ----+---1----+---2----+---3----+---4----+---5----+---6----+---7----+---| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER 427890125 101954| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200JACKSON JOSEPH C ORATOR 275587177 020462| | 10000ANDREWS GEORGE ACTOR 576312032 042248| | 15000MURPHY RONALD L PAINTER 987654321 120255| | 18034SCHNEIDER ELLEN C NURSE 341559549 032960| | 21035JONES GEORGE B COUNTRY SINGER 463813456 090944| | 25100ROBERTS WILLIAM R POLITICIAN 879563325 050865| | 27007ALLEN JOYCE M AUTHOR 783458334 012132| | 30001RICHARDS REX W RODEO CLOWN 632764534 040140| | 31000SAVAGE JONATHON C ELECTRICIAN 348567992 062250| | 34010SMITH JANET AIRLINE ATTENDANT 557782984 112359| | 34011JACOBS DIANA DOCTOR 225368395 021757| | ******************************** BOTTOM OF DATA ********************-CAPS OFF-*| | | | | | | | | | Enter FMT for formatted mode, VFMT for vertical format, HEX ON for Hex | +-------------------------------------------------------------------------------
More About COLS Command
- When you scroll the data display to the right beyond column 100, the ruler is useful for determining the last two (low-order) digits of the column number. The range of columns displayed is indicated in the top right corner of the display (except when overwritten by an error message).
- If the record key is included in the display, the COLS line contains spaces to separate the key's position.
- In the Edit function, COLS is a line command not a primary command.
2.11 Searching for Data In a Specific Column
This example illustrates how you can use the column numbers of the ruler line in combination with the FIND primary command to search an exact location for a data value.Figure 2-51. FIND Command Example
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> FIND POLITICIAN 34 | | ----+---1----+---2----+---3----+---4----+---5----+ | | ********************************* TOP OF DATA ********** | | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER | +-------------------------------------------------------------------------------
Steps:
- Type FIND POLITICIAN 34 in the COMMAND field.
In the FIND primary command syntax, POLITICIAN is the Find string
field value and 34 is the value of the Start column field. When you
specify a Start column number, the value you specify as the Find string value
must begin in the specified column position. If the value you are looking for is
a number, enclose the number in single quotes (for example, FIND '18034'
1).
- Press <Enter>. File-AID positions the cursor on the P in POLITICIAN. If necessary the display is automatically scrolled so that the found string is visible. File-AID indicates that it has found the search value by displaying the message 'POLITICIAN' FOUND in the upper-right hand corner of the screen as shown in Figure 2-52.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- 'POLITICIAN' FOUND| | COMMAND ===> SCROLL ===> PAGE| | ----+---1----+---2----+---3----+---4----+---5----+---6----+---7----+---| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER 427890125 101954| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200JACKSON JOSEPH C ORATOR 275587177 020462| | 10000ANDREWS GEORGE ACTOR 576312032 042248| | 15000MURPHY RONALD L PAINTER 987654321 120255| | 18034SCHNEIDER ELLEN C NURSE 341559549 032960| | 21035JONES GEORGE B COUNTRY SINGER 463813456 090944| | 25100ROBERTS WILLIAM R POLITICIAN 879563325 050865| | 27007ALLEN JOYCE M AUTHOR 783458334 012132| | 30001RICHARDS REX W RODEO CLOWN 632764534 040140| | 31000SAVAGE JONATHON C ELECTRICIAN 348567992 062250| | 34010SMITH JANET AIRLINE ATTENDANT 557782984 112359| | 34011JACOBS DIANA DOCTOR 225368395 021757| | ******************************** BOTTOM OF DATA ********************-CAPS OFF-*| | | | | | | | | | | | Enter FMT for formatted mode, VFMT for vertical format, HEX ON for Hex | +-------------------------------------------------------------------------------
2.12 Invoking Vertical Formatted Mode (VFMT) from Character Mode
The vertical formatted (VFMT) mode browse display is the same as the character mode browse display except that it uses the record layout field names as headings at the top of each column with the data formatted and arranged below each heading.Figure 2-53. Invoking Vertical Formatted Mode (VFMT Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ----------- | | COMMAND ===> VFMT | | ----+---1----+---2----+---3----+---4----+---5----+ | | ********************************* TOP OF DATA ********** | | 00090MARTIN EDWARD M AIRPLANE MANUFACTURER | +-------------------------------------------------------------------------------
Steps:
- Type VFMT in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen with the column headings positioned at the top of the data display as illustrated in Figure 2-54.
Vertical Formatted (VFMT) Display
Figure 2-54. Browse - Vertical Formatted Mode+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- LINE 0000 COL 1 4| | COMMAND ===> SCROLL ===> PAGE| | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT FILLER EMP-TITLE | | 5/AN 15/AN 10/AN 1/AN 2/AN 30/AN | | (1-5) (6-20) (21-30) (31-31) (32-33) (34-49) | | 1--------- 2-------------- 3------------- 4----------- 5------- 6--------------| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090 MARTIN EDWARD M AIRPLANE MANUFA| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200 JACKSON JOSEPH C ORATOR | | 10000 ANDREWS GEORGE ACTOR | | 15000 MURPHY RONALD L PAINTER | | 18034 SCHNEIDER ELLEN C NURSE | | 21035 JONES GEORGE B COUNTRY SINGER | | 25100 ROBERTS WILLIAM R POLITICIAN | | 27007 ALLEN JOYCE M AUTHOR | | 30001 RICHARDS REX W RODEO CLOWN | | 31000 SAVAGE JONATHON C ELECTRICIAN | | 34010 SMITH JANET AIRLINE ATTENDA| | 34011 JACOBS DIANA DOCTOR | | ******************************** BOTTOM OF DATA ********************-CAPS OFF-*| | | | | | Enter FMT for formatted mode, CHAR for character format, HEX ON for Hex | +-------------------------------------------------------------------------------
More About Vertical Formatted Mode
- A single record layout must be available to use the VFMT command. You cannot invoke the VFMT command if you are using an XREF or you have not specified a layout.
- If no layout was specified (layout usage=N), the COMPILE primary command lets you dynamically compile a layout for use by VFMT and FMT.
- Field offsets are always shown in the heading. For example (1-5).
- File-AID assigned field numbers are indicated by the dash line in each field heading. For example 1------ means "field number 1".
2.13 Removing the Mode Prompt Message Line
To help guide you, File-AID uses the last line of the display to list valid display mode primary commands.Enter FMT for formatted mode, CHAR for character...After you become familiar with the basic commands (CHAR, FMT, VFMT, and HEX), you can turn off the display of this message line with the MESSAGE command.
Figure 2-55. Suppress Mode Prompt Message Line (MESSAGE OFF)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> MSG OFF | | ----+---1----+---2----+---3----+---4----+---5---- | | ********************************* TOP OF DATA ********* | | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT | | 5/AN 15/AN 10/AN 1/AN | | (1-5) (6-20) (21-30) (31-31) | | 1--------- 2-------------- 3------------- 4----------- | | ********************************* TOP OF DATA ********* | | 00090 MARTIN EDWARD M | | - - - - - - - - - - - - - - - - - - - - - - - - - - - | | 00200 JACKSON JOSEPH C | +-------------------------------------------------------------------------------
Steps:
- Type MSG OFF in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen without the message line as shown in Figure 2-56.
+------------------------------------------------------------------------------- | 30001 RICHARDS REX W RODEO CLOWN | | 31000 SAVAGE JONATHON C ELECTRICIAN | | 34010 SMITH JANET AIRLINE ATTENDA| | 34011 JACOBS DIANA DOCTOR | | ******************************** BOTTOM OF DATA ********************-CAPS OFF-*| | | | | | | +-------------------------------------------------------------------------------
More About the MESSAGE Command
- You can specify the command as MESSAGE or MSG.
- Use MSG ON to redisplay the line.
- Setting is remembered from session to session.
2.14 Specifying the Type of Information to Display
When you invoke the SHOW primary command in vertical formatted mode, File-AID changes the second line of the column headings to identify the type of information you want to display.The SHOW primary command sets the display of various types of field information for a record. Valid keywords for the SHOW command are:
| SHOW PICTURE | Change second line of each column heading to show the data declaration (see Figure 2-58). |
| SHOW FORMAT | Change second line of each column heading to format of each field (see Figure 2-56). |
| SHOW OFFSET | Change second line of each column heading to show the offset of each field relative to byte 1 (see Figure 2-60). |
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> SHOW PICTURE | | ----+---1----+---2----+---3----+---4----+---5---- | | ********************************* TOP OF DATA ********* | | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT | | 5/AN 15/AN 10/AN 1/AN | | (1-5) (6-20) (21-30) (31-31) | | 1--------- 2-------------- 3------------- 4----------- | +-------------------------------------------------------------------------------
Steps:
- Type SHOW PICTURE in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen, changing the second line of each column heading to show the type and maximum length of the items in the column. The changed display is shown in Figure 2-58.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- LINE 0000 COL 1 4| | COMMAND ===> SCROLL ===> PAGE| | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT FILLER EMP-TITLE | | X(5) X(15) X(10) X XX X(30) | | (1-5) (6-20) (21-30) (31-31) (32-33) (34-49) | | 1--------- 2-------------- 3------------- 4----------- 5------- 6--------------| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090 MARTIN EDWARD M AIRPLANE MANUFA| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200 JACKSON JOSEPH C ORATOR | | 10000 ANDREWS GEORGE ACTOR | +-------------------------------------------------------------------------------
More About the SHOW Command
- Note that the field number (for example, 1--------- 2 --------------, etc.) is shown as part of the column heading and, therefore, you do not need to use the SHOW NUMBER command in vertical formatted mode.
- The offsets of each field (for example, (1-5) (6-20) etc.) are also shown in the third line of each column heading. As a result, you probably do not need to use the SHOW OFFSET command. However, the OFFSET commands (OFFSET HEX, OFFSET REL, and OFFSET COL) are valid for tailoring the offset display.
2.14.1 Displaying the Offset for Each Column
Use SHOW OFFSET to change the second line of each column heading to show the offset of each field relative to byte 1.Figure 2-59. Display Field Offset Information (SHOW OFFSET)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> SHOW OFFSET | | ----+---1----+---2----+---3----+---4----+---5---- | | ********************************* TOP OF DATA ********* | | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT | | 5/AN 15/AN 10/AN 1/AN | | (1-5) (6-20) (21-30) (31-31) | | 1--------- 2-------------- 3------------- 4----------- | +-------------------------------------------------------------------------------
Steps:
- Type SHOW OFFSET in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen, changing the second line of each column heading to show the offset for each column of data. The changed display is shown in Figure 2-60.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- LINE 0000 COL 1 4| | COMMAND ===> SCROLL ===> PAGE| | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT FILLER EMP-TITLE | | 1 6 21 31 32 34 | | (1-5) (6-20) (21-30) (31-31) (32-33) (34-49) | | 1--------- 2-------------- 3------------- 4----------- 5------- 6--------------| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090 MARTIN EDWARD M AIRPLANE MANUFA| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200 JACKSON JOSEPH C ORATOR | | 10000 ANDREWS GEORGE ACTOR | +-------------------------------------------------------------------------------
2.14.2 Displaying the Length and Format of Each Field
Use SHOW FORMAT (abbrev: S F) to change the heading to show the length and usage of each field.Figure 2-61. Display Field Format Information (SHOW FORMAT)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> S F | | ----+---1----+---2----+---3----+---4----+---5---- | | ********************************* TOP OF DATA ********* | | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT | | 1 6 21 31 | | (1-5) (6-20) (21-30) (31-31) | | 1--------- 2-------------- 3------------- 4----------- | +-------------------------------------------------------------------------------
Steps:
- Type S F in the COMMAND field.
- Press <Enter>. File-AID redisplays the screen, changing the second line of the column headings to describe the field length and format of each column of data items. The changed display is shown in Figure 2-62. The length of a field is expressed in bytes. The length indicates the actual number of bytes occupied by the field and not the data item size. The PICTURE parameter displays the size of the data item.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------------- LINE 0000 COL 1 4| | COMMAND ===> SCROLL ===> PAGE| | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT FILLER EMP-TITLE | | 5/AN 15/AN 10/AN 1/AN 2/AN 30/AN | | (1-5) (6-20) (21-30) (31-31) (32-33) (34-49) | | 1--------- 2-------------- 3------------- 4----------- 5------- 6--------------| | ********************************* TOP OF DATA **********************-CAPS OFF-*| | 00090 MARTIN EDWARD M AIRPLANE MANUFA| | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | 00200 JACKSON JOSEPH C ORATOR | | 10000 ANDREWS GEORGE ACTOR | | | +-------------------------------------------------------------------------------
2.15 Selecting Fields to Display by Field Number
You can use the DISPLAY primary command to display two types of information:- All or selected fields of a record;
- The display format for individual layout fields.
Figure 2-63. Display Specific Fields (DISPLAY fields ONLY)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> DIS 16 21 34 ONLY | | ----+---1----+---2----+---3----+---4----+---5---- | | ********************************* TOP OF DATA ********* | | EMP-NUMBER EMP-LAST-NAME EMP-FIRST-NAME EMP-MID-INIT | | 5/AN 15/AN 10/AN 1/AN | | (1-5) (6-20) (21-30) (31-31) | | 1--------- 2-------------- 3------------- 4----------- | +-------------------------------------------------------------------------------
Steps:
- Type DIS 16 21 34 ONLY in the COMMAND field.
- Press <Enter>. The data items for fields 16, 21, and 34 only are redisplayed on the screen as illustrated in Figure 2-64.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST -------------- LINE 0000 COL 86 19| | COMMAND ===> SCROLL ===> PAGE| | EMP-MARITAL-STATUS EMP-LOCAL-TAX-WITHOLD-PCT EMP-CON-HOME-PHONE | | 1/AN 3/PS 10/AN | | (86-86) (99-101) (189-198) | | 16---------------- 21----------------------- 34---------------- | | ********************************* TOP OF DATA **********************-CAPS OFF-*| | M 5.00 4155556981 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | S 0 2125559021 | | S 15.00 4045559021 | | S 0 3125559021 | | S 0 4085551245 | | S 7.00 4085551245 | | S 0 4085559021 | | S 0 7135559021 | | | +-------------------------------------------------------------------------------
2.16 Changing the Display Format of a Field
You can use the DISPLAY primary command to change the display format of one or more fields on the display. The DISPLAY command enables you to display field data in different formats. The default format is the format defined in the record layout for each field.You can specify the following formats: binary (BIN), bit (BIT), character (CHAR), packed decimal data (DEC), decimal floating point number (FLOAT), DBCS character (DBCS), and hexadecimal (HEX). This command changes the display format; it does not change the record layout definition of the field. Refer to the File-AID MVS Online Reference Manual (SPF and XE) for a complete description of the DISPLAY primary command.
2.16.1 Displaying Hexadecimal Notation for a Specified Field
Use the DISPLAY fields HEX command to change the display format of one or more fields to horizontal hex. In this example, the field EMP-LOCAL-TAX-WITHOLD-PCT (field number 21) is shown in hex.Figure 2-65. Display Field Data in HEX - (DISPLAY field HEX)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> DIS 21 HEX | | ----+---1----+---2----+---3----+---4----+---5---- | | ********************************* TOP OF DATA ********* | | EMP-MARITAL-STATUS EMP-LOCAL-TAX-WITHOLD-PCT EMP-CON-HO | | 1/AN 3/PS 10/AN | | (86-86) (99-101) (189-198) | | 16---------------- 21----------------------- 34-------- | | ********************************* TOP OF DATA ********* | | M 5.00 4155556981 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - | | S 0 2125559021 | | S 15.00 4045559021 | +-------------------------------------------------------------------------------
Steps:
- Type DIS 21 HEX in the COMMAND field.
- Press <Enter>. The data items in field 21 only are redisplayed in hexadecimal notation as illustrated in Figure 2-66.
Result of DISPLAY 21 HEX
The display format of the 3-byte packed signed numeric field, EMP-LOCAL-TAX-WITHOLD-PCT changes from a normalized, zero suppressed, decimal value (5.00) to the horizontal hex value (000500C). The format information in the heading of field 21 also changes to 3/HEX.Figure 2-66. Vertical Formatted Mode - After DISPLAY 21 HEX
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST -------------- LINE 0000 COL 86 19| | COMMAND ===> SCROLL ===> PAGE| | EMP-MARITAL-STATUS EMP-LOCAL-TAX-WITHOLD-PCT EMP-CON-HOME-PHONE | | 1/AN 3/HEX 10/AN | | (86-86) (99-101) (189-198) | | 16---------------- 21----------------------- 34---------------- | | ********************************* TOP OF DATA **********************-CAPS OFF-*| | M 00500C 4155556981 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | S 00000C 2125559021 | | S 01500C 4045559021 | | S 00000C 3125559021 | | S 00000C 4085551245 | | S 00700C 4085551245 | | S 00700C 7175550855 | | | +-------------------------------------------------------------------------------
More About the DISPLAY Command
- The DISPLAY field definitions you specify are retained until you exit the Browse/Edit function.
- DISPLAY and SHOW command settings affect both Vertical (VFMT) and Formatted (FMT) modes.
2.16.2 Returning Fields to Their Standard Display Format
To return a field to its internal format as defined by the record layout, use the RESET keyword of the DISPLAY primary command.Figure 2-67. Return Field Display to Standard - (DISPLAY field RESET)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> DIS 21 RESET | | ----+---1----+---2----+---3----+---4----+---5---- | | ********************************* TOP OF DATA ********* | | EMP-MARITAL-STATUS EMP-LOCAL-TAX-WITHOLD-PCT EMP-CON-HO | | 1/AN 3/HEX 10/AN | | (86-86) (99-101) (189-198) | | 16---------------- 21----------------------- 34-------- | | ********************************* TOP OF DATA ********* | | M 00500C 4155556981 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - | | S 00000C 2125559021 | | S 01500C 4045559021 | +-------------------------------------------------------------------------------
Steps:
- Type DIS 21 RESET in the COMMAND field.
- Press <Enter>. Field 21 is displayed normalized in decimal format as illustrated in Figure 2-68.
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST -------------- LINE 0000 COL 86 19| | COMMAND ===> SCROLL ===> PAGE| | EMP-MARITAL-STATUS EMP-LOCAL-TAX-WITHOLD-PCT EMP-CON-HOME-PHONE | | 1/AN 3/PS 10/AN | | (86-86) (99-101) (189-198) | | 16---------------- 21----------------------- 34---------------- | | ********************************* TOP OF DATA **********************-CAPS OFF-*| | M 5.00 4155556981 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | S 0 2125559021 | | S 15.00 4045559021 | | S 0 3125559021 | | S 0 4085551245 | | S 7.00 4085551245 | | S 0 4085559021 | | | +-------------------------------------------------------------------------------
2.16.3 Redisplaying All Fields
Use the DISPLAY ALL command to redisplay all fields.Figure 2-69. Redisplay All Fields - (DISPLAY ALL)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> DIS ALL | | ----+---1----+---2----+---3----+---4----+---5---- | | ********************************* TOP OF DATA ********* | | EMP-MARITAL-STATUS EMP-LOCAL-TAX-WITHOLD-PCT EMP-CON-HO | | 1/AN 3/PS 10/AN | | (86-86) (99-101) (189-198) | | 16---------------- 21----------------------- 34-------- | | ********************************* TOP OF DATA ********* | | M 5.00 4155556981 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - | | S 0 2125559021 | | S 15.00 4045559021 | +-------------------------------------------------------------------------------
Steps:
- Type DIS ALL in the COMMAND field.
- Press <Enter>. File-AID redisplays all of the fields.
Result of DISPLAY ALL
Note that when the screen is redisplayed, it is positioned with field number 16 as the first field on the left side of the display. To display the columns containing the data items for fields 1-15, enter the LEFT primary command. To display the columns containing data items following field number 19, enter the RIGHT primary command. The affect of the LEFT and RIGHT commands is similar in character and vertical formatted modes.Also note that field 17 is not shown because it is a group item. Usually, only elementary items are presented in vertical formatted mode.
Figure 2-70. Vertical Formatted Mode - After DISPLAY ALL
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST --------------- LINE 0000 COL 86 9| | COMMAND ===> SCROLL ===> PAGE| | EMP-MARITAL-STATUS EMP-LIFE-INS-WITHOLD-AMT EMP-NATL-TAX-WITHOLD-PCT | | 1/AN 6/SNUM 3/PS | | (86-86) (87-92) (93-95) | | 16---------------- 18---------------------- 19---------------------- | | ********************************* TOP OF DATA **********************-CAPS OFF-*| | M -3000.00 -74.00 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 RECORD(S) NOT SELECTED| | S 0 55.00 | | S 0 INVALID | | S 5000.00 7.00 | | S 5000.00 65.00 | | S 0 49.00 | | S 5000.00 45.00 | | S 5000.00 INVALID | | | +-------------------------------------------------------------------------------
2.16.4 Exiting the Browse Function
To exit the Browse session, use the END primary command.Figure 2-71. Exiting the Browse Session - (END Command)
+------------------------------------------------------------------------------- | File-AID - Browse - USERID9.FASAMP.EMPMAST ---------- | | COMMAND ===> END | | ----+---1----+---2----+---3----+---4----+---5---- | | EMP-MARITAL-STATUS EMP-LIFE-INS-WITHOLD-AMT EMP-NATL-TA | | 1/AN 6/SNUM 3/PS | | (86-86) (87-92) (93-95) | | 16---------------- 18---------------------- 19--------- | | ********************************* TOP OF DATA ********* | | M -3000.00 | | - - - - - - - - - - - - - - - - - - - - - - - - - - - | | S 0 | +-------------------------------------------------------------------------------
Steps:
- Type END in the COMMAND field.
- Press <Enter>. File-AID displays the Browse - Dataset Specification screen (Figure 2-1).
- Type END (again) in the COMMAND field.
- Press <Enter>. File-AID displays the File-AID Primary Option Menu. (Figure 1-2).
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.