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

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

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-7.

Compare - Associate XREFs

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.