![SET SQLCA statement [ESQL]](arrow-right.gif){kind=icon}
Changes dbisql options.
Syntax 1
SET [ TEMPORARY ] OPTION … [ userid. | PUBLIC.]option-name = [ option-value ]
Syntax 2
SET PERMANENT
Syntax 3
SET
identifier, string or host-variable
identifier, string, or host-variable
host-variable (indicator allowed), string, identifier, or number
SET 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 is used to display all of the current option settings. If there are temporary options set for dbisql or the database server, these display; otherwise, permanent option settings are displayed.
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=;
