MVSFORUMS.com

sood · Beginner Joined: 29 Sep 2004 Posts: 3 Topics: 1

Hi, I want to sort to remove the duplicate lines in my file but do not want any other order of records to be changed - that is no other 'sorting' criteria except removing duplicates .. pls help

vivek · Posted: Wed Sep 29, 2004 9:17 am Post subject:

Sood,

use sum fields=none

if you want duplicate recs to go into separate dataset

use

sum fields=none,xsum

and declare a ddname
//sortxsum dd dsn=duplicate dsn

Hope it helps.
thanks,
_________________
Vivek,NJ

Db2,IDMS

sood · Beginner Joined: 29 Sep 2004 Posts: 3 Topics: 1

Hi, I am using sum fields=none but before that, I have to give sort fields parameter eg (1,123,CH,A). This is what I dont want to do as I dont want to arrange in any order but just remove duplicates. But if this parameter is not given , I get an abend

kolusu · Posted: Wed Sep 29, 2004 9:35 am Post subject:

Sood,

If you want to retain the orginal order of the records, then you need one more pass of the data.

sood · Beginner Joined: 29 Sep 2004 Posts: 3 Topics: 1

thanks pal ! it worked ! big help !