|
View previous topic :: View next topic
|
| Author |
Message |
rocksolid
New User
Joined: 29 Aug 2006
Posts: 21
Location: India
|
|
|
|
Hi,
I want to eliminate duplicate records in a file and copy to another fie. When I use XSUM option in SORT utility, I got an error message.
Following is my JCL:
//STEP01 EXEC PGM=SORT
//*
//******************************************
//SORTIN DD DSN=TEST.SORT.APPLS.IN,DISP=SHR
//SORTOUT DD DSN=TEST.SORT.APPLS.OUT,
// DISP=(NEW,CATLG,DELETE),
// UNIT=TESTDA,
// SPACE=(TRK,(10,5),RLSE),
// DCB=(RECFM=FB,LRECL=80,BLKSIZE=800)
//SORTXSUM DD DSN=TEST.SORT.XSUMOUT,
// DISP=(NEW,CATLG,DELETE),
// UNIT=TESTDA,
// SPACE=(TRK,(10,5),RLSE),
// DCB=(RECFM=FB,LRECL=80,BLKSIZE=800)
//SYSOUT DD SYSOUT=*
//SYSIN DD DATA,DLM=EN
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=NONE,XSUM
EN
Error message is :POSITIONAL PARAMETER 'XSUM' IS NOT
VALID.
Anybody help please?? |
|
| Back to top |
|
 |
Kevin
Active User
Joined: 25 Aug 2005
Posts: 234
|
|
|
|
First, please post the entire message with the message ID.
Second, as an FYI, XSUM is only available in SYNCSORT. If you are not using SYNCSORT, then you can't use XSUM. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| If you are not using SYNCSORT, then you can't use XSUM. |
If rocksolid used DFSORT, he would have gotten the following message:
ICE172A E XSUM IS NOT SUPPORTED - USE ICETOOL SELECT IF APPROPRIATE
Although DFSORT does not support XSUM, it does provide the same function (and more) with the SELECT operator of DFSORT's ICETOOL. For details, see the "Keep dropped duplicate records (XSUM)" Smart DFSORT Trick at:
www.ibm.com/servers/storage/support/software/sort/mvs/tricks/ |
|
| Back to top |
|
|
rocksolid
New User
Joined: 29 Aug 2006
Posts: 21
Location: India
|
|
|
|
Hi Frank,
Thanks for ur solution. I have gone through the link specified by u and I got the result(By using SELECT in ICETOOL).
But could u please clarify some dobts on this?
1. I am using syncsort only. I found this in my SYSOUT. Then why I am getting error message
E1 8 DSS10066E POSITIONAL PARAMETER 'XSUM' IS NOT
VALID.
2.Is ICETOOL the utility in both DFSORT and SYNCSORT?
Eagerly waiting for your reply. Thanks in Advance. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
1. I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.
2. If you're using DFSORT, PGM=ICETOOL invokes DFSORT's ICETOOL. If you're using Syncsort, PGM=ICETOOL invokes Syncsort's SYNCTOOL. |
|
| Back to top |
|
|
Shanu.sukoor
New User
.jpg)
Joined: 31 Jan 2006
Posts: 32
Location: India
|
|
|
|
in toolcntl of ICETOOL you can use
SELECT FROM(InputDD) TO(outputDD) ON(start ch,lenghth,ch) ALLDUPS DISCARD(NODUPS)
So that you can get all the duplicates in OutputDD and non duplicate records inh NODUPS(any DD name) |
|
| Back to top |
|
|
rocksolid
New User
Joined: 29 Aug 2006
Posts: 21
Location: India
|
|
|
|
Thanks for your clarification Frank.In future, If I have any doubts on DFSORT, I will consult you.
Can anybody explain why I am getting above error message?  |
|
| Back to top |
|
|
|
|
