Supported SORT control statements and parameters - Connect_ETL - 9.13

Connect ETL Mainframe SORT Compatibility Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL Mainframe SORT Compatibility Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-11
ft:lastPublication
2023-09-11T19:04:58.310636
Control Statement Parameters Comments
ALTSEQ
END
INCLUDE

where

See notes below for the supported field positions and formats.

Bit level comparisons (e.g. with operators BO, BM, BZ, etc.) are not supported.

INREC

where

See notes below for the supported field positions and formats.
MERGE
 

 

See notes below for the supported field positions and formats.
OMIT

where each comparison c can be specified as documented in INCLUDE.

Same limitations as INCLUDE above.
OPTION See the table of Supported PARAM Options below.
OUTFIL

where the INCLUDE, OMIT, and OUTREC parameters can be specified as documented in the INCLUDE, OMIT, and OUTREC control statements.

Each field in the SECTIONS parameter can be specified as follows:

where subparameter can be:

Each field in a HEADER can be specified as follows:

Each field in a TRAILER can be specified as follows:

where

The INCLUDE, OMIT, and OUTREC sub-parameters have the same limitations as their control statement equivalents.
OUTREC

where each field can be specified as documented in INREC.

Same limitations as INREC above.
RECORD  
SORT
 

 

See notes below for the supported field positions and formats.

When FILSZ=n or SIZE=n is specified, Connect ETL does not terminate if the number of records processed is not exactly n.

SUM
The supported field formats are: BI, FI, FL, PD, ZD.
Note: Fields that do not start or end at a byte boundary are not supported.

The supported formats are: AC, AQ, ASL, AST, BI, CH, CLO/OL, CSF/FS, CSL/LS, CST/TS, CTO/OT, FI, PD, ZD. Formats that are not listed such as FD, PD0, SFF, UFF, SS (substring), date formats (e.g. Y2B, Y2C, etc.) are not supported.