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.
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
|
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.
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. |