I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file.
I am accessing keyed logical file based on physical which contains 180 Million records.
Can anyone please suggest any ideas to reduce the time taken to select the records from this huge input file to generate the output extract.
your help is greatly appreaciated.
October 2, 2012 3:23 PM