Data Output view

After you run the SQL statements in an SQL scrapbook page, the results are shown in the Data Output view.

The Data Output 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 - contains the name of the tool in which you run the statements (SQL editor).
The top row of the table contains the information for the most recent run.
The right part of the Data Output view contains three pages:
  • Messages - shows any messages that were generated while the statements in the SQL scrapbook page were being run. If there are errors in an 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 modifying the SQL scrapbook page in the SQL editor, 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 can be modified.

  • Parameters - shows any parameters that were passed to the statement. You cannot pass parameters to SQL statements when you run the statements in the SQL editor.
  • 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.
Related tasks
Running SQL statements in SQL scrapbook pages