HP Neoview Release 2.5 Software - Manual (Page 94)

• “Execute or Explain the Selected Query” (page 94) .
• “Enter a New Query” (page 94) or paste in a query from somewhere else, then execute or
explain the selected query.
• Change the schema name with the “Schema Drop Down” (page 94) box.
• Change the “Maximum Rows Fetched” (page 94) .
• “Rename the Query” (page 95) .
• Move to another selected query by using the up and down arrow keys.
The buttons across the bottom of the SQL Text box allow you to test the query and change it.
Description Button
Causes the query to be executed and shows the results in
the Execute Output tab of the Query Details box. Take
note that the plan is not stored; if you want to save the
executed output, you must check and execute it from the
Query List box. [Execute]
Allows you to make changes to the query. Make the
change, then select Update. To save the query, check it
in the Query List box and choose Save. [Update]
Allows you to duplicate a query or add a new query to
the Query List box. When you select Add New, NPA
duplicates the current query in the SQL Text box. To create
a new query, either amend the query or paste in a new
query. The added query shows as an entry at the bottom
of the Query List box. Note that the new query has the
same Statement Label as the query from which it was
duplicated. To change this, double-click the name and
type in a new name. [Add New]
Immediately presents the query execution plan in the
Explain Plan tab of the Query Details box. Take note that
the plan is not stored; if you want to save the plan, you
must check the query and explain it from the Query List
box. [Explain]
Execute or Explain the Selected Query
When queries are loaded into the Query Workbench from the Triage Space, the first selected
query is shown in the SQL Text box. To simply execute or explain the selected query, select the
appropriate button at the bottom of the SQL Text box.
Enter a New Query
You can enter a new query or paste in a query from somewhere else in the SQL Text box. After
you enter the query, you can give it a name in the Name text box above the query field.
Schema Drop Down
If you have unqualified queries (that is, queries without a schema name), you can select the
schema associated with the query by using the drop-down Schema dialog box. Fully qualified
names override the schema setting.
Maximum Rows Fetched
The Max Rows field provides the amount of rows allowed in the workbench. The value -1 returns
all rows.
94 Use the Query Workbench