IBM Mainframe Forum

by **ranga_subham** » Thu Oct 28, 2010 5:20 pm

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:

Select all

//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:

Select all

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

Please help.

Thanks.

by **dick scherrer** » Fri Oct 29, 2010 2:10 am

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.

by **Alissa Margulies** » Fri Oct 29, 2010 2:55 am

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?

by **ranga_subham** » Fri Oct 29, 2010 4:00 pm

Dick & Alissa,

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

Thanks.

by **Alissa Margulies** » Fri Oct 29, 2010 8:11 pm

Glad to hear you got it working. Thanks for letting us know.

IBM Mainframe Forum

remove duplicates

remove duplicates

Re: remove duplicates

Re: remove duplicates

Re: remove duplicates

Re: remove duplicates