Add parameters to statements – HP Neoview Release 2.5 Software User Manual

Page 226

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.

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.

When you have completed building the SQL statement, click [ OK ] to insert the query into
the SQL input area.

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