Previous Topic Next topic Print topic


To create a query

  1. Click SQL for DB2 on the Tools menu; then click 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.
Note: To execute your query, click on the query and click Batch.
Previous Topic Next topic Print topic