In Adaptive Server 15.0.3 and later, the maximum nesting level has been increased to 100.
Summary information |
|
---|---|
Default value |
50 |
Range of values |
16 – 100 |
Status |
Static |
Display level |
Comprehensive |
Required role |
system administrator |
Configuration group |
User environment |
The maximum nesting level parameter 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.