Statement List pane

The Statement List pane provides a list of SQL statements that you added in the current session or earlier sessions of the SQL Whiteboard tool. The list of SQL statements in one MXDM session persists in other MXDM sessions similar to how connection information and favorites persist.

From the Statement List pane, you can perform the following tasks:

  • View the name and statement that was previously added in the Statement pane. Optionally, you can explicitly add a statement to the statement list without executing it.

  • Update an existing statement in the list.

  • Execute a statement.

  • Sort the statements based on the statement name or statement text.

The following table describes the options at the top of the Statement List pane. These options enable you to select the statements that you want to execute.

Statement List pane options

Button

Function

All

Selects all statements in the Statement List pane.

None

Clears all statements in the Statement List pane.

Discard

Removes the results only or the selected statements and the results. You cannot remove statements alone.

NOTE:

You cannot discard a statement or the results while the statement is executing. If a currently executing statement is part of a Discard selection, it is omitted.

Use Discard when you want to free virtual memory or when MXDM indicates that system resources are running low. Until you exit the SQL Whiteboard, the result of every executed statement is cached. If you have already executed several large statements in the current session, the results are cached in memory. Therefore, less memory is available for new executions. Page mode describes how the SQL Whiteboard caches and displays large result sets.