Interactive SQL Options

Interactive SQL options change how Interactive SQL interacts with the database.

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

Description

Syntax 1 with the TEMPORARY keyword cannot be used between the BEGIN and END keywords of a compound statement.

Syntax 2 SET PERMANENT stores all current Interactive SQL options in the SYSOPTIONS system table. These settings are automatically established every time Interactive SQL 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 Interactive SQL or the database server, these are displayed; otherwise, the permanent option settings are displayed.