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')

 

Parent topic:

Control queries dynamically with the query options file QAQQINI