The Display area of the Results tab has these components:
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.
Maximum number of rows to display Specify the maximum number of rows that can appear in the Results pane. The default is 500.
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.
The Style area of the Results tab has these components:
Scrollable table 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 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 to display row numbers beside your result set in the Results pane. By default, this option is selected.
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 release the locks created 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 the font, font style, and point size you want to use. Click Browse to select the settings in the Font window
Text Display the result set as text using a monospaced font. The result set is not editable in this format.
The Results Processing area of the Results tab has these components:
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 to display multiple result sets in the Results pane when you execute a procedure that returns multiple SELECT statements. When you are running in windowed mode, each result set appears on a separate tab in the Results pane. The setting of this option also applies when you are running Interactive SQL as a command line program. By default, Interactive SQL does not display multiple result sets.
Interactive SQL may run out of memory when displaying
large result sets, 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 Results Sets
If Interactive SQL runs out of memory, it reports the problem but does not display the result set.
