Specifying the FIELDS Parameter for Variable-Length 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
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 the REFORMAT statement only defines p,l fields and/or a ? field, then the output of the join will be a fixed-length record. If a variable-length record format is desired when one or both input files are variable-length, then the first p,l REFORMAT field must be 1,4 (from either SORTJNFn input file) to define the RDW. This p,l specification of 1,4 must reference an Fn that is a variable-length file. The variable portion of the record must then be specified as the last REFORMAT field by coding a position p without a length l. If both files are variable-length, then the variable portion from each of the variable-length input files may be specified once at the end of the REFORMAT statement.
Figure 1. Sample REFORMAT Statement