| 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. |
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.