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

Figure 39 SQL Whiteboard
Related Topics
“Statement List pane” (page 102)
“Statement pane” (page 103)
“Statement Details pane” (page 105)
Statement List pane
The Statement List pane provides a list of SQL statements that you added in the current session or
earlier sessions of the SQL Whiteboard tool. The list of SQL statements in one MXDM session
persists in other MXDM sessions similar to how connection information and
favorites persist.
From the Statement List pane, you can perform the following tasks:
•
View the name and statement that was previously added in the Statement pane. Optionally,
you can explicitly add a statement to the statement list without executing it.
•
Update an existing statement in the list.
•
Execute a statement.
•
Sort the statements based on the statement name or statement text.
Table 29 (page 102) describes the options at the top of the Statement List pane. These options
enable you to select the statements that you want to execute.
Table 29 Statement List pane options
Function Button
Selects all statements in the Statement List pane. All
Clears all statements in the Statement List pane. None
Removes the results only or the selected statements and the results. You cannot remove
statements alone. Discard
NOTE: You cannot discard a statement or the results while the statement is executing. If a
currently executing statement is part of a Discard selection, it is omitted.
Use Discard when you want to free virtual memory or when MXDM indicates that system
resources are running low. Until you exit the SQL Whiteboard, the result of every executed
statement is cached. If you have already executed several large statements in the current
session, the results are cached in memory. Therefore, less memory is available for new
executions.
“Page mode” (page 104) describes how the SQL Whiteboard caches and displays
large result sets.
102 Using the SQL Whiteboard