Previous Topic Next topic Print topic

Micro Focus Visual COBOL 2.3 for Eclipse (UNIX) > Programming > Data Access > Database Access > Reference > DB2 > DB2 Compiler Directive Options > QUERYOPT

QUERYOPT

Indicates the desired level of optimization for all static SQL statements contained in the package. The default value is 5. For the complete range of optimization levels available, see the SET CURRENT QUERY OPTIMIZATION statement in the SQL Reference. This DB2 precompile/bind option is not supported by DRDA.

Syntax:

QUERYOPT= optimization-level
NOQUERYOPT

Properties:

Default: NOQUERYOPT
Parent topic: DB2 Compiler Directive Options
Previous Topic Next topic Print topic