Sybase Adaptive Server Anywhere - Interactive SQL Options

Chapter 5 Database Options
167
Interactive SQL options
SET [ TEMPORARY ] OPTION
... [
userid . | PUBLIC. ] option-name = [ option-value ]
SET PERMANENT
SET
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 (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 is used to display all of the current option settings. If any options
have temporary settings for Interactive SQL or the database server, these are
displayed; otherwise, the permanent option settings are displayed.
OPTION VALUES DEFAULT
"AUTO_COMMIT option" on
page 173
ON, OFF OFF
"AUTO_REFETCH option" on
page 173
ON, OFF ON
"BELL option" on page 174 ON, OFF ON
"CHAR_OEM_TRANSLATION
option" on page 176
ON, OFF, DETECT DETECT
"COMMAND_DELIMITER option"
on page 178
String ’ ; ’
"COMMIT_ON_EXIT option" on
page 178
ON, OFF ON
"DESCRIBE_JAVA_FORMAT
option" on page 185
Varchar, binary Varchar
"ECHO option" on page 186 ON, OFF ON
"HEADINGS option" on page 189 ON, OFF ON
"INPUT_FORMAT option" on
page 189
ASCII DBASE
DBASEII DBASEIII
FIXED FOXPRO
LOTUS
ASCII
"ISQL_COMMAND_TIMING ON, OFF, YES, NO, 1, 0 ON
Syntax 1
Syntax 2
Syntax 3
Parameters
Description