Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL

Interactive SQL keyboard shortcuts Next Page

Interactive SQL options


Syntax 1

SET [ TEMPORARY ] OPTION option-name = [ option-value ]

Syntax 2

SET PERMANENT

Syntax 3

SET

Parameters

userid: identifier or string

option-name: identifier or string

option-value: string, identifier, or number

Description

Syntax 1 stores the specified Interactive SQL option.

Syntax 2 stores all current Interactive SQL options.

Syntax 3 displays all of the current option settings.

Interactive SQL option settings are stored on the client computer. They are not stored in the database.

Note

The syntax SET [ TEMPORARY ] OPTION [ userid | PUBLIC. ]option-name is deprecated. If you specify this syntax, the userid or PUBLIC keyword is ignored.

Option Values Default
auto_commit option [Interactive SQL] On, Off Off
auto_refetch option [Interactive SQL] On, Off On
bell option [Interactive SQL] On, Off On
command_delimiter option [Interactive SQL] String ' ; '
commit_on_exit option [Interactive SQL] On, Off On
default_isql_encoding option [Interactive SQL] String Empty string
echo option [Interactive SQL] On, Off On
input_format option [Interactive SQL] ASCII, DBASE, DBASEII, DBASEIII, EXCEL, FIXED, FOXPRO, LOTUS ASCII
isql_command_timing option [Interactive SQL] On, Off On
isql_escape_character option [Interactive SQL] Character ' \ '
isql_field_separator option [Interactive SQL] String ' , '
isql_maximum_displayed_rows option [Interactive SQL] All or a non-negative integer 500
isql_plan option [Interactive SQL] Short, Long, GraphicalLowDetail, GraphicalHighDetail Graphical
isql_print_result_set option [Interactive SQL] Last, All, None Last
isql_quote option [Interactive SQL] String '
isql_show_multiple_result_sets [Interactive SQL] On, Off Off
nulls option [Interactive SQL] String '(NULL)'
on_error option [Interactive SQL] Stop, Continue, Prompt, Exit, Notify_Continue, Notify_Stop, Notify_Exit Prompt
output_format option [Interactive SQL] ASCII, DBASEII, DBASEIII, EXCEL, FIXED, FOXPRO, HTML, LOTUS, SQL, XML ASCII
output_length option [Interactive SQL] Integer 0
output_nulls option [Interactive SQL] String Empty string
truncation_length option [Interactive SQL] Integer 256
See also

auto_commit option [Interactive SQL]
auto_refetch option [Interactive SQL]
bell option [Interactive SQL]
command_delimiter option [Interactive SQL]
commit_on_exit option [Interactive SQL]
default_isql_encoding option [Interactive SQL]
echo option [Interactive SQL]
input_format option [Interactive SQL]
isql_command_timing option [Interactive SQL]
isql_escape_character option [Interactive SQL]
isql_field_separator option [Interactive SQL]
isql_maximum_displayed_rows option [Interactive SQL]
isql_plan option [Interactive SQL]
isql_print_result_set option [Interactive SQL]
isql_quote option [Interactive SQL]
isql_show_multiple_result_sets [Interactive SQL]
nulls option [Interactive SQL]
on_error option [Interactive SQL]
output_format option [Interactive SQL]
output_length option [Interactive SQL]
output_nulls option [Interactive SQL]
truncation_length option [Interactive SQL]