Reformatting data sets with multiple record types

The following figure lists each layout defined in the specified XREF. It is displayed when the data file you are reformatting contains more than one type of record and each record type requires a different record layout (Record layout usage = X). XREF layouts are compiled as needed.

Use this screen to specify which record type to reformat. All other record types are not selected for reformatting. Use the Copy unselected records field on the Reformat Execution - Online screen (Reformat Execution - Online Screen) to specify whether to copy unselected records.

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.

You must select a record layout with a status of BASE. File-AID does not allow you to select a record type with a status of DEFAULT and does not support the reformatting of segmented records.

Display XREF Screen

File-AID --- Display XREF - ORDRFILE ------------------------ ROW 1 TO 4 OF 4
COMMAND ===>                                                  SCROLL ===> CSR
Member list description ===> XREF FOR ORDRFILE

     Long    ===> RECORD TYPE FIELD IS ORDER-TYPE. FOR ORDERWO THE FIELD________
Description ===> CONTRACT INDICATOR IS USED TO SELECT FROM TWO TYPES OF LAYOUT_

Cmd   Member   Beginning Data-Name              Description         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
************************** END OF SELECTION CRITERIA **************************

Field Descriptions

Cmd

Use the S (Select) line command to specify the record layout you want to use. You must select a record layout with a status of BASE.

The fields associated with layout selection are automatically set and locked and flagged with a criteria value of RECORD TYPE FIELD.

Member

Name of the record layout member.

Beginning Data-Name

Displays the starting dataname of the record layout.

Description

Short Description of the record layout entered by user when the XREF is created.

Status

Usage status of the layout (BASE, DEFAULT, or SEGMENT) as defined in the XREF.

After you select a layout on the Display XREF screen, press Enter to continue with the Reformat function.

Use the END (PF3) or CANCEL command to terminate the function and return to the Reformat Record Layouts screen.

Use the RETURN command (PF4) to return to the File-AID Primary Option Menu.

Primary Commands

The following primary commands are valid on the Display XREF screen:

CANCEL

Terminates the reformat processing.

DOWN

Scrolls toward the end of a record layout.

END