Eliminating dups using SORT and ICETOOL

meenasomu · New User Joined: 15 Sep 2005 Posts: 17

Hi,

My requirement is to remove duplicates from the input records and select only specific fields from the input rec to output rec.

When i used ICETOOL with SUM FIELDS = NONE, the duplicates weren't removed. When i used the same control card using SORT, it worked.

Can anyone explain why i was not able to remove the duplicates using ICETOOL.

I have given the JCL that i used for reference.

Using ICETOOL,

Frank Yaeger · Posted: Wed Jan 04, 2006 9:34 pm

When I run your jobs with DFSORT, I get the same result for both cases (one record).

You're using a COPY operator with a SORT statement instead of a SORT operator with a SORT statement. In older versions of DFSORT, this would result in a COPY (SUM FIELDS=NONE has no meaning for a COPY since there's no key). In newer versions, it results in a SORT. So you're either using an older version of DFSORT or another product. Change your ICETOOL statement to:

SORT FROM(INDD) TO(OUTDD) USING(CTR1)

and you will get a SORT rather than a COPY.

By the way, here's another way to do this with DFSORT/ICETOOL: