HP Neoview Release 2.4 Software - Manual (Page 77)

buttons below the Query List as described in Query List . Checked queries are stored internally
for fast retrieval. You can saved checked queries.
For example, if you check three queries in the Query List, the SQL statement for the first query
will show in the SQL Text frame. You can view the SQL for each query by clicking on the query
in the Query List.
SQL Text
The SQL Text frame contains the SQL statement for the query selected in the Query List. In the
SQL Text frame, you can:
• Execute or Explain the Selected Query .
• Enter a New Query or paste in a query from somewhere else, then execute or explain the
selected query.
• Change the schema name with the Schema Drop Down box.
• Change the Maximum Rows Fetched .
• Rename the Query .
• Move to another selected query by using the up and down arrow keys.
The buttons across the bottom of the SQL Text frame allow you to test the query and change it.
• Execute causes the query to be executed and shows the results in the Execute Output tab
of the Query Details frame. 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.
• Update allows you to make changes to the query. Make the change, then select Update.
You can save the query by checking it in the Query List and choosing Save.
• Add New allows you to duplicate a query or add a new query to the Query List. When you
select Add New, NPA duplicates the current query in the SQL Text frame. 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. Note that the new query has the same Statement Label as
the query from which it was duplicated. You can change this by double-clicking the name
and typing in a new name.
• Explain immediately presents the query execution plan in the Explain Plan tab of the Query
Details frame. 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.
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 frame. To simply execute or explain the selected query, choose
the appropriate button at the bottom of the SQL Text frame.
Enter a New Query
You can enter a new query or paste in a query from somewhere else in the SQL Text frame. After
you enter the query, you can give it a name in the Name 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 drop-down setting.
Maximum Rows Fetched
The Max Rows field provides the amount of rows allowed in the workbench. The value -1 returns
all rows.
SQL Text 77