Previous Topic Next topic Print topic

Micro Focus Studio Enterprise Edition for Windows > Programming > Mainframe Programming > SQL Option for DB2 > How to... > SQL Wizard > Query Databases > To create a query

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.
Parent topic: Query Databases
Previous Topic Next topic Print topic