IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 7 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 7 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 7 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 7 README file. This README file contains descriptions of fixes for DB2 QMF for Workstation and DB2 QMF for WebSphere. ************************************************************* 2.0 PROBLEMS CORRECTED IN QMF for Workstation 9.1 Fix Pack 7 ************************************************************* QMFDQ-1458 Error can occur when user accesses the RDBI.SERVER_INFO table with dynamic SQL. QMFDQ-3277 Error can occur when changing the QMF catalog that is the resource limits provider for a data source. QMFDQ-3687 Error occurs when running two procedures that include the DISPLAY REPORT command using QMFBatch. QMFDQ-3714 Process of collecting information about QMF's configuration and environment has been automated. QMFDQ-4004 Japanese characters are displayed incorrectly in visual reports exported to PDF format. QMFDQ-4238 Data from a calculated column with a subtotal is not displayed in classic reports. QMFDQ-4244 Summary data at the end of a visual report unable to span multiple pages. QMFDQ-4291 Converting a query to a visual report incorrectly includes the value of a global variable in all rows rather than the query data. QMFDQ-4376 Error occurs when dragging a query results column from the Project Explorer Queries folder to any of the MainPage sections of a visual report. QMFDQ-4417 Error can occur when viewing the properties for a link to a data source that has been removed. QMFDQ-4496 Error can occur when copying visual report templates. QMFDQ-4506 Error can occur when attempting a Paste Link from the clipboard and the original object of the link has been deleted. QMFDQ-4539 In some cases, objects are not displayed in the Repository Explorer view's recently used list. QMFDQ-4542 Error can occur when object names in the Repository Explorer exceed 128 characters. QMFDQ-4546 The correct default action of run is not invoked for Report Center objects that reside in the QMF catalog on a data source and are opened from the Repository Explorer. QMFDQ-4559 Heading in grid object is drawn incorrectly if header string is set to wrap. QMFDQ-4574 From a QMFBatch session, export procedure does not add extension to exported file. QMFDQ-4581 Some query text in the SQL editor may be inadvertently deleted while focus is in the Layout, Prompted, or Diagram editors. QMFDQ-4586 Error can occur when adding a link to an object that does not exist from the Workspaces view. QMFDQ-4602 The 'Fast Save' option will be disabled if a query returns more then one result set, if a query's SQL text consists of more then one SQL query, or the SQL Query is not a SELECT query. QMFDQ-4708 Error can occur when exporting data to an IXF file when the query is only prepared. QMFDQ-4709 Incorrect message appears when exporting IXF with the default CCSID of utf-16le. QMFDQ-4714 Changes that are pasted into the Create Objects dialog are ignored. QMFDQ-4720 Error can occur when pasting images from the clipboard to a visual report. QMFDQ-4723 SQL error can occur for queries with a JOIN statement that are run against a personal repository. QMFDQ-4725 Image object in a visual report can be distorted after executing an undo/redo command combination. QMFDQ-4730 Exception can occur when viewing the Security properties for a Informix data source. QMFDQ-4743 Column width and scroll bars can be displayed incorrectly in a query results grid that exceeds the screen width. QMFDQ-4744 In some cases, query is incorrectly marked as modified. QMFDQ-4779 Exception can occur when an empty visual report (all sections deleted) is viewed in HTML runtime mode. QMFDQ-4781 Unable to display visual report templates. QMFDQ-4792 QMFBatch fails to connect to a data source if the password and user ID are not identical. QMFDQ-4801 Links to repository objects should not be deleted from the Workspaces view when the primary object is deleted from Workspaces view. QMFDQ-4813 Items in personal repository Recently Used folder are not saved. QMFDQ-4849 Unable to refresh contents of Repositories view using the refresh icon in the view's toolbar. QMFDQ-4872 Prompted query editor creates SQL for a query with a FULL OUTER JOIN which is not supported by Derby database. QMFDQ-4905 Exception can occur when opening a form with seven or more BREAK columns defined. QMFDQ-4919 Arabic reports are not properly displayed in PDF format. QMFDQ-4920 Changes to the tablespace name specified in the Space field of the User Profile dialog are not saved. QMFDQ-4934 German version of QMF for Workstation does not translate generated column names correctly. QMFDQ-4954 Procedure command EXPORT REPORT ignores Page Setup settings. QMFDQ-4982 Unable to process a DRAW procedure command that includes the value of UPDATE for the TYPE parameter. QMFDQ-4984 The ERASE procedure command is unable to substitute the default object owner name. QMFDQ-5000 Adding user defined global variables starting with the DSQ prefix should cause an error. QMFDQ-5002 In some cases, Japanese IXF files open incorrectly. QMFDQ-5019 Repository storage cannot be created on data sources with DB2 8.1 for z/OS running in compatibility mode. QMFDQ-5023 Classic report has extra asterisk (*) added when specifying both BREAK and GROUP usage codes. QMFDQ-5032 CALC usage code gives incorrect results. QMFDQ-5033 Unable to import IXF data containing columns with GRAPHIC data types. QMFDQ-5060 Support added that allows users to custom format &DATE and &TIME values in reports. QMFDQ-5101 Enhanced Expression Designer's undo and redo capabilities. QMFDQ-5106 Error can occur when expanding references node for a query in the Repository Explorer. QMFDQ-5130 Unable to run visual reports when application is installed under root privileges on Linux system and opened under non-root privileges. QMFDQ-5162 Error can occur when inserting a table row using the table editor. QMFDQ-5192 Multiple references to one column in the column definition portion of a query can cause problems with a group by clause. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF for WebSphere 9.1 Fix Pack 7 ************************************************************* QMFDQ-1458 Error can occur when user accesses the RDBI.SERVER_INFO table with dynamic SQL. QMFDQ-3023 In the QMF for WebSphere administrator interface that reads right-to-left, the icons in the side panel tree overlap the text. QMFDQ-3714 Process of collecting information about QMF's configuration and environment has been automated. QMFDQ-4004 Japanese characters are displayed incorrectly in visual reports exported to PDF format. QMFDQ-4600 Advanced JDBC Settings for a new data source are not saved during the initial configuration of the data source in the repository. QMFDQ-4602 The 'Fast Save' option will be disabled if a query returns more then one result set, if a query's SQL text consists of more then one SQL query, or the SQL Query is not a SELECT query. QMFDQ-4602 Error can occur when opening a visual dashboard in PDF mode using Java 1.5.0 with monitor resolution 1280x1024 and font scale 110%. QMFDQ-4612 In some cases an error can occur when using the global variable DSQEC_SP_RS_NUM. QMFDQ-4626 The Display Report Wizard requires two clicks on the Finish button to complete the process of creating a classic report based on the format of the current query. QMFDQ-4671 The confirmation dialog that is issued when deleting marked objects does not automatically close after confirmation. QMFDQ-4681 When interface direction is set to right-to-left, the OK and Cancel buttons in the Build JDBC URL dialog are not visible. QMFDQ-4714 Changes that are pasted into the Create Objects dialog are ignored. QMFDQ-4737 In some cases, unable to copy the Tables node from the Sample repository to a user's workspace. QMFDQ-4753 When listed in the side bar, a job object is not displayed with a unique icon that identifies its object type. QMFDQ-4768 Objects in the workspace should be listed in the same sorted order as they appear in QMF for Workstation. QMFDQ-4770 Workspace folder names that include multiple spaces display incorrectly. QMFDQ-4779 Exception can occur when an empty visual report (all sections deleted) is viewed in HTML runtime mode. QMFDQ-4905 Exception can occur when opening a form with seven or more BREAK columns defined. QMFDQ-4919 Arabic reports are not properly displayed in PDF format. QMFDQ-4934 German version of QMF for WebSphere does not translate generated column names correctly. QMFDQ-4954 Procedure command EXPORT REPORT ignores Page Setup settings. QMFDQ-4971 DISPLAY command is ignored when it follows a Run command in a procedure. QMFDQ-4982 Unable to process a DRAW procedure command that includes the value of Update for the TYPE parameter. QMFDQ-4984 The ERASE procedure command is unable to substitute the default object owner name. QMFDQ-5000 Adding user defined global variables starting with the DSQ prefix should cause an error. QMFDQ-5002 In some cases, Japanese IXF files open incorrectly. QMFDQ-5008 Error can occur when refreshing the list of user profiles in the User Profiles resource limits page. QMFDQ-5019 Repository storage cannot be created on data sources with DB2 8.1 for z/OS running in compatibility mode. QMFDQ-5032 CALC usage code gives incorrect results. QMFDQ-5060 Support added that allows users to custom format &DATE and &TIME values in reports. QMFDQ-5194 Unable to create repository storage objects on a fresh (never hosted repository storage) mainframe data source.