Display null values as Specifies how you want NULL values to appear in table columns. You can use any string for this value. The default value is (NULL). If this field is blank, NULL values appear as an empty string. See nulls option [Interactive SQL].
Maximum number of rows to display Specifies the maximum number of rows that can appear in the Results pane. The default is 500. See isql_maximum_displayed_rows option [Interactive SQL].
Truncation length Specifies the number of characters that can appear in each column in the Results pane. If you specify a value of 0, the columns are not truncated. The default value is 256. See truncation_length option [Interactive SQL].
Scrollable table Select this option to display the result set in a scrollable table. You can edit the result set in this format. This option is the default. You can also choose to display the results as a scrollable table by choosing Data » Show Results As Scrollable Table.
The following options are enabled when you select Scrollable table.
Automatically refetch results Select this option to automatically regenerate the result set after you execute an INSERT, UPDATE, or DELETE statement. This option is selected by default.
Show row number Select this option to display row numbers beside your result set in the Results pane. This option is selected by default.
Disable editing Select this option to make result sets read-only. This option applies to result sets of queries that you execute after selecting this option.
Automatically release database locks Select this option to have Interactive SQL attempt to release the locks it creates during your transaction.
When this option is selected, after you execute a statement that returns a result set, Interactive SQL checks if your connection has any uncommitted changes in the database. Interactive SQL only releases your schema locks if there are no uncommitted changes to the database.
Font Select one of the following options to specify the font to use for the table data in the Results pane:
System font Select this option to use the computer's normal text font. This is the default.
Editor font Select this option to use the same font as the SQL Statements pane.
Custom font Select this option to specify the font, font style, and point size.
Text Select this option to display the result set as text using a monospaced font. The result set is not editable in this format.
You can also choose to display the results as text by choosing Data » Show Results As Text.
When executing batches
Show results from the last statement Prints the result set from the last statement. This option is the default.
Show results from each statement Prints the result set for each statement.
For statements that return multiple result sets These options only apply to SQL Anywhere databases:
Show only the first result set This option does not apply to UltraLite databases. Prints the first result set returned. This option is the default.
Show all result sets This option does not apply to UltraLite databases. Prints all result sets. Multiple result sets appear in separate tabs. The setting of this option also applies when running Interactive SQL as a command line program.
Alternatively, you can also set the isql_show_multiple_result_sets option to On. See isql_show_multiple_result_sets option [Interactive SQL].
Interactive SQL can run out of memory when displaying very large result sets. This problem may occur if you do any of the following:
Set the Maximum Number of Rows to Display option to All Rows.
Select Show Results From Each Statement.
If Interactive SQL runs out of memory, it reports the problem but does not display the result set.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|