In Adaptive Server 15.0.3 and later, the maximum nesting level has been increased to 100, and the default value to 50.
Summary information |
|
---|---|
Default value |
50 |
Range of values |
16 – 100 |
Status |
Static |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
User environment |
maximum nesting level sets the maximum nesting level for stored procedures and triggers. Each increased nesting level requires about 160 bytes of additional memory. For example, if you increase the nesting level from 16 to 26, Adaptive Server requires an additional 1600 bytes of memory.