Specifying the QAQQINI file with CHGQRYA

Use the Change Query Attributes (CHGQRYA) command with the QRYOPTLIB (query options library) parameter to specify which schema currently contains or contains the query options file QAQQINI.

The query options file is retrieved from the schema specified on the QRYOPTLIB parameter for each query. It remains in effect for the duration of the job or user session, or until the QRYOPTLIB parameter is changed by the Change Query Attributes (CHGQRYA) command.

If the Change Query Attributes (CHGQRYA) command is not issued, or is issued without the QRYOPTLIB parameter specified, QUSRSYS is searched for the QAQQINI file. If a query options file is not found, no attributes are modified. Since the system ships without an INI file in QUSRSYS, you might receive a message indicating that there is no INI file. This message is not an error but an indication that a QAQQINI file that contains all default values is being used. The initial value of the QRYOPTLIB parameter for a job is QUSRSYS.