Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Access > Reference > DB2 > DB2 Compiler Directive Options > OPTPROFILE

OPTPROFILE

Specifies the name of an existing optimization profile to be used for all static statements in the package.

Note: This option is not supported by DRDA.

Syntax:

OPTPROFILE=profileName
NOOPTPROFILE

Parameters:

profileName

The default value is an empty string. When specified, the name applies as the default for dynamic preparation of DML statements for which the CURRENT OPTIMIZATION PROFILE special register is null. If the specified name is unqualified, it is an SQL identifier, which is implicitly qualified by the QUALIFIER bind option.

Properties:

Default:

NOOPTPROFILE

Comment:

Applies to DB2 LUW only.