Display Window
|
Select a window display style:
-
Single Window — display execution results in a single window, with
status details at the end. For a single statement with multiple results,
display result sets one after another in the same window.
-
Multiple Windows — display execution
status and each result for the current statement in a separate window.
|
Display Mode
|
Select a results display mode:
-
Text Mode — similar to iSQL output when in
single-tab mode.
-
Grid Mode — similar to the Interactive SQL
window.
|
Show Column Headings
|
Show column headings in the results view.
|
Show Row Number
|
Show row numbers in results view.
-
In text mode, this property
is always enabled.
-
In grid mode, this property is selected by default.
|
Show Row Count Message
|
Show number of rows affected.
-
In text mode, this property is
always enabled. Row count appears at the end of the results.
-
In grid mode, this property is selected by default. Row count appears in the Status window.
|
Max Row Count
|
Enter the number of rows to retrieve from the result set. The default is 0
(retrieve all rows).
Set a maximum to improve performance when testing queries
and to avoid running out of memory when retrieving data from very large tables,
for example, tables with a hundred million rows.
|
Max Display Row Count
|
Enter number of rows to display in the results view.
To see all results, set
Maximum Rows to Retrieve to 0, and
then save to a file.
|
Display Null Value As
|
Enter characters to display when the value is NULL.
Default is NULL.
|
Split All Messages Into Multiple Message Tabs
|
Split messages among more than one
tab.
|
Limit Tabs Number to
|
If you selected
Multiple Windows for the
Display Window preference, enter a
maximum number of tabs.
|
Limit Visible Tables Number to
|
If you selected
Single Window for the
Display Window preference, enter a
maximum number of visible tables.
|