View previous topic :: View next topic
|
Author |
Message |
pjnithin
Active User
Joined: 22 Dec 2005 Posts: 116
|
|
|
|
When we use sum fields=none, which record among the duplicate records will be retained. Is it always the first record that occur among the group of duplicate records that will be retained or it picks some record randomly. |
|
Back to top |
|
|
sril.krishy
Active User
Joined: 30 Jul 2005 Posts: 183 Location: hyderabad
|
|
|
|
If you have coded the EQUALS ,then it will pick up the first record.Else it will pick in random order.You can check the default option set for this in your system.
Thanks
Krishy |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
I'd assume that this would apply even with NONE specified..... |
Yes, with EQUALS, DFSORT will keep duplicate records in their original order for SORT and SUM. |
|
Back to top |
|
|
|