Inserting Blanks and Repositioning Record Fields - 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

Example: The central office of a commercial bank requires that each branch present its masterfile at the end of every month in the format outlined in the figure Desired Input Record Layout. Branch A, however, has formatted its masterfile records as outlined in the figure Non-compliant Input Record Layout.

Figure 1. Desired Input Record Layout

Figure 2. Non-compliant Input Record Layout

To reformat its masterfile records to conform to central office specifications, a bank branch codes the following. Since the records do not require sorting, the MFX copy feature is used.
Figure 3. JCL and Required Control Statements

The figure Post-OUTREC Record Layout shows the effect of OUTREC processing on the output record.

Figure 4. Post-OUTREC Record Layout

Explanation: After the records are copied, OUTREC specifies two types of reformatting: (1) repositioning data fields and (2) inserting blanks between fields. As shown in the figure Post-OUTREC Record Layout, two fields have been repositioned: the Account Type field now begins on the twenty-first byte as opposed to the fifth byte, and the Account Number field begins on the fifth byte rather than on the eighth. Also, blanks have been inserted using the nX entry to specify the number (n) of blanks. Six blanks have been inserted after the Account Number field and a single blank after the Account Type field. Since the Balance field and Interest field are contiguous, they are treated as a single field in this application.