Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > How to... > SQL Wizard > Query Databases > To create a query

To create a query

  1. From the main menu, click 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.
Note: To execute your query, click on the query and click Batch.
Parent topic: Query Databases
Previous Topic Next topic Print topic