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

SQL Results view displays the results of executing SQL statements, running procedural routine objects, and creating database objects.

SQL Results view appears in the Database Development perspective and consists of a history frame and a details frame. The history frame displays the execution history for past queries. The details frame displays the status and results of the last execution. Use the view pull-down menu to filter history results and set preferences.

Table 1. SQL Results History fields
Field Description
Status Displays whether the operation failed, succeeded, terminated, or is still running.
Operation Displays the SQL statement or object that was executed.
Frequency Displays the number of times the SQL statement or object has been executed.
Date Displays the date and time the SQL statement or object failed, completed execution, terminated, or reached a breakpoint.
Action Type Displays the type of SQL action performed.
Consumer Name Displays the interface component from which the SQL action was initiated.
Connection Profile Displays the connection profile on which the SQL was executed.

To save SQL results, right-click in the history pane, and select Save History.

When you execute multiple queries in a SQL file containing a delimiter (such as go) using the Execute All or Execute Selected Text options, the results are grouped in a tree structure in the SQL Results view. The root node is a top-level result history. Expand this node in the SQL Results view to see the results for each individual SQL statement.

Right-click the root node of the group SQL statement and select Save History to save all the resultsets from one group execution of a set of SQL queries.

There are two modes for the details frame, single-tab and multitab:
  • In single-tab mode, all results and messages appear in the same column, with messages and status at the end.
  • In multitab mode, each result and message is in a separate tab.
Table 2. Text View context menu options
Option Description
Find/Replace Search for and replace specific text in the result set. This replaces the data of the displayed result set only. It does not replace the data on the server.
Note: Find/Replace is enabled only when results are displayed in text mode.
Save Results Save All Results or Save Current Results to a project.
Export Results Export All Results or Export Current Results to save the result set to a file outside of any project for use with other applications.
Print Results Print All Results or Print Current Results to send the SQL results to a printer.
Table 3. SQL Results tabs for multi-tab mode
Tab Description
Status Shows the interim status of running the routine procedural object or selected text.
Parameters For a routine procedural object, displays the input and output parameter names, datatypes, values, and parameter types (IN, OUT, or IN/OUT).
Result n Displays results for a SQL query in the routine procedural object, SQL file, or selected statement.
Message n Contains messages from the database server, such as the output of a SQL print statement.
Table 4. SQL Results buttons
Icon Name Action
Terminate Result 
						  Terminate Result Terminate a long-running instance.
Remove Result 
						  Remove Result Remove the status, result sets, and messages of a selected SQL result instance.
Remove All Finished Results 
						  Remove All Visible Results Remove all results for completed statements from the SQL Results view.
Display Result as Text 
						  Display the Result in Text Mode Toggle between text mode and grid mode.
Display Result in single tab 
						  Display the Result in Single Tab Toggle between single-tab and multitab display.
filter results Filter Results Filter the SQL results.

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