JCL Utilities

GROUP BY and ORDER BY clause in SQL

GROUP BY clause specifies a result table that consists of a grouping of the rows of intermediate result table that…

6 years ago

JOINKEYS joining two files using SORT

JOINKEYS feature joins transactions/records from two different files based on certain keys (i.e. fields with common information). The SORTJNF1 and…

6 years ago

STOPAFT SKIPREC condition in SORT JCL

In SORT JCL, the STOPAFT SKIPREC are two conditions that control the processing of input records. You can use the…

6 years ago

INCLUDE OMIT condition in SORT JCL

You can use the INCLUDE OMIT statement in conjunction with other options to select/omit the number of records to be…

6 years ago

IEFBR14 JCL Utility Quick Reference

The IEFBR14 JCL utility is a dummy utility provided by IBM and its only purpose is to help meet the…

6 years ago