Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SORT Utility: What does that "sum fields = none" m

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

New User


Joined: 22 Dec 2003
Posts: 4

PostPosted: Tue Dec 23, 2003 12:10 pm    Post subject: SORT Utility: What does that "sum fields = none" m
Reply with quote

hi,
( while using SORT utility )
If we use sum fields = none, then it will remove duplicates, I want to know what does that "sum fields = none" mean. ?, and one more question is that if i have duplicate records in 2 files, then which record is going to be chosen in the sort file. The first one or the last one ?

please
Giridhar varma N
Back to top
View user's profile Send private message

mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Tue Dec 23, 2003 12:37 pm    Post subject:
Reply with quote

Hello girivarma77,

1) Look at the following url for more information:
http://publibz.boulder.ibm.com/epubs/pdf/iceca109.pdf
Page 336

2) It will depend on the Sorting condition.

Hope this helps

Regards

Mayuresh Tendulkar
Back to top
View user's profile Send private message
girivarma77

New User


Joined: 22 Dec 2003
Posts: 4

PostPosted: Tue Jan 06, 2004 11:36 am    Post subject: thank you !!
Reply with quote

thank you mtendulkar icon_razz.gif
Back to top
View user's profile Send private message
srinut123

New User


Joined: 11 Oct 2005
Posts: 62
Location: India

PostPosted: Thu Feb 01, 2007 6:14 pm    Post subject:
Reply with quote

Come on Giridhar
Its pretty simple to understand..
A record becomes duplicate only when a similar record has been read.. that means the first record is already fetched.. and the comparision happening with the second record.. so the second record will be elimated.

cheers
Srinivas T, Avanthi College
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 Feb 01, 2007 10:46 pm    Post subject:
Reply with quote

Srinivas T wrote

Quote:
Come on Giridhar
Its pretty simple to understand..
A record becomes duplicate only when a similar record has been read.. that means the first record is already fetched.. and the comparision happening with the second record.. so the second record will be elimated.


So "simple" that YOU don't understand it.

Actually, it depends on whether the EQUALS or NOEQUALS option is in effect. If EQUALS is in effect, the first record will be kept. If NOEQUALS is in effect, either record can be kept. If you want to ensure that the first record is kept, you can specify:

Code:

//SYSIN DD *
   OPTION EQUALS
/*


Giridhar varma N wrote:

Quote:
If we use sum fields = none, then it will remove duplicates, what does that "sum fields = none" mean


It's not clear what you're asking. You already know what SUM FIELDS=NONE does, so you obviously aren't asking that. Do you want to know why the FIELDS=NONE keyword was chosen? The reason is to distingusih it from SUM FIELDS=(p,m,f,...) which actually specifies fields to be summed when the records are equal. Both forms eliminate duplicate records but SUM FIELDS=(p,m,f,...) also sums fields whereas SUM FIELDS=NONE doesn't.

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
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 Subtract the ZD fields to provide neg... Balaryan DFSORT/ICETOOL 4 Wed Oct 11, 2017 10:51 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us