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
 
Syncsort - Sort help to remove duplicates

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

New User


Joined: 01 May 2010
Posts: 7
Location: DE

PostPosted: Fri Sep 10, 2010 7:54 pm    Post subject: Syncsort - Sort help to remove duplicates
Reply with quote

All,

IF we use sum fields = None to remove duplicates, does it remove the second duplicate record always?

1000010010000211
1000010010000212
1000010010000213

If we sort the above data based on first 13 bytes with sum field=none wt is the o/p ? is it 1000010010000211?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Sep 10, 2010 8:53 pm    Post subject:
Reply with quote

Hello,

If you specify EQUALS, the records will remain in the original order and the 2nd thru nth record will be duplicates.

Without EQUALS, the results can be unpredictable.
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: Fri Sep 10, 2010 10:38 pm    Post subject:
Reply with quote

Quote:
If we sort the above data based on first 13 bytes with sum field=none wt is the o/p ? is it 1000010010000211?


Yes, if EQUALS is in effect. Maybe or maybe not if NOEQUALS is in effect.
Back to top
View user's profile Send private message
prabusmd

New User


Joined: 01 May 2010
Posts: 7
Location: DE

PostPosted: Mon Sep 13, 2010 10:52 pm    Post subject:
Reply with quote

Thanks Frank and Dick!! I just checked the job (with out the change ) in SAR.

WER246I FILESIZE 44,987 BYTES
WER054I RCD IN 1897, OUT 456
WER072I EQUALS, BALANCE IN EFFECT

Does it mean automatically we have EQUALS in effect? How come?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 13, 2010 11:39 pm    Post subject:
Reply with quote

Hello,

Possibly because this is the site default.

Suggest you talk with the person/group who support Syncsort.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Sep 14, 2010 3:04 pm    Post subject:
Reply with quote

In a SyncTool Job, use this:
Code:
 //TOOLIN    DD *         
  DEFAULTS LIST(OUT)     
/*                       
OUT will have all the "defaults" listed for your shop for SyncSort.

To ansswer "how come" - well, answer is "it depends". If we talk about EQUALS, you've got two choices either choose to have EQUALS as "default" or not. Your site, per the messages you show, choose to go with EQUAL as default. They could also choose not to have that as default. That largely depends on who all were involved during the installation process and what do they think is best fit for the given system and then, they choose the defaults.
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 SORT BUT RETAIN HIGHEST VALUE ON NON-... leondan22 DFSORT/ICETOOL 2 Thu Dec 14, 2017 8:13 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts JOINKEYS Paired and Unpaired Sort on ... MFwhiz DFSORT/ICETOOL 7 Tue Nov 07, 2017 2:46 am
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
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