Page 1 of 1

jcl sort

PostPosted: Fri Jan 13, 2012 1:27 pm
by dharanidhayal
i am trying to segregate duplicate files in a separate output file but xsum in sum fields is not supported in my version of sort
i am getting information in spool like this:
====================================================================================
ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R10 - 13:04 ON SAT JA
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=NONE,XSUM
$
ICE172A E XSUM IS NOT SUPPORTED - USE ICETOOL SELECT IF APPROPRIATE
ICE751I 0 C5-K90014 C6-K90014 C7-BASE C8-K90014 E7-BASE
ICE052I 3 END OF DFSORT
=========================================================================================
anyone please tell me how i can code xsum in my version

Re: jcl sort

PostPosted: Fri Jan 13, 2012 11:49 pm
by Frank Yaeger
DFSORT does NOT support the XSUM parameter but the SELECT operator of DFSORT's ICETOOL can perform the same function (and more). For complete details, see the "Keep dropped duplicate records (XSUM)" Smart DFSORT trick at:

http://www.ibm.com/support/docview.wss? ... g3T7000094

Note that the Programmer Response for the message you received (ICE172A) also tells you how to do it:

http://publibz.boulder.ibm.com/cgi-bin/ ... 1744&CASE=