DB2 QMF for Windows enhancements
DB2 QMF for Windows now provides significant new data
visualization capabilities, as well as many other enhancements including:
Support for IBM DB2 Cube Views Version 8.1
- OLAP analytics are made simple for novices with no knowledge
of OLAP.
- Drag and drop actions are supported to create dynamic OLAP reports
in minutes and slice, dice, and drill into analytical data.
- You can build multiple levels of summary and drill-down to related
data simply by dropping onto a layout.
- You can quickly create multiple viewpoints of data by positioning
side dimensions, top dimensions, and measures.
- You can format long complex reports for prining on common office
printers.
- You can save reports for centralized sharing with other DB2
QMF for Windows and DB2 QMF for WebSphere users across the enterprise.
A new database explorer
- You can visually navigate and inspect enterprise database assets
including database servers, databases, tables, views, queries, reports,
and DB2 stored procedures.
- You can instantly analyze object dependencies such as which
tables are accessed by a given query.
- You can create customizable folders of favorites for easy navigation
to frequently used resources.
New query and report building capabilities with emphasis on visual drag and drop
- A visual query builder displays tables, columns, and SQL in
an easy to manage layout.
- You can create new across reports and pivot tables with multiple
levels of grouping on the horizontal and vertical axes.
- The layout designer allows for easy manipulation of query results
such as rapidly creating derived columns from returned columns.
- Conditional formatting of query results allows for specified
values or thresholds to be automatically highlighted with colors
or other attributes.
Other enhancements
- SQL Expression Builder updates to support new SQL functions
in DB2 UDB for z/OS Version 8
- A new internal expression language for supporting complex conditions, form
calculations, and custom definitions; removal of the requirement
to install Object REXX
- Support importing and exporting as XML which includes generating
a simple XSAL stylesheet (on export) that defines rows and columns
- Support for long names in DB2 UDB for z/OS Version 8.1 and DB2
QMF for TSO/CICS Version 8.1
- Automatic migration or creation of catalogs to support long
names (and related operations such as rebinding host variables with
increased lengths) which provides for faster transition from prior
versions of DB2 QMF and DB2 Universal Database
- Support to non-DB2 data sources as database servers including
ODBC-compliant data sources such as spreadsheets, and removal of
the requirement for a data source to support a QMF catalog
- A new option to allow users to automatically submit the same
user information (ID, password, and account) to each server accessed,
eliminating multiple logons wherever user information is the same
across servers
- Error explanations that are linked to DB2 error message dialogs,
providing users with comprehensive reference sources on any error
message encountered
- A common Unicode document file format for exported files, which
allows for ANSI and Unicode versions of DB2 QMF for Windows to read documents
written by either version, and which enhances the sharing of documents
with DB2 QMF for WebSphere
- More flexible administrator distribution of database access
privileges publish server definition files (SDFs) via FTP and HTTP,
which allows for the ability to administer DB2 QMF for WebSphere
usage from the DB2 QMF for Windows Administrator module
- The ability to automatically resissue special register values
in SET statements when reconnecting to a database
- A security enhancement that provides administrators with the
option to enforce the use of a particular QMF permissions catalog
at all times, either on the accessed database server or another
database server
- New options that allow query results to display in the native
CCSID of the database
- Support for additional DRDA(R) ACRs
