Cut, copy, paste, undo, and redo, Execute highlighted text, Cancel a query from the sql whiteboard – HP Neoview Release 2.5 Software User Manual
Page 215: Learn about the statement details pane, Cancel a query from the
•
Regardless of whether the number of rows in the result set exceeds the Rows/Page threshold,
if the available virtual memory falls below the internal threshold, the statement execution
goes into page mode and displays the results that have been fetched so far. In this situation,
the grid might display fewer rows than the Rows/Page threshold. This situation continues
until garbage collection kicks in and frees up the memory occupied by the pages that have
been disposed. When system resources are low, the Statement Details pane displays a
message to notify you that execution is entering page mode.
•
Grid sorting works only on the currently displayed page.
•
In page mode, these buttons export data for the current page only:
— [ Data to Clipboard ]
— [ Data to Browser ]
— [ Data to Spreadsheet ]
— [ Data to File ]
•
To free up workstation memory, you can discard the results of the selected statement(s)
cached in the Statement List pane. See
“Learn About the Statement List Pane” (page 212)
.
Cut, Copy, Paste, Undo, and Redo
In the Statement pane, if you right-click the text box, these options are displayed:
Execute Highlighted Text
If you highlight text, you can execute part of a statement.
Cancel a Query From the SQL Whiteboard
Sometimes you need to cancel a running SQL query. It may be that you typed the wrong query,
the query is inefficient, or the query is creating a performance bottleneck and needs to be stopped.
After a query starts executing, the SQL Whiteboard [ Execute ] button changes 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 207)
.
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
Learn About the Statement Details Pane
215