SET OPTION Statement [Interactive SQL]

Go to Parameters

Go to Usage

Go to Permissions

Syntax

Syntax 1

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

Syntax 2

SET PERMANENT

Syntax 3

SET

Parameters

(back to top)

• userid – identifier, string, or host-variable

• option-name – identifier, string, or host-variable

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

Usage

(back to top)

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

Permissions

(back to top)

No specific system privileges are required to set your own options.

The SET ANY PUBLIC OPTION system privilege is required to set database options for another user.

The SET ANY SYSTEM OPTION system privilege is required to set a SYSTEM option for the PUBLIC user ID.

The SET ANY SECURITY OPTION system privilege is required to set a SECURITY option for the PUBLIC user ID.