jcl sort



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

jcl sort

Postby dharanidhayal » Fri Jan 13, 2012 1:27 pm

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
dharanidhayal
 
Posts: 1
Joined: Fri Jan 06, 2012 11:38 am
Has thanked: 0 time
Been thanked: 0 time

Re: jcl sort

 

Re: jcl sort

Postby Frank Yaeger » Fri Jan 13, 2012 11:49 pm

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=
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post