Display null values as Specifies how you want nulls 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 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 if you want Interactive SQL to automatically regenerate the result set after you execute an INSERT, UPDATE, or DELETE statement. This is on by default.
Show row number Select this option if you want row numbers to appear beside your result set in the Results pane. This is set 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 that is used for table data in the Interactive SQL 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 you want to use.
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.
Show results from the last statement Prints the result set from the last statement. This is the default.
Show results from each statement Prints the result set for each statement.
Show only the first result set This option does not apply to UltraLite databases. Prints the first result set returned. This is the default.
Show all result sets This option does not apply to UltraLite databases. Prints all result sets. Select this option if you want Interactive SQL to display multiple result sets in the Results pane. When this option is selected, each result set appears on a separate tab in the Results pane. 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 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.
Select Show All Result Sets.
If Interactive SQL runs out of memory, it reports the problem but does not display the result set.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|