QMF Visionary Studio provides these query tools for creating SQL queries:
The Query editor also contains a Data Sheet view for viewing the results of your queries.
The following table lists SQL options and which QMF Visionary query tool you can use to include them in your queries.
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.