Sybase Adaptive Server Anywhere - SET OPTION Statement [Interactive SQL]

Chapter 9 SQL Statements
615
SET OPTION statement [Interactive SQL]
Use this statement to change the values of Interactive SQL options.
SET [ TEMPORARY ] OPTION
… [
userid . | PUBLIC. ] option-name = [ option-value ]
userid: identifier , string or host-variable
option-name: identifier
, string or host-variable
option-value: host-variable
(indicator allowed), string , identifier , or
number
SET PERMANENT
SET
"Interactive SQL options" on page 167
SET PERMANENT (syntax 2) 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 displays all of the current option settings. If there are temporary
options set for Interactive SQL or the database server, these will be
displayed; otherwise, the permanent option settings are displayed.
Function
Syntax 1
Syntax 2
Syntax 3
See Also
Description