HP Neoview Release 2.5 Software - Manual (Page 216)

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 SELECT statements:
Function Field or Button
Shows when the statement was last evaluated. Last Evaluated
Specifies the elapsed time in seconds. Time Elapsed
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. Status
Displays the next set of execution results when statement execution is displayed in page
mode. For more information about page mode, see
“Understand Page Mode” (page 214) .
[ Next Page ]
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. Also, when in page mode,
only the data for the current page can be exported. For more information about page mode, see
“Understand Page Mode” (page 214) .
Function Tab
Shows the execution error that is displayed if a statement has an error. The exact
error is returned from ODBC and SQL. Execution Error
This tab is present if the statement has parameters and shows the values chosen for
the current or earlier execution. Execution Parameters
Displays the statement that was executed with the parameters (if any), replaced
with their values. Executed Statement
Related Topics
“Export Data” (page 53)
Terms
page mode
Reuse a Connection
The reuse connection feature is enabled by default in the SQL Whiteboard. This means that 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 in a single session using
the same connection. A good example is when you are using volatile tables. You create the volatile
table first and then run queries on it. The volatile table is available only until the session ends.
Load and Save SQL Statements to a File
The SQL Whiteboard provides commands that allow you to import SQL statements from a text
file into the Statement pane. You can also export SQL statements from the Statement pane into
216 Use the SQL Whiteboard