Hp Neoview Release 2.5 Software Bedienungsanleitung PDF herunterladen (Seite 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:

FunctionsSQL Statements

Numeric FunctionsCQD Statements

String FunctionsDDL Statements

System FunctionsDML Statements

Time/Date FunctionsTransaction 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

1 2 ... 221 222 223 224 225 226 227 228 229 230 231 ... 283 284

Keine Kommentare

Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 226