HP Integrity NonStop J-Series - Manual (Page 106)

Table 32 Execution Results fields
Function Field or button
Indicates when the statement was last evaluated. Last Evaluated
Indicates the time taken to execute the query. Query Execution Time
Displays the executed statement status. The status indicates whether the statement was
executed successfully or whether the statement was canceled. Status
Displays the next set of execution results when the statement execution happens in the page
mode. For more information on the page mode, see
“Page mode” (page 104) .
Next Page
For DML statements such as INSERT, DELETE, and UPDATE, the results indicate how many rows
were affected if the execution is successful. For other SQL commands, the results appear in text
form.
For SELECT statements, you can use the Copy options to copy the results to a file, clipboard, or a
spreadsheet. The copy 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 the page mode, you can copy data
in the current page only.
Table 33 (page 106) describes the tabs.
Table 33 Statement Details tabs
Function Tab
Displays the statement execution error. Execution Error
Displays values set for the current or earlier execution. The Execution Parameters tab
is displayed only if the statement has parameters. Execution Parameters
Displays the statement that was executed with the parameters (if any), replaced with
their values. Executed Statement
For more information on the page mode, see “Page mode” (page 104) .
Related Topic
“Copying data” (page 45)
Term
page mode
Reusing a connection
The reuse connection feature is enabled by default in the SQL Whiteboard. As a result, all queries
executed for the selected system use the same connection. This system appears in the Statement
Pane, under System. To close the connection, right-click the system icon in the left pane and select
Disconnect. As a result, if the SQL Whiteboard is using the same connection, it stops. HP
recommends that you disconnect the system to release system resources.
Loading and saving SQL statements to a file
The SQL Whiteboard provides commands that enable you to import an SQL statement from a text
file to the Statement pane. You can also copy SQL statements from the Statement pane to a specified
text file.
Table 34 (page 107) describes the commands in the File menu that you can use to import and copy
SQL statements.
106 Using the SQL Whiteboard