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 a long-running instance.
	Remove Result	Remove the status, result sets, and messages of a selected SQL result instance.
	Remove All Visible Results	Remove all results for completed statements from the SQL Results view.
	Display the Result in Text Mode	Toggle between text mode and grid mode.
	Display the Result in Single Tab	Toggle between single-tab and multitab display.
	Filter Results	Filter the SQL results.