RE: Use of a Query option in QAQQINI w/o access to QAQQINI -- MIDRANGE-L

× 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.

<snip>
I would like to have the option IGNORE_DERIVED_INDEX set to *YES for
regular end users that do not have authority to QAQQINI to CRTDUPOBJ
into QTEMP. The offending logical file is related to my SQLRPGLE only
by the fact I joined a file that is part of a SQLVIEW that happens to
join to the offending logical file's table.
</snip>

You could make it permanent by creating a copy of QAQQINI into QUSRSYS
and pointing your system to use that copy and changing the value on
IGNORE_DERIVED to yes. This is how I have it done in our system so that
it will always ignore derived indexes. This is going to be the default
in the next release.

I, also, have a user defined function at www.think400.dk/downloads.htm
to set query options at run time. This could easily be complied to run
under owner authority but that would mean that any query option could be
set. I don't know if that would be a problem or not. Since it is a
program object underneath, you could authorize the program to only
certain users.

Hope this helps.

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.