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:
- Open Run SQL Scripts.
- From the Options menu, select Change Query Attributes. Your job is displayed
in the window.
- Specify or select the library that contains the query attributes table (QAQQINI table) that you want to use.
- (Optional) Click Open Attributes.
- You can change the values by selecting the value you want to change and entering a new value.
- You can insert a new row by selecting Insert from the View menu.
- You can delete a row by selecting that row and selecting Delete from the View menu.
- When you are finished making changes to the table, select Save from the File menu.
- Close the table by selecting Exit from the File menu.
- 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.