Specifying the QAQQINI file

 

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

The query options file will be retrieved from the schema specified on the QRYOPTLIB parameter for each query and 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 but the QRYOPTLIB parameter is not specified, the schema QUSRSYS is searched for the existence of the QAQQINI file. If a query options file is not found for a query, no attributes will be modified. Since the server is shipped with no INI file in QUSRSYS, you may 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.

 

Parent topic:

Control queries dynamically with the query options file QAQQINI

 

Related information

Change Query Attributes (CHGQRYA) command