Viewing Results from the SQL Scripts Page

To view script results from the SQL Scripts page:

1. On the Workspace home page, click SQL Workshop and then SQL Scripts.

   The SQL Scripts page appears.

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

   • On the Tasks list, click Manage Results.

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

   • In Icons view, click the Show Results check box and then 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. See "About the Manage Script Results Page".

3. Click the View icon for the results you want to view. The View icons display on the far right side of page under the heading View Results.

   The Results page appears. See "About the 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 Script field and click Go. To view all results, leave the Script field blank 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.