max nesting level

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, SAP ASE requires an additional 1600 bytes of memory.

Summary Information

Default value

50

Range of values

16 – 100

Status

Static

Display level

Comprehensive

Required role

System administrator

Configuration group

User environment

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