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

A Using the SQL Whiteboard
This appendix discusses the following topics:
•
“Introduction to the SQL Whiteboard” (page 101)
•
“Viewing the SQL Whiteboard” (page 101)
•
“SQL Whiteboard panes” (page 101)
•
“Statement List pane” (page 102)
•
“Statement pane” (page 103)
•
“Statement Details pane” (page 105)
•
“Reusing a connection ” (page 106)
•
“Loading and saving SQL statements to a file” (page 106)
•
“Highlighting the SQL syntax” (page 107)
•
“Managing the layout of panes” (page 107)
Introduction to the SQL Whiteboard
The SQL Whiteboard enables you to enter and execute SQL statements using MXDM, and provides
execution information for each of the SQL statements.
The list of SQL statements of one MXDM session persists in other MXDM sessions. Currently, MXDM
supports only one instance of the SQL Whiteboard.
You can specify SQL statements with parameters by enclosing parameter names within a double
dollar sign ($$). When the statement is executed, the SQL Whiteboard obtains values for the
parameters in the statement. You can reuse recently used values for those parameters.
Related Topics
“Viewing the SQL Whiteboard” (page 101)
“Saving and importing system definitions” (page 46)
Viewing the SQL Whiteboard
To view the SQL Whiteboard, use one of the following methods:
•
On the MXDM toolbar, click SQL Whiteboard ( ).
•
Select Tools
→SQL Whiteboard.
Related Topics
“SQL Whiteboard panes” (page 101)
“Using the MXDM toolbar” (page 30)
SQL Whiteboard panes
Table 28 (page 101) describes the panes in the SQL Whiteboard.
Table 28 SQL Whiteboard panes
Description Pane
Displays a list of the SQL statements that you added using the Statement pane. Statement List
Enables you to enter any DML or DDL statement, including SELECT, INSERT, UPDATE, DELETE,
CREATE, ALTER, GRANT, DROP, REVOKE, and so on. Statement
Displays detailed information about the execution results. Statement Details
Figure 39 (page 102) shows the SQL Whiteboard.
Introduction to the SQL Whiteboard 101