#1: Syncsort Problem Author: ranjit2705, Posted: Tue Oct 14, 2003 3:00 pm 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..
#2: Author: Mervyn, Location: Hove, EnglandPosted: Tue Oct 14, 2003 4:35 pm 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.
#3: Author: kolusu, Location: San JosePosted: Tue Oct 14, 2003 5:04 pm ranjit2705,
I concur with Mervyn that option equals is the culprit.so add this line in sort control cards