Hp Neoview Release 2.5 Software Manual do Utilizador descarregar pdf (Página 225)

Run Statements

Run a SQL Statement Using Metric Miner

Using Metric Miner, you can run SQL statements in much the same way that you can run them

by using the SQL Whiteboard. Saving the statement information as a report is optional.

To run a SQL statement using Metric Miner:

1. Launch Metric Miner, as described in “Launch Metric Miner” (page 220).

2. In the SQL input area of the Ad-Hoc Report tab, type the SQL statement. If you don't see

the Ad-Hoc Report tab, click the Ad-Hoc Report node in the Report Explorer pane to

create the tab.

NOTE: The SQL Designer tool simplifies the task of creating complex statements, and

statements that you create by using the SQL Designer are inserted into the SQL input area.

See “Use the SQL Designer” (page 225).

If you don't explicitly qualify the statement by specifying a 3-part ANSI name, the default

schema is the currently selected value in the Schema drop-down list.

3. Click the Schema button, and select the schema for the statement.

4. In the Rows field, type the number of result rows that you want Metric Miner to display in

the Report Results pane. The default value is 500 rows. You can set this value to between

1 and ≤ 100,000. Or specify 0, which causes Metric Miner to try to fetch and display the entire

result set.

5. Click the button to run the SQL statement ( ). If the report has input parameters, Metric

Miner displays a Parameters dialog box so that you can enter the parameter values. For

more information about parameters, see “Add Parameters to Statements” (page 226).

6. Enter the parameter values, if required, and click [ OK ]. If the statement is successful, results

appear in the Report Results pane, and the Status Tab summarizes the execution status.

If the statement is unsuccessful, an Errors tab appears under the Report Results pane.

7. If you want to create a report containing the statement, see “Create a Report” (page 230). If

you do not need to save the statement as a report, click the button to close the report ( ).

Related Topics

“See the Parts of Metric Miner” (page 220)

“Create a Report” (page 230)

“Resolve Errors and Error Messages” (page 47)

“Use the SQL Designer” (page 225)

“Add Parameters to Statements” (page 226)

“Understand Page Mode” (page 214)

Terms

Ad-hoc Report

Use the SQL Designer

The SQL Designer is a tool that allows you to build a SQL statement by adding syntax items

from a set of lists and using the keyboard to enter other required text. The resulting statement

is then inserted into the SQL input area. The SQL Designer lets you select from lists of all the

tables, views, columns, and functions for a given schema.

To launch the SQL Designer, click the SQL Designer button ( ) on the Metric Miner toolbar.

To use the SQL Designer:

Run Statements 225

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

Comentários a estes Manuais

Sem comentários

Hp Neoview Release 2.5 Software Manual do Utilizador Página 225

Comentários a estes Manuais

Manuais e produtos relacionados com Software Hp Neoview Release 2.5 Software