CREATE TABLE SYS.SYSOPTION ( user_id UNSIGNED INT NOT NULL, "option" CHAR(128) NOT NULL, "setting" LONG VARCHAR NOT NULL, PRIMARY KEY ( user_id, "option" ), FOREIGN KEY REFERENCES SYS.SYSUSERPERM )
Options settings are stored in the SYSOPTION table by the SET command. Each user can have their own setting for each option. In addition, settings for the PUBLIC user ID define the default settings to be used for user IDs that do not have their own setting.
If you try to query the option column
of this table in a case-sensitive database, you must match case
of the option. For example, the MAIN_CACHE_MEMORY_MB
option is stored in SYSOPTION as Main_Cache_Memory_MB.
You can run a select * from the SYSOPTION
table to see the exact case of the option.
user_id The user number to whom this option setting applies.
“option” The name of the option.
“setting” The current setting for the named option.
If you incorrectly type the name of an option when you are setting the option, the incorrect name is saved in the SYSOPTION table. You can remove the incorrectly typed name from the SYSOPTION table by setting the option PUBLIC with an equality after the option name and no value:
SET OPTION PUBLIC.a_mistyped_name=;
