Need help to compare 2 files and write the matched records



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

Re: Need help to compare 2 files and write the matched recor

Postby BillyBoyo » Fri Apr 01, 2011 12:51 pm

Do you know any programming languages? A simple task, unless you have not the right skills... I don't suppose it is possible to get the latest version of the Sort?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Need help to compare 2 files and write the matched recor

Postby pgoe9 » Fri Apr 01, 2011 12:58 pm

I know I can get the same thing done by coding a COBOL program. However, I don't want to simply create a new component when the same can be achieved by writing 1 or 2 steps though some utility in JCL.
I was hopeful that JOINKEYS would help me but unfortunately I cannot get the latest cersion of the SORT installed. So was hoping if anyone has any equivalent idea to achieve the same?
pgoe9
 
Posts: 5
Joined: Wed Mar 30, 2011 5:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Need help to compare 2 files and write the matched recor

Postby enrico-sorichetti » Fri Apr 01, 2011 1:08 pm

You might try with the SPLICE operator of SYNCTOOL ,
but we cannot tell for sure
SYNCSORT MANUALS are not pubicly available while DFSORT are

being the two competitive products they share many common facilities
and You can get useful hints anyway from the SMART SORT TRIKS here
http://www-01.ibm.com/support/docview.w ... g3T7000094
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3003
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Need help to compare 2 files and write the matched recor

Postby NicC » Fri Apr 01, 2011 2:45 pm

If your version of SYNCSORT supports SYMNAMES then use that - first step use file one to create a symname and second step to use it.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post