To give you the ability to easily view optimizer settings, Adaptive Server version 15.0.2 introduces a new fake table and a new stored procedure.
sysoptions is the new fake table. It stores information about each set option, its category, it’s current and default settings. sysoptions also contains a bit map containing further detailed information about the option.
sp_options is a new stored procedure used to show option values.
