set option

Description

Use this statement to change the values of Interactive SQL options.

Syntax

Syntax one

set isql [temporary | permanent] option_name
[ user_id. | public. ]option_name = [ option_value ]
user_id : identifier , string or hostvar
option_name : identifier , string or hostvar

Syntax two

set permanent

Syntax three

set

Parameters

temporary – indicates that the options you set are only for this session.
permanent – indicates that you are setting the options permanently.
option – indicates that you are setting the subsequent option. See “SQL Statements” in the SQL Anywhere Reference Manual.
user_id – ID of the user setting the option.
public – indicates that the option is being set for all users.
option_name – name of the option you are setting.
option_value – the value of the option you are setting.
identifier – the identifier you are using for the connection information.
string – the string you are using for the connection information.
hostvar – variable information for the host name and port.

Usage

set permanent (Syntax two) saves all current Interactive SQL options. These settings are automatically established every time Interactive SQL is started for the current user ID.
Syntax three 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.