HP Neoview Release 2.4 Software - Manual (Page 119)

Understand Parameter Prompts
SQL statements can be parameterized by embedding parameter names surrounded by $$ (double
dollar signs). When the statement is executed, the SQL Whiteboard prompts you for values for
all parameters in that statement and easily allows you to 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 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.
Cancel a Query From the SQL Whiteboard
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.
NOTE: You can also cancel a query from the Workload Detail dialog box of the System Offender.
See “Cancel a Query From System Offender” (page 108) .
Learn About the 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:
Description Tab
Displays the completion of SELECT statements:
• Last Evaluated shows 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 or failure, processing time, and the
timestamp when the query was executed. If the execution is canceled, the status reflects
the same.
For DML statements such as INSERT, DELETE, or UPDATE, the results show 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 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.
Execution Results
Shows the execution error that is displayed if a statement has an error. The exact error is
returned from ODBC and SQL. Execution Error
Learn About the Statement Details Pane 119