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 |
enable functionality group enables or disables the changes available for these features in Adaptive Server versions 15.7 and later:
Shareable inline defaults – when enable functionality group is set to 0, Adaptive Server 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.