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 34 describes the fields that define a statement in the Statement pane.

Statement pane fields

Field name

Function

Name

Enables you to enter the name of the SQL statement. You can specify a name to identify the statement in the statement list.

System

Enables you to select a system from the System menu on which you want to execute the query.

Max Rows

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.

Catalog
Enables you to select a catalog name from the Catalog menu. If you do not explicitly qualify the query by specifying a 3-part ANSI name, the default catalog is the currently selected value in the menu.
NOTE:

The Catalog field is visible only to SUPER.SUPER and SUPER.SERVICES users.

Schema

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.

Rows/Page

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.

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.

Table 35 describes the options at the bottom of the Statement pane that enable you to test and modify the statement.

Statement pane buttons

Button

Function

Add

Enables you to add a new SQL statement or duplicate a statement to the Statement list.

Update

Enables you to update the statement. Modify the required information, and click Update.

Execute

Executes the statement and displays the results in the Statement Details pane.