enable functionality group enables or disables the changes available for specific SAP ASE version 15.7 and later features.
|
Summary Information |
|
|---|---|
|
Default value |
0 |
|
Range of values |
0 (off), 1 (on) |
|
Status |
Dynamic |
|
Display level |
Intermediate |
|
Required role |
System administrator |
|
Configuration group |
SQL Server Administration |
Shareable inline defaults – when enable functionality group is set to 0, SAP ASE does not create shareable inline defaults, and does not reuse existing shareable inline defaults. The columns that share inline defaults (before you change this configuration parameter) continue to share the defaults until the defaults are removed.
select for update acquiring exclusive locks
Quoted identifiers
Unicode noncharacters
Monitoring cursor statements
Reducing query processing latency
Suppressing Job Scheduler max task messages
The default value for the parameters in this group depends on the value to which enable functionality group is set. A value of DEFAULT for the individual configuration parameters in this group—other than enable functionality group—means they are set to the same value as enable functionality group. That is, if you set enable functionality group to 1, a value of DEFAULT for any other configuration parameter in the group is 1.
Aside from the value for enable functionality group, you can ignore values of DEFAULT in the output from sp_configure and sp_helpconfig for individual configuration parameters in the Application Functionality group.