Merge of Datasets
Posted: Mon Nov 02, 2009 6:48 pm
I have to merge 2 datasets (same record layout). Each record has a key (10 Bytes) and the rest is data.
The first dataset holds some sort of base data. The second dataset delivers new data for this.
Now i want a new output which holds all records from both files except those which key is in both files. In this cases only the record of the second dataset should be written to the output.
This gives some sort of "add new" and "update existing" records logic.
Is there any standard tool that can manage this, or do i have to write a program?
I found the merge function of DFSORT, but it seems as this could only add all records of both files to the output.
Thanks for your help.
Geri
The first dataset holds some sort of base data. The second dataset delivers new data for this.
Now i want a new output which holds all records from both files except those which key is in both files. In this cases only the record of the second dataset should be written to the output.
This gives some sort of "add new" and "update existing" records logic.
Is there any standard tool that can manage this, or do i have to write a program?
I found the merge function of DFSORT, but it seems as this could only add all records of both files to the output.
Thanks for your help.
Geri