FIELDS/BUILD Parameter - 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

The FIELDS parameter specifies fields to be included in the output record. (BUILD is an alias for FIELDS.)

There are three main types of fields:

  • Data fields, represented by either p,l[,subparameters] for fixed fields or %pp[,subparameters] for parsed fields

  • Literal fields, to insert run-time date and time constants, character strings, hexadecimal strings and strings of binary zeros

  • Function fields, to insert sequence numbers, add or subtract values from date fields or compute the difference between two date fields

Data field specification is defined in Data Fields (p,l) or (%pp) Subparameters. For the specification of literal fields, see Literal Fields Subparameters. For the specification of function fields, see Function Field Subparameters.