Setting the options within the query options file

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 statement. This example sets MESSAGES_DEBUG = *YES so that the query optimizer prints 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')