set option

Description

Changes the values of Interactive SQL options.

Syntax

set [ temporary] option
	[{identifier | string | hostvar}. | public.]
	{identifier | string | hostvar| builtin_date_strings} = [option_value]

set permanent

set

Parameters

temporary: indicates that the options you set are only for this session.

option: indicates that you are setting the subsequent option.

public: indicates that the option is being set for all users.

option_value: is the value of the option you are setting.

identifier: is the identifier you are using for the connection information.

string: is the string you are using for the connection information.

hostvar: is the variable information for the host name and port

builtin_date_strings: is the variable information for bigdatetime and bigtime. The server interprets strings as bigdatetimes.

Usage

set permanent in Syntax 2 saves all current Interactive SQL options. These settings are automatically established every time Interactive SQL is started for the current user ID.
Syntax 3 displays 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.