Chapter 3: New Features in Adaptive Server 12.5.2 and 12.5.3

New and changed set command options

Table 3-9 summarizes the new and changed options for the set command.

**Table 3-9: New and changed set command options**
set option	Description
statement cache	enables or disables the statement cache at the session level. If the statement cache is configured at the server level, by default it is enabled at the session level
set proxy...restricted role	Allows you to restrict which roles cannot be acquired when switching identities