View previous topic :: View next topic |
Author |
Message |
ranjit2705 Beginner
![](images/avatars/gallery/babypics/maidsb.gif)
Joined: 25 Mar 2003 Posts: 12 Topics: 8
|
Posted: Tue Oct 14, 2003 3:00 pm Post subject: Syncsort Problem |
|
|
I have two flat files which are exactly same (compared in 3.13)....now I am sorting these two files using SYNCSORT. The sort criteria is same for both these files. In this case the two SORTED output files should also match exactly......but when I compare in 3.13 these two are not matching...I am getting few sequence mismatch.....I can't see any reason..can any one throw some light on this.....
Thanks
Ranjit..
![Embarassed](images/smiles/icon_redface.gif) _________________ Regards
Ranjit S Panda
Software Engineer |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Mervyn Moderator
![](images/avatars/gallery/members/merv.jpg)
Joined: 02 Dec 2002 Posts: 415 Topics: 6 Location: Hove, England
|
Posted: Tue Oct 14, 2003 4:35 pm Post subject: |
|
|
Ranjit, my bet is that you have records with equal sort keys, but with other fields that are not equal. Under these circumstances, it's not impossible to get different results.
Try using the EQUALS keyword in your SORT command. _________________ The day you stop learning the dinosaur becomes extinct |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12366 Topics: 75 Location: San Jose
|
Posted: Tue Oct 14, 2003 5:04 pm Post subject: |
|
|
ranjit2705,
I concur with Mervyn that option equals is the culprit.so add this line in sort control cards
Code: |
OPTION EQUALS
SORT FIELDS=(...)
|
Kolusu |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|
|