SQL Results view

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 three columns:

Status
Indicates the state of the associated action.
Action
Indicates what kind of action occurred.
Object Name
Can contain the name of the statement or the tool in which you run the statement.

The top row of the table contains the information for the most recent run.

The right part of the SQL Results view contains three pages:

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




© Copyright IBM Corporation 2010, 2017.