HP Neoview Release 2.4 Software - Manual (Page 117)

10 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
“Save and Import System Definitions” (page 39)
Display the SQL Whiteboard
To display the SQL Whiteboard, select Tools > SQL Whiteboard.
Learn About the SQL Whiteboard Panes
The SQL Whiteboard contains several 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 117