Formatted criteria
The following figure enables you to specify field criteria for your compare. File-AID displays the Formatted Criteria screen only when the OLD and NEW files use the same record layout.
In order to compare the data from the new and old files, you must have a Compare Field specified. Only specifying the SYNC Key field, will only compare the SYNC key field and will not compare the rest of data in the file.
Compare - Formatted Criteria
COMMAND ===> SCROLL ===> PAGE
OLD FILE - USERID9.FASAMP.INVFILE ---------------------------------------------
Cmd Field Name Format Status Display
INVENTORY-RECORD GRP 513
_ INV-PART-NO C 15 COMPARISON FIELD
_ INV-DESCRIPTION C 40 COMPARISON FIELD
_ INV-UNIT-OF-MEASURE C 2 COMPARISON FIELD
_ INV-UNIT-PRICE PS 5 2 COMPARISON FIELD
INV-STOCK-INFO OCCURS 2 TIMES
INV-STOCK-INFO(1) GRP 18
_ INV-WAREHOUSE(1) C 3 COMPARISON FIELD
_ INV-STATUS(1) C 6 COMPARISON FIELD
INV-QTY-DATE(1) GRP 9
_ INV-QTY-ON-HAND(1) PS 5 COMPARISON FIELD
_ INV-LAST-ORDER-DATE(1) C 6 COMPARISON FIELD
INV-BO-QTY-DATE(1) REDEFINE INV-QTY-DATE
INV-BO-QTY-DATE(1) GRP 9
_ INV-QTY-BACKORDERED(1) PS 5 COMPARISON FIELD
_ INV-BACKORDER-DATE(1) C 6 COMPARISON FIELD
INV-STOCK-INFO(2) GRP 18
_ INV-WAREHOUSE(2) C 3 COMPARISON FIELD
Cmd: S = Sync/Key, T = Tolerance/Text, P = Print, C = Compare, R = Reset
Field Descriptions
Cmd
The following commands are valid in this field. T, C, and P are not valid for a Sync/Key field.
S
Use this field as a sync/key and display Sorted Sync/Key Specification pop-up if sorted Compare.
T
(Tolerance) For Binary, packed, zoned decimal fields: Display Tolerance Value/Percentage Specification pop-up.
(Text) For Character fields only: Text, select field for convert to uppercase. Use this when you want to compare without regard to case.
P
Set field to print only (shows on report but does not compare field).
C
Select field for comparison (default).
R
Resets the Status Display field to blanks (exclude from compare).
Field Name
Name of field as specified in the record layout.
Format
Field format as specified in the record layout.
Status Display
Displays the Compare options set for this field.
Primary Commands
Use the following commands to locate a field name within the layout in the Compare - Formatted Criteria and Compare - Associate Field Names screens.
FIND (F)
Enter a string of characters following the command to search the layout, for example:
LOCATE (L)
Enter a string of characters following the command to search the layout, for example:
REPEAT (R)
Press Enter after a successful FIND/LOCATE to go to the next occurrence of the specified string of characters in the layout (Compare - Formatted Criteria) or new layout (Compare - Associate Field Names). The REPEAT command is automatically suggested on the command line after a successful FIND or LOCATE to return the next occurrence of the last term in the layout. REPEAT only works in the down direction.
Associate Field Names
The following figure enables you to associate field names between the old and new files for comparison. File-AID displays this screen only when the OLD and NEW files use different record layouts. The field associations and commands are specified in the lower half of the panel.
Compare - Associate Field Names
Primary Commands
PAIR
The PAIR command scrolls the top and bottom portions of the panel to the same associated field. Once fields have been associated, type the PAIR primary command in the COMMAND line and position the cursor on the associated field you want to locate. When pressing ENTER then both the top and bottom portions of the panel position to the field where the cursor is positioned.
Field Descriptions
OLD FILE/NEW FILE
Displays the file data set and member name.
Num
Number that corresponds to the OLD FILE or NEW FILE field name. Maximum field number is 32767.
Field Name
Field name from the record layout.
Format
Field format from the record layout.
Status Display
Displays the Compare options set for this field.
OLD /num or /field-name
Enter a slash followed by the number or field-name to associate the OLD FILE field with the NEW FILE field.
Cmd
Enter one of the following valid commands:
S
Use this field as a sync/key and display Sorted Sync/Key Specification pop-up if sorted compare.
T
(Tolerance) For Binary, packed, zoned decimal fields: Display Tolerance Value/Percentage Specification pop-up.
(Text) For Character fields only: Text, select field for convert to uppercase. Use this when you want to compare without regard to case.
P
Select field for print only (not comparison).
C
Select field for comparison.
R
Disassociates the two fields and resets the Status Display field to blanks.
Select XREFs
The following figure is displayed when the OLD and NEW files use the same XREF and layout. You must select at least one XREF member to proceed. Once you have made your selection and pressed Enter, File-AID displays the Compare - Formatted Criteria screen.
Compare - Select XREFs
COMMAND ===> SCROLL ===> PAGE
Select XREFs for compare:
Process all: _ (S=select; U=unselect)
XREF - USERID9.FASAMP.XREF(ORDRFILE)
S Member Beginning Data-Name Description Type Status
- ---------- ------------------------------ --------------- ------- --------
ORDERPO ORDER-LINE-DATA-PO PO LINE DATA BASE SELECTED
ORDERSC ORDER-LINE-DATA-SC SC LINE DATA___ BASE
ORDERWO OUTSIDE-VENDOR-WORK-ORDER WORK ORDER - OV BASE
ORDERWO INTERNAL-WORK-ORDER WORK ORDER - IN DEFAULT
******************************* BOTTOM OF DATA ********************************
Field Descriptions
Process All
S
Selects all BASE and DEFAULT members for processing.
U
Unselects all members.
S
XREF member Selection field. Valid entries are S (Select) or U (Unselect). You can only select BASE and DEFAULT members.
Member
Record layout member name.
Beginning Data-Name
Starting dataname of the record layout.
Description
Short description of the record layout entered by user when XREF was created.
Type
Type of layout (BASE, DEFAULT, or SEGMENT).
Status
Displays SELECTED when the XREF member is selected for comparison. Blank indicates the layout is not selected.
Associate XREFs
The following table enables you to associate XREF members between the OLD and NEW files you are comparing. File-AID displays this screen when the OLD and NEW files have different XREFs and/or different record layouts.
Each data file record is classified into a record type category based on certain field values within the record. In File-AID, these field or data values and their record layouts are associated when the XREF is defined. See Record-Layout-Cross-Reference-function.
Compare - Associate XREFs
COMMAND ===> SCROLL ===> PAGE
Specify NEW XREF number next to the OLD XREF you wish to compare to:
*******************************************************************************
OLD File XREF - USERID9.FASAMP.XREF(ORDRFILE)
Num Member Beginning Data-Name Description Type Status
____ ORDERPO ORDER-LINE-DATA-PO PO LINE DATA BASE
____ ORDERSC ORDER-LINE-DATA-SC SC LINE DATA___ BASE
____ ORDERWO OUTSIDE-VENDOR-WORK-ORDER WORK ORDER - OV BASE
____ ORDERWO INTERNAL-WORK-ORDER WORK ORDER - IN DEFAULT
******************************* BOTTOM OF DATA ********************************
*******************************************************************************
NEW File XREF - USERID9.FASAMP.XREF(ORDRFILE)
Num Member Beginning Data-Name Description Type Status
1 ORDERPO ORDER-LINE-DATA-PO PO LINE DATA BASE
2 ORDERSC ORDER-LINE-DATA-SC SC LINE DATA___ BASE
3 ORDERWO OUTSIDE-VENDOR-WORK-ORDER WORK ORDER - OV BASE
4 ORDERWO INTERNAL-WORK-ORDER WORK ORDER - IN DEFAULT
******************************* BOTTOM OF DATA ********************************
*******************************************************************************
Specify NEW XREF Number, S to alter/redisplay associated pair or U to Unselect
Field Descriptions
OLD File XREF
Specifies the OLD file data set and member name.
Num
Enter the number to correspond the OLD XREF member and Beginning Data-Name with the NEW XREF member and Beginning Data-Name. You may enter Multiple NUMs at a time. Or, you may specify:
S
Alter or redisplay the associated pair.
U
Unselects the associated pair and clears the fields you set for comparison.
Member
Record layout member name.
Beginning Data-Name
Starting dataname of the record layout.
Description
Short description of the record layout entered by user when XREF was created.
Type
Type of layout (BASE, DEFAULT, or SEGMENT).
Status
Displays NEW=nnnn (where nnnn indicates the corresponding NEW file layout) when the layout is selected for comparison. Blank indicates the layout is not selected.
NEW File XREF
Specifies the NEW file data set and member name.
Num
Entry number of the NEW XREF member and Beginning Data-Name.
Member
Record layout member name.
Beginning Data-Name
Starting dataname of the record layout.
Description
Short description of the record layout entered by user when XREF was created.
Type
Type of layout (BASE, DEFAULT, or SEGMENT).
Status
Displays OLD=nnnn (where nnnn indicates the corresponding OLD file layout) when the layout is selected for comparison. Blank indicates the layout is not selected.
Sync/Key Pop-up
The following figure enables you to specify the key order and direction for the selected field (or position). This screen is displayed when you enter "S" in the Cmd field on the Formatted Criteria screen.
A synchronization key is a key field, which you define within File-AID, to synchronize the input records of either sorted or non-sorted files for comparison. Sorted key screens (formatted and unformatted) are used with files that are keyed or pre-sorted.
Sorted Sync/Key Specification
Field Descriptions
OLD field name/NEW field name
Name of field selected for Sync/Key specification.
Specify field order number
Specify a number from 1 to 256 which indicates this key field’s place in the hierarchy of key fields.
Specify file sequence direction
Specify the field sequence direction for this key field.
A
Ascending
D
Descending
After you have completed the fields on this screen, use END (PF3) to return to the Formatted Criteria screen. Use CANCEL to return to the Formatted Criteria screen without specifying the sorted sync/key information.
Tolerance Pop-up
The following figure enables you to specify a tolerance or percentage amount for a numeric field that File-AID uses to determine "close-enough" matches for your compare. When you have completed this window, press PF3 to proceed. Enter CANCEL to return to the Associate Field Names screen without entering a tolerance value.
Tolerance Value/Percentage Specification
Field Descriptions
OLD field name/NEW field name
Field name(s) as specified in record layout for which you are specifying a tolerance value/percentage.
Format (OLD/NEW)
Format(s) as specified in record layout(s).
Specify tolerance value/percentage
Specify a numeric tolerance value or a tolerance percentage for File-AID to use to determine "close-enough" matches for your compare. The tolerance value is limited to the most precise field (the number of integers). To specify a percentage value precede it with a percentage sign (%) or else it is interpreted as a tolerance value. Valid tolerance percentages are %000.001 through %999.999.
Related topics