Help Required on Joinkeys



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Help Required on Joinkeys

Postby neo4u » Mon Dec 01, 2014 1:17 pm

Hi Frieds,

I have a requirement where I need to find if a keys in file-1 is present in File-2. I would need to stop the processing for a particular key once a match is found, the search should then continue for the next key. This is because file-2 is humongous!! and just a simple sort is taking hell lot of time (more than 4 hours!!!). Is it possible using SYNCSORT? My shop uses syncsort.


Thanks
neo4u
 
Posts: 8
Joined: Sat Oct 02, 2010 5:52 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help Required on Joinkeys

Postby BillyBoyo » Mon Dec 01, 2014 1:59 pm

Can you show what you have tried, including the fully sysout from the step which took four hours? Also a short reperentative example of what you mean, input and expected output.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Help Required on Joinkeys

Postby neo4u » Tue Dec 02, 2014 10:31 am

Hi Billy,

My Requirement is as below
File-1
value | key
a | 1
b | 2
c | 2
d | 4
..

File-2
Key
1
2
3
5
6
...

What I need is, for value "a" in file-1 the key value should be seached in file-2 and if there's a match I should write it to output with some indicator. Sample output is as below
A Yes
B Yes
C Yes
D No


My Sort card looks like this,
SORT FIELDS=(204,10,CH,A)             
SUM FIELDS=NONE                       
OUTFIL FNAMES=FBOUT,VTOF,BUILD=(204,10)

I was just trying to get the list and then put it into excel and vlookup to get the desired output, but the job got cancelled by operator.
neo4u
 
Posts: 8
Joined: Sat Oct 02, 2010 5:52 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help Required on Joinkeys

Postby neo4u » Thu Dec 04, 2014 12:07 pm

I was able to do this using ICETOOL.. Thanks!! Closing the thread.
neo4u
 
Posts: 8
Joined: Sat Oct 02, 2010 5:52 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help Required on Joinkeys

Postby BillyBoyo » Thu Dec 04, 2014 1:21 pm

Good for you. If you'd like to post your solution, we may be able to suggest improvements.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post