Using QMF

Adding a target table

An alternative to adding a new unnamed column to your example table is to use a target table. A target table is an empty example table that uses example elements to refer to other example tables. Anything that you can use in an unnamed column added to an example table, you can use in a target table.

To use a target table to combine information from two columns, display your table and issue the DRAW command:

COMMAND===> DRAW

Q.STAFF | ID | DEPT | SALARY | COMM |
--------+----+------+--------+------|
        | _I |  20  | _S     | _C   |
 
 
         |          |          |          |          |
---------+----------+----------+----------+----------|
 P.      | _I       | _S + _C  |          |          |

Restrictions

You cannot use target tables (or unnamed columns in example tables) to do the following:

• Name the column for your report. QMF names columns that are created by expressions (like the one in the example above). You can change the name of a column in a report by using a form. For more information on using forms, see Chapter 6, Customizing Your Reports.
• Write a condition. (If you need to write a condition, write it in a named column or a CONDITIONS box. See Adding a CONDITIONS box.
• Define an example element. You must define example elements in a named column of the example table.