SAMPLE 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-08-27
Published on
2024-08-27T08:14:56.318001

The SAMPLE=n and SAMPLE=(n,m) parameters allow the selection of a sample of records from an OUTFIL group. A specific interval and number of records in that interval can be specified. The sample process will take place within the range of records specified by STARTREC or ENDREC if they are specified. SAMPLE=n and SAMPLE=(n,m) are mutually exclusive.

The sample consists of the first m records in every nthe interval. n specifies the interval size. The minimum value for n is 2 (sample every other record).

m specifies the number of records to be processed in each interval. The minimum value for m is 1 (process the first record in each interval). If m is not specified, 1 is used for m. If m is specified, it must be less than n.