2530476 - Default value for parameter max nesting level

Manual ASE - System Administration Guide for version 16.0 and version 15.7 states that parameter ""max nesting level"" has a default value "50":

=========

In SAP ASE 15.0.3 and later, the maximum nesting level has been increased to 100, and the default value to 50.

=========

But the output from sp_configure for this parameter ("max nesting level") in both version indicates "16":

=========

1> sp_configure "max nesting level"
2> go
Parameter Name
Default Memory Used
Config Value
Run Value
Unit
Type
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------- ----------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
----------------------------------------
max nesting level
16 0
16
16
number
static

(1 row affected)
(return status = 0)

=========

• SAP Adaptive Server 15.7
• SAP Adaptive Server 16.0

sp_configure default value max nesting level manual system administration guide 494239 810586 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem