MERGE, Sum fileds=none, doesnot eliminate duplicates being written to master file,
it only filters the duplicates in input (transaction) file.
please share an example with us, if you have a working one
Well, I had a feeling I didn't understand your requirement, and I guess the feeling was right. Please show an example of the input records in each file and the expected output records and explain the "rules" in terms of the example. Also, what is the LRECL of each input file.
so now cust1 and cust3 are already present in Masterfile,
so when I merge, these records (cust1 and cust3) should not be written to master (since master file already has those records).
My daily file will have more than a million records, and master file is a monthly consolidated one, it will have around 40million records..
one way is first merge both the files to a temporary file and then apply somefileds=none and recreate the master file, But I cannot do that..
since I am not authorized to delete and I am not supposed to do so...
Writting a cobol program to append the master the file is ruled out..
The key here is to use SORTIN01 for the master file and SORTIN02 for the transaction file along with the EQUALS option. That way, the first record of each set of duplicates will be kept and that will be the record from the master file.
If the records are not already sorted, you can use this job instead: