Re: SQLRPGLE program giving strange message in joblog

It's the query options file.

Creating the QAQQINI query options file

Each system is shipped with a QAQQINI template file in library 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 CRTDUPOBJ command to create a copy of the QAQQINI file in the library that will be specified on the CHGQRYA QRYOPTLIB parameter. The file name must remain QAQQINI, for example:

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

Because system-supplied triggers are attached to the QAQQINI file in QSYS it is imperative that the only means of copying the QAQQINI file is through the CRTDUPOBJ CL command.

QAQQINI query options file format

Query Options File:

                                     UNIQUE 
R QAQQINI                            TEXT('Query options + file') 
 
QQPARM                    256A       VARLEN(10) + 
                                     TEXT('Query +  
                                           option parameter') + 
                                     COLHDG('Parameter') 
QQVAL                     256A       VARLEN(10) + 
                                     TEXT('Query option + 
                                           parameter value') + 
                                     COLHDG('Parameter Value') 
 QQTEXT                   1000G      VARLEN(100) + 
                                     TEXT('Query + 
                                           option text') + 
                                     ALWNULL + 
                                     COLHDG('Query Option' + 
                                            'Text') + 
                                     CCSID(13488) + 
                                     DFT(*NULL) 
 K QQPARM 

The QAQQINI file shipped in the library QSYS has been pre-populated with the following rows:

Table 8. QAQQINI File Records

Setting the options within the query options file

The QAQQINI file query options can be modified with the INSERT, UPDATE, or DELETE SQL statements.

For the following examples, a QAQQINI file has already been created in library MyLib. To update an existing row in MyLib/QAQQINI use the UPDATE SQL statment. This example sets MESSAGES_DEBUG = *YES so that the query optimizer will print out the optimizer debug messages:

UPDATE MyLib/QAQQINI SET QQVAL='*YES' 
WHERE QQPARM='MESSAGES_DEBUG'

To delete an existing row in MyLib/QAQQINI use the DELETE SQL statement. This example removes the QUERY_TIME_LIMIT row from the QAQQINI file:

DELETE FROM MyLib/QAQQINI 
WHERE QQPARM='QUERY_TIME_LIMIT'

To insert a new row into MyLib/QAQQINI use the INSERT SQL statement. This example adds the QUERY_TIME_LIMIT row with a value of *NOMAX to the QAQQINI file:

 INSERT INTO MyLib/QAQQINI 
VALUES('QUERY_TIME_LIMIT','*NOMAX','New time limit set by DBAdmin')

QAQQINI query options

The following table summarizes the query options that can be specified on the QAQQINI command:

Table 9. Query Options Specified on QAQQINI Command

QAQQINI query options file authority requirements

QAQQINI is shippped with a *PUBLIC *USE authority. This allows users to view the query options file, but not change it. It is recommended that only the system or database administrator have *CHANGE authority to the QAQQINI query options file.

The query options file, which resides in the library specified on the CHGQRYA CL command QRYOPTLIB parameter, is always used by the query optimizer. This is true even if the user has no authority to the query options library and file. This provides the system administrator with an additional security mechanism.

When the QAQQINI file resides in the library QUSRSYS the query options will effect all of the query users on the system. To prevent anyone from inserting, deleting, or updating the query options, the system administrator should remove update authority from *PUBLIC to the file. This will prevent users from changing the data in the file.

When the QAQQINI file resides in a user library, specified on the CHGQRYA CL command option QRYOPTLIB, the query options will effect all of the querys run for that user's job. To prevent the query options from being retrieved from a particular library the system administrator can revoke authority to the CHGQRYA CL command.

QAQQINI file system supplied triggers

The query options file QAQQINI file uses a system-supplied trigger program in order to process any changes made to the file. A trigger cannot be removed from or added to the file QAQQINI.

If an error occurs on the update of the QAQQINI file (an INSERT, DELETE, or UPDATE operation), the following SQL0443 diagnostic message will be issued: