FIELDS Parameter (Required) - 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
ContentType
Programmer’s Guide
Product name
Syncsort™ MFX
Title
Syncsort™ MFX Programmers Guide
Topic type
How Do I
Copyright
2024
First publish date
2010
ft:lastEdition
2024-08-27
ft:lastPublication
2024-08-27T08:14:56.318001

The FIELDS parameter defines the numeric fields to be summed when the control fields of two or more records are equal. Specify FIELDS=NONE to reduce the sorted data to one record per sort key without summing any numeric fields. 

Each field specified in the FIELDS parameter is identified by its position p, length l and format f.

p

The position value indicates the first byte of the field relative to the beginning of the input record after INREC and/or E15 processing, if specified, have completed. The field must begin on a byte boundary.

l

The length value indicates the length of the field. The length must be an integer number of bytes. Refer to Permissible Formats and Lengths for SUM Fields for the permissible lengths.

f

The format value indicates the data format. Permissible Formats and Lengths for SUM Fields lists the valid data formats for SUM fields. If all the summed fields have the same format, you can specify the format value once by using the FORMAT=f subparameter. If both the individual f values and the FORMAT subparameter are specified, the individual f values will be used for fields where they are specified.

Table 1. Permissible Formats and Lengths for SUM Fields

FORMAT CODE

PERMISSIBLE LENGTH

BI

2, 4, or 8 bytes

FD*

4, 8, or 16 bytes

FI

2, 4, or 8 bytes

FL

4, 8, or 16 bytes

PD

1 to 16 bytes

ZD

1 to 31 bytes

Note: *A non-finite number in the data will cause a WER497A error.