CONCENTRATESTMT bind option
The CONCENTRATESTMT option specifies whether to enforce statement concentration at the package level.
| Command option | Option values | Used with |
|---|---|---|
| CONCENTRATESTMT |
|
Note:
- The CONCENTRATESTMT bind option is not valid for REBIND of packages for native SQL procedures.
Option descriptions for CONCENTRATESTMT
- CONCENTRATESTMT(NO)
- Specifies that statement concentration is not enabled for the package.
- CONCENTRATESTMT(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 |
