Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Getting error while using XSUM in SORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
rocksolid

New User


Joined: 29 Aug 2006
Posts: 21
Location: India

PostPosted: Wed Sep 13, 2006 4:57 pm    Post subject: Getting error while using XSUM in SORT
Reply with quote

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
View user's profile Send private message

Kevin

Active User


Joined: 25 Aug 2005
Posts: 234

PostPosted: Wed Sep 13, 2006 6:19 pm    Post subject: Re: Getting error while using XSUM in SORT
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Sep 13, 2006 8:31 pm    Post subject:
Reply with quote

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:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
Back to top
View user's profile Send private message
rocksolid

New User


Joined: 29 Aug 2006
Posts: 21
Location: India

PostPosted: Thu Sep 14, 2006 12:27 pm    Post subject: Re: Getting error while using XSUM in SORT
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Sep 14, 2006 9:03 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Shanu.sukoor

New User


Joined: 31 Jan 2006
Posts: 32
Location: India

PostPosted: Thu Sep 14, 2006 9:26 pm    Post subject:
Reply with quote

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
View user's profile Send private message
rocksolid

New User


Joined: 29 Aug 2006
Posts: 21
Location: India

PostPosted: Fri Sep 15, 2006 10:07 am    Post subject: Re: Getting error while using XSUM in SORT
Reply with quote

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? icon_sad.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us