Selecting Relevant Fields from the Input 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-11-06
Published on
2024-11-06T17:38:26.716054

Input records often contain some information that is not relevant to a specific application. For example, records in a personnel masterfile might, in addition to addresses, include salaries and other confidential information that is not required for preparing a mailing list.

MFX’s Data Utility features allow you to select only those record fields that contain necessary data and to eliminate those that do not. More important, MFX enables you to do this editing before the records are sorted. As a result, the sort has fewer bytes to handle and processing is more efficient.

For complete syntax of the INREC control statement, see INREC Control Statement.

Figure 1. Basic INREC Statement Format

p,l

Specify the beginning position and length in bytes of the input record’s relevant fields. When specifying contiguous fields, or fields that directly follow one another, you can simply indicate the starting position of the first field together with the combined length of the fields that are contiguous.