|
View previous topic :: View next topic
|
| Author |
Message |
Hari Kumar
New User
Joined: 28 Jul 2005
Posts: 19
|
|
|
|
Hi,
In DFSORT, if there is any duplicate record found then i have to eliminate both the records. what is the command ??
I know in ICETOOL we can use NODUP. I need DFSORT command. |
|
| Back to top |
|
 |
prafull
New User
Joined: 08 Dec 2006
Posts: 48
|
|
|
|
in sort card use ,
SUM FIELDS=NONE
after sort |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hey prafull,
It would not eliminate both the records it will keep one record . |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
I know in ICETOOL we can use NODUP. I need DFSORT command.
|
SELECT with NODUPS will do that. I don't understand why you need a DFSORT command rather than a DFSORT/ICETOOL command. If you have DFSORT, then you have DFSORT's ICETOOL. Your site's payment for DFSORT covers the exta functions available with ICETOOL (which has been avaiilable with DFSORT since 1991), so why not use it?
| Quote: |
in sort card use ,
SUM FIELDS=NONE
after sort
|
SUM FIELDS=NONE is equivalent to SELECT with FIRST. All of the other functions supported by DFSORT's ICETOOL (NODUPS, ALLDUPS, FIRSTDUP, LASTDUP, etc) cannot be done with SUM FIELDS=NONE. |
|
| Back to top |
|
|
Hari Kumar
New User
Joined: 28 Jul 2005
Posts: 19
|
|
|
|
Thanks lot for your information. I am using NODUPS option.
Regards,
Hari |
|
| Back to top |
|
|
|
|
