More about SQL and Logical Files
April 16, 2008 Ted Holt
Last week I advised you to avoid referencing logical files in SQL queries. This week I have a little more information for you regarding SQL and its love-hate relationship with logical files.
This week’s tip: In your QAQQINI file, set IGNORE_DERIVED_INDEX to *YES.
So what does that mean? First, QAQQINI is a file that you can use to control query processing. If you’re not familiar with it, follow the links at the end of this article to learn about it.
At this point, I assume you know what QAQQINI is and that you have duplicated it from QSYS to QUSRSYS