HP Neoview Release 2.5 Software - Manual (Page 226)

1. At the top of the dialog box, select a schema from the Schema drop-down menu. The SQL
Designer populates the Tables/Views field based on the schema that you select.
2. At the bottom of the dialog box, double-click any of the following individual elements in
addition to using the keyboard to add text in the Query box in the middle of the dialog box:
• SQL Statements
• Tables/Views
• Columns
• Functions
NOTE: The SQL Statements and Functions menus are drop-down menus. Changing the
menu value changes the choices presented in the box under the menu. The menu items are:
Functions SQL Statements
Numeric Functions CQD Statements
String Functions DDL Statements
System Functions DML Statements
Time/Date Functions Transaction Statements
The SQL Designer might provide SQL statements and functions that are not supported for
customer use. If you are not sure about a supported statement or function, check the Neoview
SQL Reference Manual, which documents all supported statements and functions.
3. When you have completed building the SQL statement, click [ OK ] to insert the query into
the SQL input area.
Related Topics
“Add Parameters to Statements” (page 226)
“Use the Metric Miner Toolbar” (page 222)
“Run a SQL Statement Using Metric Miner” (page 225)
“Resources on the Web” (page 17)
Add Parameters to Statements
You can embed parameters in a SQL statement by inserting a parameter name surrounded by
$$ (double dollar signs). For example, this statement causes Metric Miner to prompt you for a
Table Name before executing the statement.
select * from $$Table Name$$
The resulting parameter prompt is:
This statement causes Metric Miner to prompt you for several parameters, including a time range,
which is enabled by using both the $$__FROM_TIME$$ and $$__TO_TIME$$ parameters in
the same query:
SELECT [first $$Number Of Stmts_to Return$$]
cast( (QUERY_END_DATETIME - QUERY_START_DATETIME)/60 as dec(12,2)) as Elapsed_Min,
left(sql_text,40) as Abrev_Sql_Text,
226 Use Metric Miner