How long do access paths stick around after defining a query, SQL, etc.?
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
In the case of OPNQRYF, the access path will stay around until you close the file. I don't know how long OS/400 keeps temporary access paths, but if I had an access path I wanted to use more than once, I would create the access path to ensure that it would be there when I needed it.
Dig Deeper on Systems Management Tools
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.