Display null values as Specify 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 Specify 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 Specify 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 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.
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 the 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. If none exist, then Interactive SQL releases your schema locks; otherwise, Interactive SQL does not release your schema locks. That is, Interactive SQL does not release your schema locks if you have any 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 an arbitrary font, font style, and point size you want to use. Click Browse to select the settings in the Font window.
You can also choose to display the results as a scrollable table by choosing Data » Show Results As Scrollable Table.
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 a text by choosing Data » Show Results As Text.
The following options let you specify which result set(s) are displayed when statements are run.
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 Prints the first result set returned. This is the default.
Show all result sets Prints all result sets. Select this option if you want Interactive SQL to display multiple result sets in the Results pane when you execute a procedure that returns multiple SELECT statements. When running as a windowed application, 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. By default, Interactive SQL does not display multiple result sets.
Alternatively, you can also set the isql_show_multiple_result_sets option to On. See isql_show_multiple_result_sets [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 © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|