Start of change

CONCENTRATESTMT bind option

The CONCENTRATESTMT option specifies whether to enforce statement concentration at the package level.

Command option Option values Used with
CONCENTRATESTMT
  • (NO)
  • (YES)
Note:
  1. The CONCENTRATESTMT bind option is not valid for REBIND of packages for native SQL procedures.

Option descriptions for CONCENTRATESTMT

( NO )
Specifies that statement concentration is not enabled for the package.
( YES )
Specifies that statement concentration is enabled for the package. This option is a package-level alternative to specifying the statement attribute CONCENTRATE STATEMENTS WITH LITERALS in PREPARE statements.

If the CONCENTRATE STATEMENTS attribute is explicitly included in a PREPARE statement, the setting for the prepared statement overrides the CONCENTRATESTMT bind option.

Default values for CONCENTRATESTMT

Process Default value
BIND PACKAGE NO
REBIND PACKAGE NO
End of change