JCL sort example using dfsort (Omit parameter).

Free Tips, Tutorials, and Examples

Submit Your Own Tip     View All Tips!


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.
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 a tip that you think should be listed, feel free to post it below. Please make it detailed as I review all posts and try to cleanup spelling errors and remove spam.

Submit Your Own Tip? Ask Questions?:

Post It Here (Please explain in detail)

Other Topics:

View other tips
View whats running in your tasklist