Hi, I need to compare 2 large database files on the AS400, they have 20 million + records each. They are both keyed uniquely, exact same file layout. I need to identify inserted, updated and deleted records. I tried using cobol program reading first file with the unique logical, and matching with the second file and checking for differences etc. The problem is that it's taking way too long. Would anyone have any suggestions please? It's a batch process, the Cobol is called from a CL. I can embed SQL if it helps....
September 5, 2011 5:30 PM
March 31, 2012 5:08 PM