IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

In sorting what is the use of XSUM/SORTXSUM
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
madlui56

New User


Joined: 08 Aug 2006
Posts: 61
Location: Philippines
PostPosted: Wed Jul 18, 2007 12:28 pm
 Reply with quote
In sorting what is the use of XSUM/SORTXSUM?

Thanks.
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
PostPosted: Wed Jul 18, 2007 12:38 pm
 Reply with quote
Louielee,

Quote:
use of XSUM

To capture the duplicate records.

Quote:
SORTXSUM

DD name for capturing the dups.

Please note XSUM is supported only by SYNCSORT.
Back to top
View user's profile Send private message
madlui56

New User


Joined: 08 Aug 2006
Posts: 61
Location: Philippines
PostPosted: Wed Jul 18, 2007 12:52 pm
 Reply with quote
This means the output dsn for sortxsum dd dsn
is with duplicates.right?

So this is in reciprocate with sum fields=none which is to eliminate duplicates. am i right?

Thanks.
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
PostPosted: Wed Jul 18, 2007 2:06 pm
 Reply with quote
Louielee,

Quote:
This means the output dsn for sortxsum dd dsn
is with duplicates.right?

So this is in reciprocate with sum fields=none which is to eliminate duplicates. am i right?


Yes.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
PostPosted: Wed Jul 18, 2007 8:04 pm
 Reply with quote
Quote:
Please note XSUM is supported only by SYNCSORT.


DFSORT's ICETOOL can do the equivalent function and more. See the "Keep dropped duplicate records (XSUM)" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 

Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Automation need help in sorting the data DFSORT/ICETOOL 38
No new posts Sorting a record spanned over multipl... DFSORT/ICETOOL 13
No new posts Creating additional seqnum/Literal wh... DFSORT/ICETOOL 4
No new posts ICETOOL Sorting and Discarding DUPS SYNCSORT 11
No new posts Sorting on text - but in non-alphabet... SYNCSORT 5
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us