Online Documentation for SQL Query for DB2

SQL Assistant


SQL Assistant which is located at the bottom of the Database Explorer window helps you to work with your database objects. Depending on the current selection in DB Explorer, the SQL Assistant area displays additional information about the selected object.

 

hs3150 - SQL Assistant

 

If you select a host in DB Explorer, SQL Assistant displays the list of cataloged nodes on the DB2 system in use.

 

If you select a node in DB Explorer, SQL Assistant displays the list of the registered databases. The databases you are connected to are displayed in color, whereas all the rest database aliases are grayed out.

 

If you select a database in DB Explorer, SQL Assistant displays the list of the database schemas.

 

If you select a schema in DB Explorer, SQL Assistant displays the list of the database object groups and the number of objects in each group.

 

Selecting an object group in the DB Explorer displays the list of the objects in SQL Assistant.

 

If you select a table or a view in DB Explorer, SQL Assistant displays the list of the fields, their types and field comments.

 

If you select a query in DB Explorer, SQL Assistant displays the date and the time when the query was created.

 

You can also use SQL Assistant to work with your queries quickly. You can drag-and-drop object aliases to the SQL Editor or Visual Query Builder working area, in the same way as this operation is performed in Database Explorer.