by mayankjha025 » Tue Sep 26, 2017 7:21 pm
I have 2 files. One is VSAM file with key of length 24 and 10 lakh plus records. The second file is a flat file, which has 70 thousand records. I have to fetch a particular field from flat file, if the record matches the key of VSAM file. suppose i read first record of VSAM file, then i read the flat file one by one till end and if the key matches any record in between, it is written in out file. Then again i read the VSAM for second key, then i read the flat file and use the same logic as mentioned before. The records are written correctly to the out file but the problem is since the VSAM is very large, the Job is running for a very long time(around 1.5 hours). Can anyone help with an alternate logic so the program can be more efficient? Thanks!