Joinkeys



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

Joinkeys

Postby jayasakthivel » Sun Mar 09, 2014 12:37 pm

Hi ,
I need to compare two files in files in which i need to compare the first file for different positions.
input1:
05 a
05 abcd
02 ab

Input2:
05 a plana
05 b planb
05 c planc
05 d pland


First i need to compare 4 th position, if it matches have to write file 2 , then it needs to compare 5 th position ,then 6 th positin and so on till 10.is there any way possible that we can do it in Joinkeys in a single step.it takes 6 steps for me as i put compare for each position.Please help.
jayasakthivel
 
Posts: 2
Joined: Fri Jan 03, 2014 7:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: Joinkeys

Postby jayasakthivel » Sun Mar 09, 2014 12:39 pm

First i need to compare 4 th position,with the 4 th position in file2. if it matches have to write file 2 , then it needs to compare 5 th position of file1 with 4 th position of file2 ,then 6 th positin and so on till 10 th position of file1 .Is there any way possible that we can do it in Joinkeys in a single step.it takes 6 steps for me as i put compare for each position.Please help.
jayasakthivel

Posts: 1
Joined: Fri Jan 03, 2014 7:19 am
jayasakthivel
 
Posts: 2
Joined: Fri Jan 03, 2014 7:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: Joinkeys

Postby BillyBoyo » Sun Mar 09, 2014 7:50 pm

You'll need to describe what you want to do when you get a match, when you don't get a match.

How many records on each file? What LRECL and RECFM?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Joinkeys

Postby dick scherrer » Mon Mar 10, 2014 3:59 am

Hello,

If the sample data does not cover all cases, add some more sample data.

Then show the output(s) you want from the complete sample data.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post