HP Neoview Release 2.4 Software - Manual (Page 61)

all parameters in that statement and allows you to easily re-use recent values for those parameters.
The feature is compatible with Neoview Reports.
Cut, Copy, Paste, Undo, and Redo
In the Statement pane, if you right-click on the text box these options are displayed: cut, copy,
paste, undo, redo, and select all.
Execute Highlighted Text
If you highlight text, you can execute part of a statement.
Cancelling an SQL Query
There may be times when you want to cancel a running SQL query. It may be that you typed in
the wrong query or the query is inefficient or the query is creating a performance bottle neck
and needs to be killed.
After a query starts executing, the SQL Whiteboard [Execute] button switches its' state to [Cancel].
Pressing [Cancel] terminates the SQL query.
Statement Details Pane
The Statement Details pane contains statistics and details propagated from the selected statement
in the Statement List pane. This is informational and has no interactive functionality. Statistics
are shown only for statements that are loaded from the Statement pane. The values in the
Statement Details pane are:
The Execution Results tab displays the completion of a SELECT statements:
• Last Evaluated — displays when the statement was last evaluated.
• Time Elapsed — specifies the elapsed time in seconds.
• Status — displays the executed statement status. The Execution Results indicate the progress
of the statement execution and the number of rows fetched so far. Once the statement has
completed execution, it displays the status of success/failure, processing time, and the
timestamp when the query was executed. If the execution is cancelled, the status reflects the
same.
For DML statements such as INSERT, DELETE, or UPDATE, the results display how many rows
were affected if the execution is successful. For other SQL commands, the results are displayed
in text form.
For SELECT statements, you can use the Export options to export the results to a file, clipboard,
or spreadsheet. The export options supported are: Data to Clipboard, Data to Browser, Data to
Spreadsheet, and Data to File. The data is preserved only while the SQL Whiteboard remains
open. The data is flushed when the SQL Whiteboard is closed.
The Execution Error tab shows the execution error displayed if a statement has an error. The
exact error is returned from ODBC and SQL.
The Execution Parameters tab is present if the statement has parameters and shows the values
chosen for the current or earlier execution.
Executed Statement tab—displays the statement that was executed with the parameters (if any),
replaced with their values.
Reusing a Connection
The reuse connection feature is enabled by default in the SQL Whiteboard. This means any query
executed for the selected system, uses the same connection, unless explicitly closed. Use [Close]
to explicitly close the connection. You may want to close the connection to free up system
resources. The reuse connection feature allows you to execute a series of statements executed in
Statement Details Pane 61