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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Administering Your Database » SQL Anywhere graphical administration tools » Using Interactive SQL


Interactive SQL options

Syntax 1
SET [ TEMPORARY ] OPTION option-name = [ option-value ]
option-name: identifier or string
option-value:  string, identifier, or number
Syntax 2
Syntax 3

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.

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_allow_read_client_file option [Interactive SQL]
isql_allow_write_client_file 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_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]