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