Re: Generic Logical File

[Ken Sims <mr3111@xxxxxxxxx>]

Hi Mark -

> You can try an dynamically putting the 'correct' file in OPNQRYF statement
> and using a format file in the RPG program instead of a logical file.
> You'll have to specify OPTION(*ALL) in your OPNQRYF statement. Here is a
> quick example.
 <snip>
> Oehhstwk is read full procedural. That's why the OPTION(*ALL)

OPTION(*ALL) means that you are doing not only input operations, but also 
update, add, and delete operations, and the open data path created by the 
OPNQRYF is set accordingly.

If you are only doing input, but you're doing CHAINs, READEs, etc., 
SEQONLY(*NO) is better than OPTION(*ALL).

Using OPTION for anything other than just input implies SEQONLY(*NO) but 
does more than just SEQONLY(*NO).  If the file in the program is for input 
only, SEQONLY(*NO) is better.

Besides the fact that the ODP is opened for only input only, the query 
engine can do more to enhance the performance if it knows the file is going 
to be used only for input, such as making a temporary copy of a subset of 
the data.

Ken
http://www.ke9nr.net/
Opinions expressed are my own and do not necessarily represent the views of 
my employer or anyone in their right mind.