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

A Using the SQL Whiteboard
This appendix discusses the following topics:
•
“Introduction to the SQL Whiteboard” (page 98)
•
“Viewing the SQL Whiteboard” (page 98)
•
“SQL Whiteboard panes” (page 98)
•
“Statement List pane” (page 99)
•
“Statement pane” (page 100)
•
“Statement Details pane” (page 102)
•
“Reusing a connection ” (page 103)
•
“Loading and saving SQL statements to a file” (page 103)
•
“Highlighting the SQL syntax” (page 104)
•
“Managing the layout of panes” (page 104)
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 98)
“Saving and importing system definitions” (page 45)
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 98)
“Using the MXDM toolbar” (page 29)
SQL Whiteboard panes
Table 28 (page 98) 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 38 (page 99) shows the SQL Whiteboard.
98 Using the SQL Whiteboard