After you run an SQL statement, the results are shown in
the SQL Results view.
The SQL Results view is divided into two parts. The left
part contains a read-only table with these columns:
- Status
- Indicates the state of the associated action.
- Operation
- Indicates the operation performed.
- Date
- Indicates the date the operation was performed.
- Connection profile
- Lists the connection profile of the data source where the operation
was performed
The top row of the table contains the information for
the most recent run.
The right part of the SQL Results view
contains the following pages depending on the operations performed:
- Status
- Shows any messages that were generated while the statement was
being run. If there are errors in the SQL statement, an error message
appears on this page. The SQL source of the statement that is being
run is shown in this view also. Refer to your database product's SQL
documentation to check the validity of the structure of the SQL statement.
Edit the statement by making the changes in the SQL Query Builder
or SQL and XQuery editor as necessary, and then run the statement
again.
For INSERT, UPDATE, and DELETE statements, a message is
displayed on this page if the statement runs successfully. If an INSERT,
UPDATE, or DELETE statement runs successfully, the database is modified.
- Parameters
- Shows any parameters that were passed to the statement. The name
of each parameter and its input value is listed. This page contains
values only if host variables are defined for the statement.
- Results
- Contains any results that were generated from running the statement
(for example, a table of sales data). The Results page is selected
by default.
- Profiling Data
- Contains database performance data for SQL statements when you
run a routine and gather database performance data. From this page,
you can right-click an SQL statement to tune it.
- Compare Results
- Contains a summary of the comparison between the output of the
routine and the routine baseline output. If the results differ, you
can right-click to see the differences in the Compare editor.