SET OPTION Statement [Interactive SQL]

Syntax

Syntax 1

SET [ TEMPORARY ] OPTION
… [ userid. | PUBLIC.]option-name = [ option-value ]

Syntax 2

SET PERMANENT

Syntax 3

SET

Parameters

• userid: – identifier, string, or host-variable
• option-name: – identifier, string, or host-variable
• option-value: – host-variable (indicator allowed), string, identifier, or number

Usage

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=;