HP Neoview Release 2.5 Software - Manual (Page 211)

19 Use the SQL Whiteboard
About the SQL Whiteboard
The SQL Whiteboard allows you to enter and execute SQL statements from within HPDM and
provides execution information for each of the SQL statements.
The list of SQL statements is persisted between HPDM sessions the same way that system
configuration and favorites are persisted in HPDM. Currently, HPDM supports only one instance
of the SQL Whiteboard.
SQL statements can be parameterized by embedding parameter names surrounded by double
dollar signs ($$). When the statement is executed, the SQL Whiteboard requests the values for
the parameters in the statement and easily allows you to reuse recent values for those parameters.
Related Topics
“Display the SQL Whiteboard” (page 211)
“Save and Import System Definitions” (page 55)
Display the SQL Whiteboard
To display the SQL Whiteboard, use one of these methods:
• Click the SQL Whiteboard button ( ) on the HPDM toolbar.
• From the HPDM main menu, select Tools > SQL Whiteboard.
Related Topics
“Learn About the SQL Whiteboard Panes” (page 211)
“Use the HPDM Toolbar” (page 44)
Learn About the SQL Whiteboard Panes
The SQL Whiteboard contains these panes:
Description Pane
Displays a listing of the SQL statements that you added from the Statement pane. Statement List
Allows 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
About the SQL Whiteboard 211