Displaying Currently Set Switches with sysoptions

Adaptive Server version 15.7 adds the number column to the sysoptions table, which contains the switch ID for currently set switches.

sysoptions shows these switches:

Trace flags set in the runserver file with the -T flag
Trace flags set with dbcc traceon(flag_number) or set switch serverwide on
Trace flags and switches set for a specific system process ID (spid) with set switch on

sysoptions shows only the switches that are visible to the user. That is, users cannot see switches set privately by other spids. The value for number is Null for all option categories other than switches.