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.
|
Comment:
Applies to DB2 LUW only.