DB2 graphic QMF Version 8

Summary of Changes

Several modifications to the documentation have been made to QMF for Windows for Version 8.1:

Table 1. Chapter 4 - Revisions and enhancements
Chapter 4 - Defining servers
Revision or enhancement Description
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.


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