SQL Doesn’t Like Logical Files

Today’s tip: Don’t put DDS-defined logical file names in your SQL statements.
To understand why, let me give you a little background. When you execute an SQL command, the system determines the best way to carry out your request. That is, you concentrate on the task that needs to be done, and the system figures out [...]

Read Full Post »

More about SQL and 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 [...]

Read Full Post »