Page 1 of 1

remove duplicates

PostPosted: Thu Oct 28, 2010 5:20 pm
by ranga_subham
Hi,

I am using below shown data and SORT card to remove duplicates from input file but in vain :cry:

Input:
         1         2         3         4         5         6         7         8         9       
....5....0....5....0....5....0....5....0....5....0....5....0....5....0....5....0....5....0
%RAN380050BOT   03101809CHELLAMES  T   0000024388200001TOM200903101809SERPENTSETA000074
&PAN311057BON   12151503MARIASALO  B   00000164118     VAN200912151503VARNISHIPIA000006
&SAN380041BOY   12151504GIRIASUNT  B   00000243879     CAR200912151504CORVETTESPA000006
&PAN311057BON   12151503MARIASALO  B   00000164118     VAN200912151503VARNISHIPIA000006


SORT card:
//SYSIN    DD *                                         
  SORT FIELDS=(17,8,ZD,A,36,1,CH,A,45,6,ZD,A,82,6,ZD,A)
  SUM FIELDS=NONE                                       


Would you please tell me why it is not giving 3 output records :?:

Expected Output:
%RAN380050BOT   03101809CHELLAMES  T   0000024388200001TOM200903101809SERPENTSETA000074
&PAN311057BON   12151503MARIASALO  B   00000164118     VAN200912151503VARNISHIPIA000006
&SAN380041BOY   12151504GIRIASUNT  B   00000243879     CAR200912151504CORVETTESPA000006


Please help.

Thanks.

Re: remove duplicates

PostPosted: Fri Oct 29, 2010 2:10 am
by dick scherrer
Hello,

I suspect there is something you are not showing. . .

I copied your data (up thru position 72) and changed the sort fields to not use the 82,6,ZD,A and it worked as you say you want.

Re: remove duplicates

PostPosted: Fri Oct 29, 2010 2:55 am
by Alissa Margulies
I, too, ran a test - with the complete sample data stored in a data set (FB/90) and the exact SYSIN specified above. The sort produced the expected output. Ranga - What release of SyncSort for z/OS are you running? What exactly are you getting in the output?

Re: remove duplicates

PostPosted: Fri Oct 29, 2010 4:00 pm
by ranga_subham
Dick & Alissa,

Yes. It is working.........my mistake was I put different SORT fields :oops:

Thanks.

Re: remove duplicates

PostPosted: Fri Oct 29, 2010 8:11 pm
by Alissa Margulies
Glad to hear you got it working. Thanks for letting us know.