Viewing SQL Script Results

Viewing Script Results

To view script results from the SQL Scripts home page:

1. Click the SQL Workshop icon on the Workspace home page.

2. Click the SQL Scripts icon.

   The SQL Scripts page appears.

3. You can access the Manage Script Results page in the following ways:

   • From the Tasks list, select Manage Results.

   • In Details view, click the Results number for the script you want to display.

   • In Icons view, click the appropriate icon. Results icons only appear in the Icons view if you click the Show Results check box.

   The Manage Script Results page appears, listing available results for the script.

4. Click the View icon for the results you want to view. The View icon appears on the far right side of the Manage Script Results page.

About the Manage Script Results Page

On the Manage Script Results page you can:

• Search for a result. Enter a result name or partial name in the Find field and click Go. To view all results, leave the Find field blank, select - All Users - from the User list and click Go. You control how many rows display by making a selection from the Display list.

• Change the Page View. You can change the appearance of the page by making a selection from the View list. Available View options include:

  • Icons displays each result as an icon identified by the script name, and time and date stamp.

  • Details displays each result as a line in a report. Each line includes a check box to enable the selection of results for deletion, the associated script name which is a link enabling it to be loaded into the Script Editor, who ran the script, when the run started, how long it took to run, whether the run is complete or not, the number of statements executed, the size in bytes, and a View icon to view the results.

• Delete a result. In Details view, select the check box associated with each result you want to delete, and click Delete Checked.

• Sort results. In Details view, click a column heading to sort the listed results by that column.

About the Results Page

The Results page displays the script name and status (Complete, Canceled, Executing or Submitted), and lists the statements executed.

On the Results page you can:

• Choose the view. Click the Detail or Summary radio button and click Go to specify whether to display complete or summarized information.

• Choose the number of rows displayed. In Summary view, make a selection from the Display list and click Go to specify the number of rows displayed.

• Sort the statement report. In Summary view, select a column heading to sort the listed values by that column.

• Edit the script. Click Edit Script to load the script into the Script Editor.