JCL sort example using dfsort (Omit parameter).



Free Tips, Tutorials, and Examples














Submit Your Own Tip     View All Tips!

Detailed Description:

JCL sort can allow you to easily omit or remove rows from your output data. You simply just call the sort job, pass it the files, and tell it the parms on what type of sorting you want and also what data you would like to omit from the output. The omit parameter is optional, but if you include the omit then the data will be removed from your output if it matches your criteria. For example, if you want your JCL to skip some input data, you use the omit parm just as it shows below.
//SYSIN DD *
SORT FIELDS=COPY
OMIT COND=((10,2,CH,EQ,C'IA'),AND,(67,2,CH,NE,C'IA')) (This means you will bypass rows where position 10, for 2 bytes, equals IA, and also position 67 for 2 bytes does not equal IA). By using OMIT, you are telling your jcl code that if these 2 conditions are true, then the data is bypassed so your output data will "not" include these rows. There is no exclude parm, omit is what you use. This can handle almost any condition for bypassing specifc rows from your output result file.


This site provides a list of interesting tips and tricks. Although it is mostly computer and tech related tips, there are also tips and tricks related to various other helpful topics like how much things cost or how much you paid. If you have an important tip that you think should be listed, feel free to post it below. Please make it detailed, as the biggest mistake people make is not explaining well enough or including enough details. I review all posts and try to correct spelling errors and remove spam.

Submit Tip or Ask Question:

Post It Here (Explain in detail)

View Other Databases:

View All Tips and Tricks
Spyware and System Task Database