How to create output files without duplicate record

Vkp321 · New User Joined: 05 Jan 2009 Posts: 56 Location: Dublin

With the sort card I am able to create two file but records are duplicated. Is there any solution so the output files will have only unique records?

SORT FIELDS=COPY
OUTFIL FILES=01,INCLUDE=(5,6,CH,EQ,C'202205',AND,19,2,CH,EQ,C'40'),
OUTREC=(1:19,2,3:196,2)
OUTFIL FILES=02,INCLUDE=(5,6,CH,EQ,C'202205',AND,19,2,CH,EQ,C'42'),
OUTREC=(1:19,2,3:196,2)

Escapa · Posted: Thu Oct 22, 2009 2:07 pm

Hi Pradeep,
Which sort product are you using? What is input and output datasets LRECL and RECFM.

What do you mean by unique records? do you mean combination of the 2,6,CH and 19,2,CH should be unique?

Can you please show us few records of input dataset and expected output for the same.(use code tag)

gcicchet · Posted: Thu Oct 22, 2009 2:14 pm

Hi Pradeep,

what makes it a duplicate record ?

Please give example of input and output data.

If 2,6,CH and 19,2,CH are to be unique, does it mean only 1 record will be written to the output files ?

Gerry

expat · Posted: Thu Oct 22, 2009 2:23 pm

This works for me from what I understood of your request, although for testing purposes only I used an 80 byte record, changing your field at 196 into 26 for my test.

Vkp321 · New User Joined: 05 Jan 2009 Posts: 56 Location: Dublin

Thanks Expat your solution worked..

Skolusu · Posted: Thu Oct 22, 2009 9:50 pm

Vkp321,

I would use these control cards for better efficiency.

gcicchet · Posted: Fri Oct 23, 2009 7:06 am

Hi Kolusu,

is it really necessary to sort the selected records, wouldn't the first occurrence of "40" and "42" do the trick ?

Gerry

Skolusu · Posted: Fri Oct 23, 2009 8:39 pm