I have 2 links from 2 db2 tables with data like below
Code: Select all
source:
---------
key1,key2,val1,val2
-----------------------
123,121,120,128
123,120,120,123
123,112,119,100
Reference:
-------------
key1,key2,val1,val2
-----------------------
123,120,120,123
123,112,119,100
Code: Select all
source.key1=Ref.Key1 and source.key2<> Ref.key2
and if any data with source.val1=ref.val1 then check src.val2>ref.val2 and satisfies choose the record.
else if any record with src.val2>ref.val2 choose that.
Code: Select all
key,key2,val1,val2,key2_1,val1_1,val2_1
------------------------------------------------
123,121,120,128,120,120,123
123,120,120,123,112,119,100
For using merge, i need to write those to 2 seq files and then i need to proceed. Is there any other way for this?
Thanks