Specifying Field_Names after Record Reformatting - 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
Topic type
How Do I
Copyright
2024
First publish date
2010
Last edition
2024-08-27
Last publish date
2024-08-27T08:14:56.318001
If records are reformatted, (for example by using INREC, OUTREC or an E15 or E35 exit), resulting in different field positions, you will need to use field_names that correspond to the new field positions in subsequent control statements. For example, consider the following dictionary statements:
Figure 1. Sample Dictionary Statement

Suppose the following INREC control statement is used:
Figure 2. Sample INREC Control Statement

Only Customer_Name, Customer_Zip and Customer_Acct_Bal will appear in the records after INREC processing. For subsequent control statements, your dictionary names should come from a separate dictionary that defines the new record layout. For example:

Figure 3. Sample Dictionary Statements

If the repositioned fields are given unique names, as shown above, you can concatenate the old and new dictionaries and use both the old and new dictionary_names, as follows:

Figure 4. Example of Dictionary Statements in Control Statements