View previous topic :: View next topic
|
Author |
Message |
akshathan
New User
Joined: 18 Aug 2006 Posts: 45
|
|
|
|
Hi All,
I have an input file which has multiple records associated with a customer id. For instance i have 13 records associated with the customer id 69456, also to differentiate between these 13 records i have a field which will have record number relative to the customer id.
When i am sorting this file on Cusid, i am not able to find the records in the same order as before sorting. The reason why i am telling this is the field on which i am sorting is same for all 13 records so both input and output should be same.But in this case i am able to find the difference.
I have attached the screen shot in the document.
Can some one please help me on this.
[/url] |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
do not post attachment, not everybody can look at them,
also why waste 120 KB for a jpeg when a simple text cut and paste would use less space and give the same amount of info...
the attachemnt has been deleted |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
also to differentiate between these 13 records i have a field which will have record number relative to the customer id.
When i am sorting this file on Cusid, i am not able to find the records in the same order as before sorting. |
Do you want the output records within this differentiation field or the original sequence? Will either/both give the same results? |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
akshathan,
If you need the duplicate records in their original order, use:
Code: |
//DFSPARM DD *
OPTION EQUALS
/*
|
|
|
Back to top |
|
|
|