Valid Formats for Sort Control 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
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 following chart lists the valid formats for sort control fields.

Table 1. Format Code Chart

Code

Data Format

Field Length (bytes)

AC

EBCDIC characters are translated to their ASCII equivalents before sorting.

1 to 4091†

AQ

Character. Records are sorted according to an alternate sequence specified either in the ALTSEQ control statement or as an installation default.

1 to 4091†

ASF ASCII signed free format. Decimal digits (0-9) are extracted from right to left to form a positive or negative number value. A character of '–' or ')' found within the field will cause the value to be treated as a negative number. All other non-decimal digit values other than 0-9, '–' or ')' in the field are ignored. 1 to 44

ASL

Leading separate sign. An ASCII + or - precedes numeric field. One digit per byte.

2 to 256

AST 

Trailing separate sign. An ASCII + or - trails numeric field. One digit per byte.

2 to 256

AUF ASCII Unsigned free format. Decimal digits (0-9) are extracted from right to left to form a positive number value. All non-decimal digit values in the field are ignored. Any combination of characters is valid, but characters other than 0-9 are ignored. 1 to 44

BI 

Binary. Unsigned.

1 bit to 4092*

CH

Character. Unsigned.

1 to 4092*

CLO

OL 

Leading overpunch sign. Hexadecimal F,C,E, or A in the first 4 bits of your field indicates a positive number. Hexadecimal D or B in the first 4 bits indicates a negative number. One digit per byte. CMP=CLC is forced.

1 to 256

CSF

FS

Floating sign format. An optional leading sign may be specified immediately to the left of the digits. If the sign is a -, the number is treated as negative. For other characters, the number is treated as positive. Characters to the left of the sign are ignored.

1 to 32

CSL

LS

Leading separate sign. An EBCDIC + or - precedes numeric field. One digit per byte. CMP=CLC is forced.

2 to 256

CST

TS

Trailing separate sign. An EBCDIC + or - follows numeric field. One digit per byte. CMP=CLC is forced.

2 to 256

FD

Decimal floating point. Signed. An SNaN or QNaN value is invalid and will cause a WER497A error.

4, 8, or 16

FI

Fixed point. Signed. (Equivalent to Signed Binary.)

1 to 256

FL

Floating point. Normalized. Signed.

2 to 256

PD

Packed decimal. Signed.

1 to 256

PD0 

Packed decimal. 2-8-byte packed decimal data with the first digit and trailing sign ignored. The remaining bytes are treated as packed decimal digits. Typically PD0 is used with century window processing and Y2P format; Y2P processes the year, while PD0 processes month and day.

2-8

SFF

Signed free format. Decimal digits (0-9) are extracted from right to left to form a number value. A character of – or ) found within the field will cause the value to be treated as a negative number. All other non-decimal digit values in the field are ignored.

1 to 44

UFF

Unsigned free format. Decimal digits (0-9) are extracted from right to left to form a number value. All non-decimal digit values in the field are ignored.

1 to 44

UTF8 Unicode data format. Field contains Unicode UTF-n format characters. where n can be 8. 1 to 450
UTF16 Unicode data format. Field contains Unicode UTF-n format characters. where n can be 16. 1 to 450
UTF32 Unicode data format. Field contains Unicode UTF-n format characters. where n can be 32. 1 to 450

Y2B 

Binary. 2-digit, 1-byte binary year data treated as a 4-digit year by CENTWIN (century window) processing.

1

Y2C 

Character. 2-digit character year data treated as a 4-digit year by CENTWIN (century window) processing. Processing is identical to Y2Z fields.

2

Y2D 

Packed decimal. 2-digit, 1-byte packed decimal year data treated as a 4-digit year by CENTWIN (century window) processing.

1

Y2P 

Packed decimal. 2-digit, 2-byte packed decimal year data. Of the four packed digits contained in the 2 bytes, the first digit and trailing sign are ignored; the two inner digits are treated as a 4-digit year by CENTWIN processing.

2

Y2S 

Character or zoned decimal. 2-digit, 2-byte valid numeric data treated as a 4-digit year by CENTWIN (century window) processing, as for Y2C and Y2Z. However, certain data are not treated as year data. Data with binary zeros (X'00') or a blank (X'40') in the first byte will be collated before valid numeric year data for ascending order (after year data for descending order). Data with all binary ones (X'FF') in the first byte will be collated after valid numeric year data for ascending order (before year data for descending order). Zones are ignored, as for Y2C and Y2Z, except for data where the first byte begins with X'00', X'40' or X'FF'.

2

Y2T

Y2U

Y2V

Y2W

Y2X

Y2Y

Full-date, character, binary, or packed decimal formats. Full-date data formats can be used to sort or merge a variety of date fields. They can process dates ending or starting with year digits (x...xyy or yyx...x). They can also process non-date data commonly used with dates. For details, see the table Full-Date Formats.

2-6

Y2Z 

Zoned decimal. 2-digit, 2-byte zoned decimal year data treated as a 4-digit year by CENTWIN (century window) processing. The zones are ignored. Pro­cessing is identical to Y2C fields.

2

ZD

CTO

OT

Zoned decimal. Trailing overpunch in the first 4 bits of the rightmost byte gives the sign. Hexadecimal F,C,E, or A indicates a positive number. Hexa­decimal D or B indicates a negative number. One digit per byte. CTO forces CMP=CLC. 

1 to 256

Note:

* 4084 for variable-length records. 

† 2043 for variable-length records.

 
  • UTF8, UTF16, and UTF32 data collating sequence is based on effective COLLKEY value.
  • The default COLLKEY value can be overridden by COLLKEY= Option or COLLKEY= PARM.
  • Specifying a Unicode field is incompatible with the following features:
    • SUM
    • INREC
    • OUTREC
    • E61 EXIT
    • LOCALE

For information on the year data formats (Y2B, Y2C, Y2D, Y2P, Y2S, and Y2Z) plus the related data format PD0 and the full-date formats, see CENTWIN Parameter (Optional), Converting Year Data with Century Window Processing on INREC, OUTREC, or OUTFIL OUTREC, and Specifying Field-to-Field Standard Comparisons for Year Fields.