|
View previous topic :: View next topic
|
| Author |
Message |
manugeorge2004
New User
Joined: 17 Jun 2009
Posts: 38
Location: Denver
|
|
|
|
I have a file where I want to check whether we have duplicates on an alphanumeric field.
SUM FIELDS work only with numeric fields
Can somebody help |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Quote: |
| SUM FIELDS work only with numeric fields |
even with my limited knowledge of DFSORT,
SUM FIELDS=NONE
does not care about the datatype.
So, I would say your comment is wrong. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
manugeorge2004,
Dick is correct about SUM FIELDS=NONE - it removes duplicates based on the SORT fields which can be alphanumeric (CH). The SELECT operator of DFSORT's ICETOOL can also be used to remove duplicates.
It's not clear what you're trying to do or what you think is wrong. If you want more specific help, show an example of the records in your input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input file. |
|
| Back to top |
|
|
|
|
