New to OPNQRYF

[Guest.Visitor]

We are new to OPNQRYF and I have a question. We have a join logical file which joins a header file of approximately 300,000 records and a detail file of about 500,000 records. We have a simple OPNQRYF on the join logical file with a selection of a date range. It ran well over an hour before we ended it. Is this a normal amount of time for files this size? Are we doing something wrong? We just upgraded from 4.1 to 4.3 on a 620. Here is the code. CHGVAR VAR(&QRYSLT) VALUE('SHIDTE = + %RANGE(' *CAT &ABEG *CAT ' ' *CAT &AEND *CAT ')'). OPNQRYF FILE((FFDWSCD/JSLSLYL1)) QRYSLT(&QRYSLT) + KEYFLD((SHSLSM) (SHBILT) (SHINV#)).

[Guest.Visitor]

Ok, I think we found our problem. In the join file the detail was the primary file. We tried the header as the primary file and the time came down to a few minutes.