SPLITBY Parameter (Optional) - 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

The SPLITBY=n parameter writes groups of records in rotation among multiple output data sets and distributes multiple records at a time among the OUTFIL data sets. n specifies the number of records to split by. The minimum value for n is 1.

The SPLITBY parameter is similar to SPLIT, but SPLITBY can be used to rotate by a specified number of records rather than by one record, for example, records 1-10 to the first OUTFIL data set, records 11-20 to the second OUTFIL data set, and so on.

For example, if SPLITBY=10 is specified for an OUTFIL group with three data sets:
  • The first OUTFIL data set in the group receives records 1-10, 31-40, and so on.

  • The second OUTFIL data set in the group receives records 11-20, 41-50, and so on.

  • The third OUTFIL data set in the group receives records 21-30, 51-60, and so on.

SPLIT, SPLITBY=n and SPLIT1R=n are mutually exclusive. SPLITBY=1 is equivalent to SPLIT.

Note that the SPLITBY parameter cannot be used with any report writing (SortWriter) functions. Specifically, report writing parameters (HEADERn, TRAILERn, SECTIONS, LINES, NODETAIL, IFTRAIL) cannot be specified on the OUTFIL control statement that defines the output group.