Interactive SQL options

Use the SET OPTION statement to change the values of the following Interactive SQL options. See SET OPTION statement [Interactive SQL].

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

Discuss this page in DocCommentXchange.