QUERYOPT

Indicates the desired level of optimization for all static SQL statements contained in the package.

Syntax:

QUERYOPT=optimization-level
NOQUERYOPT

Parameters:

optimization-level
A number that represents the optimization level. The default is 5. For the complete range of valid optimization level numbers and a description of each, see the SET CURRENT QUERY OPTIMIZATION statement topic in the SQL Reference of your IBM DB2 documentation.

Properties:

Default: NOQUERYOPT

Comments:

QUERYOPT is not supported by DRDA.

Parent topic: DB2 Compiler Directive Options