Free Tips, Tutorials, and Examples | |
|
Main Page Submit Question or Tip
View List 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.
Submit Tip or Ask Question:
View Other Databases: | |