Creating the QAQQINI query options file

Each system is shipped with a QAQQINI template file in schema QSYS. The QAQQINI file in QSYS is to be used as a template when creating all user specified QAQQINI files.

To create your own QAQQINI file, use the Create Duplicate Object (CRTDUPOBJ) command. Create a copy of the QAQQINI file in the schema specified on the Change Query Attributes (CHGQRYA) QRYOPTLIB parameter. The file name must remain QAQQINI. For example:

CRTDUPOBJ OBJ(QAQQINI) 
          FROMLIB(QSYS) 
          OBJTYPE(*FILE) 
          TOLIB(MYLIB) 
          DATA(*YES)

System-supplied triggers are attached to the QAQQINI file in QSYS therefore it is imperative that the only means of copying the QAQQINI file is through the CRTDUPOBJ CL command. If another means is used, such as CPYF, then the triggers could be corrupted. An error is signaled that the options file cannot be retrieved or that the options file cannot be updated.

Because of the trigger programs attached to the QAQQINI file, the following CPI321A informational message is displayed six times in the job log when the CRTDUPOBJ CL is used to create the file. These messages are not an error; they are only informational messages.

CPI321A Information Message: Trigger QSYS_TRIG_&1___QAQQINI___00000&N in library &1 was added to file QAQQINI in library &1. The ampersand variables (&1, &N) are replacement variables that contain either the library name or a numeric value.

Note: It is highly recommended that the file QAQQINI, in QSYS, not be modified. This file is the original template that is duplicated into QUSRSYS or a user specified library for use.