Problem solve Get help with specific problems with your technologies, process and projects.

Access paths, how long do they stick around?

How long do access paths stick around after defining a query, SQL, etc.?

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.