OPNQRYF

[K.Forsythe]

Each file will have its own Open Data Path that the OPNQRYF command must build and then share with the RPG program. Kevin

[Trevor J Price]

Do my indexes still exist in the logical or do you have to specify key fields in the opnqryf? Trevor

[Trevor J Price]

I have been reading info out on IBM's website but don't really get a clear picture on what I am wondering. I was hoping someone here could assist me. What I am wanting to know is if I do an opnqryf on a pf, do logicals over the pf use the temp data set? I want to get a subset of the data and then use multiple lf's in my rpg to access that information. From what I gathered I would have to issue a opnqryf on each logical that I want to use, is that true? thanks

[K.Forsythe]

The records are returned in whatever order goes the fastest. If you want a specific order and the ability to do any random I/O - use the KEYFLD parameter to set your keys.

[buck.calabro@commsoft.net]

> What I am wanting to know is if I do > an opnqryf on a pf, do logicals over > the pf use the temp data set? No. The logicals are built over the PF. Think of OPNQRYF like a LF that you create on the fly. If you create a new LF, does that affect any of the existing LF's? No. If you need multiple access paths inside your RPG program you need to run multiple OPNQRYFs. --buck