DB2 graphic QMF Version 8

Tables

You can add a table to the query in one of two ways:

In the Tables window specify the table owner and name. You can use the Add from List button to open the Table List window where you can select a table from the list of tables available on the database server. The Tables window is the same window that is used to add tables from the prompted query interface. Refer to Tables for more information on the fields in the Tables window.

A diagram of the table that you have specified or selected appears in the top section of the diagram window. All the columns that are included in the table are listed in the diagram. All the columns in the table are also listed in the bottom section of the diagram window.

You can include multiple tables in your query. You would follow the same procedure for including tables. However, when you add multiple tables to a query, you must specify how to link the tables using join conditions.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004