To have OMITTED records in file

atik · New User Joined: 29 Jul 2005 Posts: 20

I want to use SORT utility and OMIT some records depending on the condition and have those omitted records in one sequential file for usage in the future. Normally if we omit records, is there any method to have those records in a file. In what way we can do this?

raghavendraun · New User Joined: 29 Apr 2005 Posts: 9

Hi atik,

I think u can achive ur objective in two steps. In First step get only omitted records in one file, In Second step output file with some records omitted.

//STEP10 EXEC PGM=SORT
//SORTIN DD DSN=YOUR INPUT FILE,DISP=SHR
//SORTOUT DD DSN=OUTPUT FILE CONTAINING ONLY OMITTED RECs
//SYSIN DD *
INCLUDE COND=()
/*
//STEP20 EXEC PGM=SORT
//SORTIN DD DSN=YOUR INPUT FILE,DISP=SHR
//SORTOUT DD DSN=YOUR OUTPUT FILE WITH SOME RECs OMITTED
//SYSIN DD *
OMIT COND=()
/*

Is there any other methods, options or any errors in the above JCL guys please suggest.

Thanks,
Raghavendra U N

shivashunmugam Muthu · Posted: Fri Jul 29, 2005 3:47 pm

Add one more sort step with INCLUDE cond....for those OMITed fields..as U cant in same SORT step...

INCLUDE & OMIT are mutually exclusive

raghavendraun · New User Joined: 29 Apr 2005 Posts: 9

Hi shivashunmugam,

As you mentioned is correct, we can get the OMITed records by mentioning INCLUDE in both steps but, if for example u r giving
Condition as 'EQ' in first step just replace 'EQ' as 'NE' in second.
Here is another example Which will give me the same result using only single Step.
If u r using INCLUDE for file 2 as well use reverse logic, which is used for file 1.

Prandip · Posted: Fri Jul 29, 2005 6:01 pm

I think it would be easier to just use the SAVE option to keep all of the omitted records:

Frank Yaeger · Posted: Fri Jul 29, 2005 9:25 pm

For some more information on the INCLUDE, OMIT and SAVE operands of DFSORT's OUTFIL statement, see:

www.ibm.com/servers/storage/support/software/sort/mvs/beyond_sorting/online/srtmboft.html#osb

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

Use [URL] BBCode for External Links