Hi,
I have two input files as below
In1 Dataset name 'MY.DATA1'
Var1 DATA1
----- --------
XYZ 20000
abc 25000
123 30000
in2 Dataset name 'MY.DATA2'
VAR2 DATA2 DATA3 DATA4 DATA5
------ ------- ------- ------- --------
XYZ 05000 a b c
abc 17000 a
123 10000 X
My Output should be as below
XYZ 20000 a b c
abc 25000 a
123 30000 X
My DATA1 in input file is update data which i need to update in INPUT2 rest of input2 should be same.
Can it be achieved in DFSORT?
Can it be updated in 'MY.DATA2' dataset means it will be my input and output dataset as well, can this be done?