Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Eclipse Data Tools Platform Guide
Previous Page Home Next Page


SQL Results View Options Preferences

The SQL Results view preferences determine the behavior of the SQL Results view.

Table 1. SQL Results view options
Field Explanation
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.
Table 2. SQL Results view options: Sybase_ASE
Field Explanation
Text Image Size Specify the maximum size in bytes of text, unitext, or image data returned.

 
 
  Published under the terms of the Eclipse Public License Version 1.0 ("EPL") Design by Interspire