remove duplicates



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

remove duplicates

Postby 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:
//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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: remove duplicates

 

Re: remove duplicates

Postby 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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: remove duplicates

Postby 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?
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time

Re: remove duplicates

Postby 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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: remove duplicates

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

Glad to hear you got it working. Thanks for letting us know.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post