- Click
SQL for DB2
on the
Tools menu;
then click
SQL Wizard.
- If the Catalog Browser window is not open, click

to open it.
- On the Catalog Browser window, ensure the
Query tab is selected.
- Click
New.
- Click the table names that you are interested in and click
Add.
- When you have added all the required tables, click
Done.
- In each table, click the fields that you are interested in.
- Under each field, type any conditions you require.
- Click
Save As on the file menu to save your query.
- Close the Query Design window.
- Click
Refresh, to see your new query listed.
Note: To execute your query, click on the query and click
Batch.