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