DB2 graphic  QMF Version 8

Adding conditions to the example table

You can write expressions in your example table that set conditions on which rows are selected. The query below selects only the rows where the commission is greater than or equal to 1000.

When you run this query:

Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM         |
--------+----+------+------+-----+-------+--------+--------------|
        | P. |      |      |     |       |        | >= 1000  P.  |

QMF produces this report:

   ID     COMM
-----  -------
   70  1152.00
   90  1386.70
  340  1285.00

Data types in conditions

If a column contains letters or special characters, it must have a character data type. (If it contains double-byte characters, it can have a graphic data type.)

If a column contains only numbers or mostly numbers, it might still have a character data type. For example, a column of part numbers might contain mostly digits. However, if a part number like "1390X" is in the column, the column must have a character data type.


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