Interactive SQL options

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

option-name: identifier or string

option-value:  string, identifier, or number

SET PERMANENT

SET

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.

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]	TEXT, FIXED	TEXT
isql_allow_read_client_file option [Interactive SQL]	On, Off, Prompt	Prompt
isql_allow_write_client_file option [Interactive SQL]	On, Off, Prompt	Prompt
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_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]	TEXT, FIXED, HTML, SQL, XML	TEXT
output_length option [Interactive SQL]	Integer	0
output_nulls option [Interactive SQL]	String	Empty string
truncation_length option [Interactive SQL]	Integer	256