GROUP BY clause specifies a result table that consists of a grouping of the rows of intermediate result table that is the result of the previous clause. The GROUP BY clause allows you to find the characteristics of groups of rows rather than individual rows. ORDER BY clause specifies the particular order in which you […]
GROUP BY and ORDER BY clause in SQL Read More »
JOINKEYS feature joins transactions/records from two different files based on certain keys (i.e. fields with common information). The SORTJNF1 and SORTJNF2 DD statements were used to specify these files. Each JOINKEYS statement must specify the DDNAME of the file it applies to and the starting position, length, and sequence of the keys in that file. You
JOINKEYS joining two files using SORT Read More »
In SORT JCL, the STOPAFT SKIPREC are two conditions that control the processing of input records. You can use the STOPAFT SKIPREC options to reduce the number of records to be processed, which can reduce processor and data transfer time. STOPAFT and SKIPREC are optional parameters and can be used together or separately in a
STOPAFT SKIPREC condition in SORT JCL Read More »
You can use the INCLUDE OMIT statement in conjunction with other options to select/omit the number of records to be processed, which can reduce processor and data transfer time. The INCLUDE and OMIT statements allow you to select records by comparing fields with constants or other fields. Only one INCLUDE/OMIT control statement can be specified
INCLUDE OMIT condition in SORT JCL Read More »
The IEFBR14 JCL utility is a dummy utility provided by IBM and its only purpose is to help meet the requirements that a job must have at least one EXEC statement. The real purpose is to allow the disposition of the DD statement to occur. IEFBR14 doesn’t return any other return codes except ZERO or
IEFBR14 JCL Utility Quick Reference Read More »
