Selecting a Number of Fields from Longer Records - mfx - 3.1

Syncsort™ MFX Programmers Guide

Product type
Software
Portfolio
Integrate
Product family
Syncsort™ Software
Product
Syncsort™ MFX > MFX
Version
3.1
Language
English
Content type
Programmer’s Guide
Product name
Syncsort™ MFX
Title
Syncsort™ MFX Programmers Guide
Copyright
2024
First publish date
2010
Last updated
2024-08-27
Published on
2024-08-27T08:14:56.318001

Example: A school wants to rank the entire student body by grade point index. This application simply requires selecting the two relevant fields out of all the fields in the student records and, then, sorting on the Grade Point Index field. (The Input Record layout is given in the figure Input Record Layout.)

Figure 1. Input Record Layout

To include only the relevant fields and generate the ranked list of students, the following is coded:
Figure 2. JCL and Required Control Statements

The following figure shows the input record after INREC processing.

Figure 3. Form of Post-INREC Record

Explanation: Specifying the two relevant data fields--the Social Security Number (1,9) and the Grade Point Index (74,2)--on the INREC statement provides the sort with necessary data for the application and eliminates the fields that are not relevant to the application. INREC processing thus shortens each record to just a little under 14% of its original size.