DB2 graphic  QMF Version 8

SQL query options

QMF Visionary Studio provides these query tools for creating SQL queries:

The following table lists SQL options and which QMF Visionary query tool you can use to include them in your queries.

Table 10. QMF Visionary query tool support
SQL option Simple Query wizard Advanced Query wizard Query diagram Text view
Simple table Yes Yes Yes Yes
Multiple tables (joins) No Yes Yes Yes
Aggregates Yes Yes Yes Yes
Functions Yes Yes Yes Yes
Parameter No Yes Yes Yes
GROUP BY clause No Yes Yes Yes
Filters (WHERE clause) No Yes Yes Yes
HAVING clause No Yes Yes Yes
ORDER BY clause No Yes Yes Yes
UNION clause No No No Yes
INTO TEMP clause No No No Yes

Aggregates include statistical functions such as SUM(), AVG(), and so on. Functions include operators, such as =, >, and <, as well as any functions you might have imported from the data source into your workbook.

QMF Visionary Studio online help and the DB2 QMF Visionary Getting Started Guide provide details about the individual pages of the query wizards.


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