JCL- INCLUDE And OMIT With Examples

15+Rapidly+Growing+IT+Jobs
15+Rapidly+Growing+IT+Jobs

The best way to improve the efficiency of a sort or a merge is to reduce the number of records that are sorted or merged. To do that, you can use the INCLUDE and OMIT statements to identify the records that should be included or omitted from the sort or merge.

The syntax of the INCLUDE and OMIT statements

INCLUDE COND=(field,comparison,{field }, [ {AND}, ]…)
{constant} {OR }
OMIT COND=(field,comparison,{field }, [ {AND}, ]…)
{constant} {OR }

Examples:

INCLUDE COND=(1,1,CH,EQ,C’A’)Include only the records that have an A in byte 1.

OMIT COND=(1,1,CH,EQ,C’A’)Omit the records that have an A in byte 1.

INCLUDE COND=(72,5,PD,GE,1000)Include only the records with a packed-decimal value in bytes 72-76 that’s greater than or equal to 1000.

INCLUDE COND=(72,5,PD,GE,1000,OR, 72,5,PD,LT,10)Include only the records with a packed-decimal value in bytes 72-76 that’s greater than or equal to 1000 or less than 10.

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.

Comments are closed.