Table of Contents Previous Next



To invoke the Query Tool SQL IDE from within PEM, simply highlight the name of the database you want to query in the tree control, and click the SQL toolbar icon. You can also open the Query Tool IDE by selecting Query tool from the Tools menu.
The Query Tool dialog provides an interface that allows you to manually enter in SQL queries, graphically create and execute SQL statements from dragging and dropping objects onto a visual palette, EXPLAIN queries and much more.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\090c0e1a\query.png
The upper panel of the Query Tool contains the SQL Editor. You can use the panel to manually enter a query, or read the query from a file. If you are manually entering a SQL query, the edit entry window also contains autocompletion code and formatting features that help you write queries.
If you prefer to build your queries graphically, you can use the Graphical Query Builder (shown in Figure 4.4) to generate SQL commands. After constructing a graphical query, click the Execute button to display the query text in the SQL Editor tab, and the results of the query in the Output pane (shown in Figure 4.5).

C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\d5f3203b\querytool.png
You can manually adjust the query in the SQL Editor pane. As with all PEM features, online Help text is available with the click of a button.


Table of Contents Previous Next