Joined: 26 Apr 2004 Posts: 4650 Location: Raleigh, NC, USA
If I recall, SUM FIELDS=NONE,XSUM works for the SYNCSORT utility exactly as you were told. SUM FIELDS=NONE eliminates the duplicate records to the SORTOUT DD, and the XSUM command stores the excluded records into a separate DD (SORTXSUM, I think).
The above will eliminate duplicates from the SORTIN dataset and those will be placed in SORTXSUM dataset. SORTOUT dataset contains only Unique records. Both SORTOUT and SORTXSUM datasets will be sorted out.
Along with SUM FIELDS=NONE,XSUM control statement there should be SORT FIELDS=some condition control statement. Otherwise ur JCL will lead to JCL error .
Can anyone explain me why sort statement should be present along with SUM FIELDS=NONE,XSUM ?
I worked on this using my JCL. So i can say that DFSORT support that control statement.
I repeat. DFSORT does NOT support XSUM! If XSUM did not result in an ICE172A error message, then you are using Syncsort (WERxxxs messages), not DFSORT. As a DFSORT developer, I think I know a little better than you which parameters my product supports.
DFSORT does support the same function (and more) with ICETOOL using different syntax.
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: