Change query attributes

You can optimize your query performance by editing your QAQQINI file, allowing you to dynamically modify or override the environment in which query are executed.

To change query attributes for a job:

  1. Open Run SQL Scripts.
  2. From the Options menu, select Change Query Attributes. Your job is displayed in the window.
  3. Specify or select the library that contains the query attributes table (QAQQINI table) that you want to use.
  4. (Optional) Click Open Attributes.
  5. Click OK.

Note: Changes to the QAQQINI table that is located in the QSYS file will affect all of the queries running on the system, therefore it is recommended that you use caution when making changes to this table.