HP Integrity NonStop J-Series - Manual (Page 100)

Statement pane
The Statement pane enables you to enter any SQL command (DDL or DML) in the text field. The
maximum number of characters you can enter in the text field is 2,147,483,647.
Table 30 (page 100) describes the fields that define a statement in the Statement pane.
Table 30 Statement pane fields
Function Field name
Enables you to enter the name of the SQL statement. You can specify a name to identify the
statement in the statement list. Name
Enables you to select a system from the System menu on which you want to execute the query. System
Enables you to enter the maximum rows that you want returned and displayed in the Statement
Details pane. The default is 500 rows and the maximum is 2,147,483,647. Max Rows
Enables you to select a schema name from the Schema menu. If you do not explicitly qualify
the query by specifying a three-part ANSI name, the default schema is the currently selected
value in the menu. Schema
Enables you to enter the number of rows to be retrieved and displayed in one page of the
statement result set. You can set a value between 1 and 100,000. Or, use the default
Rows/Page value (0), which causes MXDM to retrieve and display the entire result set. Rows/Page
If you specify a value of 1 or more, or if you use the default setting and MXDM cannot retrieve
and cache the entire result set using available memory, MXDM automatically displays the
result set in pages. For more information on page mode, see
“Page mode” (page 101) .
Table 31 (page 100) describes the options at the bottom of the Statement pane that enable you to
test and modify the statement.
Table 31 Statement pane buttons
Function Button
Enables you to add a new SQL statement or duplicate a statement to the Statement list. Add
Enables you to update the statement. Modify the required information, and click Update. Update
Executes the statement and displays the results in the Statement Details pane. Execute
Terms
page mode
Parameter prompts
SQL statements can contain parameter names enclosed within $$ (double dollar signs). When you
execute the statement, the SQL Whiteboard prompts you for values for all parameters in that
statement. You can reuse values for those parameters.
For example, consider a table, T that contains a column T1. You can enter the following statement
in the Statement field:
Select T1 from T where T1 = $$p1$$
When you click Execute, the Parameters dialog appears.
Figure 39 (page 101) shows a sample Parameters dialog.
100 Using the SQL Whiteboard