DB2 Maestro: Product Tour

If you intend to use DB2 Maestro  for working with SQL queries and scripts, the most powerful (and at the same time easy!) tools are at your fingertips.

SQL Editor is the basic DB2 Maestro tool for creating and executing queries that supposed to return data.

The editor allows you to create and edit SQL text for the query, prepare and execute queries and view the results of execution. It also includes such useful features as syntax highlighting, hyperlinks, and code auto completion.

It is also possible to execute several queries at a time: just enter their texts separated by semicolon in the SQL Editor and press the Execute button. Execution of the selected text only is also available.

Visual Query Builder is meant for building queries visually.

You can create and edit queries even without knowledge of SQL: preparing and executing queries, viewing the results of the execution become simple operations when performed with the help of Visual Query Builder.

Using SQL Script Editor you can view, edit and execute SQL scripts.

To open the editor, just select the Tools | SQL Script Editor main menu item. Within the editor you are able to perform all the necessary operations with SQL scripts.