Sample REFORMAT Control Statement - mfx - 3.1

Syncsort™ MFX Programmers Guide

Product type
Software
Portfolio
Integrate
Product family
Syncsort™ software
Product
Syncsort™ MFX > MFX
Version
3.1
ft:locale
en-US
Product name
Syncsort™ MFX
ft:title
Syncsort™ MFX Programmers Guide
Copyright
2024
First publish date
2010
ft:lastEdition
2025-02-20
ft:lastPublication
2025-02-20T09:24:15.574000
Figure 1. Sample JOIN and REFORMAT Statements

In this example, if a record is found in SORTJNF1 that does not match a record in SORTJNF2, the unpaired record will be included in the join output and would look as follows:

Table 1. Record Format after REFORMAT Processing

Position

Value

1-10

Contents of the SORTJNF1 record positions 10 through 19.

11-15

Filled with 0s since SORTJNF2 does not participate in building this record.

For more examples, see Joining Records from Multiple Files.