To create a query

1. From the main menu, click Run > Tools > Data Tools > SQL Option for DB2 > Client > SQL Wizard.
2. If the Catalog Browser window is not open, click to open it.
3. On the Catalog Browser window, ensure the Query tab is selected.
4. Click New.
5. Click the table names that you are interested in and click Add.
6. When you have added all the required tables, click Done.
7. In each table, click the fields that you are interested in.
8. Under each field, type any conditions you require.
9. Click Save As on the file menu to save your query.
10. Close the Query Design window.
11. Click Refresh, to see your new query listed.