set option

Description

Changes the values of Interactive SQL options.

Syntax

Syntax 1

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

Syntax 2

set permanent

Syntax 3

set

Parameters

temporary

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

option

indicates that you are setting the subsequent option.

user_id

is ID of the user setting the option.

public

indicates that the option is being set for all users.

option_name

is the name of the option you are setting.

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

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.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF