Extensive query and reporting capabilities
The query and reporting features of QMF for Windows and
QMF for WebSphere include:
- a Database Explorer that enables users to easily discover the
items that have been saved on the database server
- online analysis of query dependencies, including OLAP analysis
- the ability to build powerful queries without knowing SQL using
the diagram or prompted interfaces
- support for DB2 UDB V8 functionality including DB2 Cube Views,
long names, Unicode, and enhancements to SQL
- extensive drag and drop capabilities for restructuring the appearance
of query results
- comprehensive query results formatting options including a robust expression
language that allows users to conditionally format query results by
retrieved column values
- the ability to add calculated columns to the query results and
group data columns on both axes with or without summaries
- charts and other complex visuals for displaying query results
- simple step-by-step guidance to create traditional text-based
reports or state-of-the-art reports with rich formatting
- query results can be sent to other applications
- API commands that developers can use in any application
