iAnywhere.com - Interactive SQL options

SQL Anywhere® Server - Database Administration > SQL Anywhere Administration Tools > Interactive SQL

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