SYSOPTION system table
1024
SYSOPTION system table
Column name Column type
Column
constraint
Table
constraints
user_id UNSIGNED INT NOT NULL Primary key,
foreign key
references
SYSUSERPER
M
"option" CHAR(128) NOT NULL Primary key
"setting" LONG
VARCHAR
NOT NULL
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.
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.