| View previous topic :: View next topic |
| Author |
Message |
deepa12
Beginner
Joined: 05 Apr 2005
Posts: 131
Topics: 64
Location: chennai
|
 Posted: Thu Sep 22, 2005 3:56 am Post subject: |
 |
|
Thanks for all your help
Got this resolved It wa a simple problem that i had to give
OPTION EQUALS
when the sort field contents are the same the positions of teh records in the o/p files for the 2 runs become unpredictable
Thanks & rgs
deepa
_________________
deepa |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12401
Topics: 75
Location: San Jose
|
| Posted: Thu Sep 22, 2005 4:56 am Post subject: |
|
|
| Quote: |
Got this resolved It wa a simple problem that i had to give
OPTION EQUALS
when the sort field contents are the same the positions of teh records in the o/p files for the 2 runs become unpredictable
|
deepa12,
EQUALS guarantees that the first of a series of equal-keyed records is either first-in (SORT) or from the lowest numbered SORTINnn data set(MERGE). With NOEQUALS, there is a random element to the order in which records with identical control fields will appear in the output. With or without EQUALS, MERGE preserves the order of equal-keyed records within any one data set.
But you still will have a problem with the different sort card. Run the sort using phantom's data which is 3 posts above and you will see the difference.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
deepa12
Beginner
Joined: 05 Apr 2005
Posts: 131
Topics: 64
Location: chennai
|
| Posted: Thu Sep 22, 2005 5:27 am Post subject: |
|
|
ok.. thanks
_________________
deepa |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Thu Sep 22, 2005 6:59 pm Post subject: |
|
|
Wow. Things really got out of hand on this one while I was on vacation. 
I saw the first post in this thread and thought to myself - EQUALS. Then I read through some of the other posts talking about how the third byte affects how the first two bytes are sorted and thought to myself - no way! Seems like everything was eventually straightened out, but it sure took a long time to get there. 
I'm just skimming the posts I missed while I was gone and commenting if I see something incorrect or unanswered.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
