SET OPTION Statement [Interactive SQL]
Changes Interactive SQL (dbisql) options.
Syntax 1
SET [ TEMPORARY ] OPTION … [ <userid>. | PUBLIC.]<option-name> = [ <option-value> ]
Syntax 2
SET PERMANENT
Syntax 3
SETSET PERMANENT (Syntax 2) stores all current dbisql options in the SYSOPTION system table. These settings are automatically established every time dbisql is started for the current user ID.
Syntax 3 shows all current option settings. If there are temporary options set for dbisql or the database server, these are shown; otherwise, permanent option settings are shown.
If you incorrectly enter 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 enterd 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=;