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. |