HP Neoview Release 2.4 Software - Manual (Page 59)

5 Using 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 that statement and allows you to easily reuse recent values for those parameters.
SQL Whiteboard Area
To access the SQL Whiteboard, select the Tools->SQL Whiteboard in HPDM.
SQL Whiteboard At a Glance
The SQL Whiteboard contains several panes:
• Statement List pane displays a listing of the SQL statements that you added from the
statement .
• Statement pane allows you to enter any DML or DDL statement including SELECT, INSERT,
UPDATE, DELETE, CREATE, ALTER, GRANT, DROP, and REVOKE, and so on.
• Statement Details pane displays detailed information about the execution results (located
on the bottom half of the display.
SQL Whiteboard Area 59