OLAP query support |
Support has been added for multidimensional OLAP (Online
Analytical Processing) queries. This includes an OLAP Query Wizard,
which helps users to create OLAP queries; filtering options to customize
the data that is presented in the OLAP query results view; dynamic
formatting of the query results using extended grouping options,
and improved navigation tools including the Database Explorer, Query
Results Explorer, and the Layout Designer. |
Query Results Explorers |
The Query Results Explorer is a dockable tool
window that displays the query results in a tree structure. For relational
and OLAP query results, users can drag columns to and from nodes
and branches of the tree to restructure the appearance of the query
results view. |
Database Explorer |
The Database Explorer is a dockable window
used for viewing and accessing the QMF objects that reside on each
database server that has been defined in the SDF. Branches in the
Database Explorer tree list the servers in the SDF, the user's most
recently used servers, and a user's most recently used objects.
An additional branch lists any user-specified QMF objects. A filtering option
allows user to specify which objects are included in the lists.
The Database Explorer window opens with QMF for Windows and remains
open for the entire session, which makes it a convenient starting
point for most QMF for Windows functions. |
Object Analyzer |
The Object Analyzer works with the Database Explorer
and provides information about the references that an object has
on other objects. The objects referenced by a selected object are
listed in the Database Explorer tree under the selected object.
For tables, the columns are listed. These dependent objects (or
tables) are accessible and can be run or displayed directly from
the Database Explorer. |
Extended Grouping Options |
Multiple levels of grouping can be defined
on both axes in the query results view. For relational and OLAP
query results users can:
- Group data columns on the vertical axis and display results
with or without summaries.
- Group data columns on the horizontal axis and display results
with or without summaries.
- Select columns for grouping using drag-and-drop operations directly
in the query results view, or in the new Query Results or Layout
Designer windows.
|
Layout Designer |
The Layout Designer is a dockable tool window
that contains a high-level visual representation of the columns
included in the query results. The Layout Designer window provides
a visible work area on which users can change the appearance of
relational and OLAP query results. From the Layout Designer, users
can change the order of columns in the query results view, and specify
which columns will be grouped and summarized. |
Create queries using prompted and diagram
interfaces |
Users can create the SQL statements for queries
using two new interfaces. The diagram interface helps users build
queries visually using diagrams. The prompted interface helps users
build queries using dialogs. |
Spatial Map Document |
Spatial data maps are now viewed in a window
where users access to map functions has been streamlined with the
following enhancements:
- Drop-down menu for map objects
- Property and history information for map layers
- Toolbar now contains new map icons with tooltips to explain
functionality
- Ability to save data maps to a file
- Easy export of spatial data maps to procedures
- Export of spatial data maps as a bitmap or windows enhanced
meta file graphics file
|
Catalog |
An option has been added that enables QMF for Windows
administrators to specify that, for certain database servers, users
must use the default QMF for Windows catalog located on the database
server. This option ensures that resource limits established for users
cannot be thwarted. |
Long name support for catalogs |
QMF for Windows now supports catalogs that store objects
with short or long names. This support includes the ability to automatically
convert short name catalog tables to long name catalog tables.
Note:
Converting to long name catalogs is not required
even if the version of DB2 uses long names. |
Set User Information |
An option has been added to allow users to specify user
information only once during a QMF for Windows session. Once this
feature is enabled, the same user ID and password can be used to
connect to every database server. For users who use the same ID and
password for every server, this will eliminate repeated prompting
for the same information. |
Glossary |
A glossary has been added to the manual to define common
terms. |
Toolbar |
The toolbar contains new and redesigned icons
for more intuitive access to features and functions. |
IBM ObjectREXX |
A chapter has been added for IBM ObjectREXX to differentiate
between procedures and ObjectREXX procedures. |