×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
