IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 15 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 15 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 15 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 15 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 15 ************************************************************* QMFDQ-8266 If a form contains custom edit codes, an error may occur when opening it. QMFDQ-9251 The DSQCP_TEDFLT global variable has no effect while editing a table. QMFDQ-9364 Made virtual table and column names case insensitive. QMFDQ-9375 QMF now automatically grants *EXECUTE privilege for RSBI, Q, RDBI, and QMF/DQ packages libraries for iSeries databases. QMFDQ-9379 Disabled the ability to rename the Workspaces node in the Repository Explorer view. QMFDQ-9384 If you run a visual report in the HTML rendering mode, then rerun the visual report in the Flash rendering mode, the HTML mode is still displayed in the toolbar. QMFDQ-9387 When you rename a data source that has an associated QMF catalog, if you attempt to expand the data source node, an error occurs. QMFDQ-9467 (PMR03278) The Export to Excel operation truncates the exported data if it contains a "0x00" character. QMFDQ-9544 Copying a measure from an OLAP cube and attempting to paste it as a link into another OLAP cube causes the application to hang. QMFDQ-9545 The Display a Report Using the Current Query Result command doesn't work for OLAP queries. QMFDQ-9550 You can not create a new workspace in a repository if there is no active connection to it. QMFDQ-9569 (PMR53611) Values provided for substitution variables in classic report headers are ignored after the first page of the report. QMFDQ-9570 In the Info page of the Properties dialog of a data source, the parameter value can not be changed and the same parameter can be added many times. QMFDQ-9571 Entries in the Repository Explorer name filter are case sensitive. QMFDQ-9573 The "License file not found" error message displays for all licensing issues, regardless of the specific problem. QMFDQ-9574 A Procedure stored in a workspace cannot find a Visual Report that is stored in the same workspace. QMFDQ-9575 Search in a repository fails with NullPointerException if there is no active repository connection. QMFDQ-9577 The option to create a Workspace is not present under the New option when the Workspaces node is right-clicked. QMFDQ-9578 An error may occur while editing an offline table in the Prompted query editor. QMFDQ-9579 The link to a QMF catalog object disappears from the Repository Explorer view when the object is renamed. QMFDQ-9582 In some cases, duplicate folders are displayed in the Explore view after copying a folder. QMFDQ-9585 After running a DRAW QUERY procedure command, the RUN QUERY procedure command produces an error. QMFDQ-9591 The More help button in the Save dialog does not work. QMFDQ-9592 If query caching is turned on in the resource limits, opening an edited table in the table editor returns previous data. QMFDQ-9594 Corrected multiple issues which prevented the effective rollout of the new repository security model option that is based upon database accounts. QMFDQ-9604 Saving over a query that is saved in the repository erases the comment field. QMFDQ-9605 An error occurs when you attempt to connect to a database based repository with a web service repository connection. QMFDQ-9619 Right-clicking a repository and selecting New Repository Connection does not automatically populate the Connection Parameters information. QMFDQ-9633 It is not possible to rename a data source from the Properties dialog. QMFDQ-9645 Administering database based security requires that the user's primary ID has SYSADM authorization on DB2 for z/OS. QMFDQ-9648 Decreasing the width of the Workspaces view and then clicking on a workspace causes an error. QMFDQ-9683 An error occurs if user runs the DISPLAY REPORT command from the command bar when SQL view is active. QMFDQ-9688 (PMR53611) Retrieving resource limits takes extra time when running a procedure, query, or report group. QMFDQ-9696 The DSQQW_PROC_WNDWS global variable does not work properly when it is set to "2". QMFDQ-9700 An NullPointerException occurs when you attempt to copy a link to a data source if the data source has "none" permissions for the current user. QMFDQ-9734 Prompted queries can not handle ROW condition WHERE clauses with LIKE when character data contains "&". QMFDQ-9754 (PMR00487) The list of available CCSID code pages does not contain 930a. QMFDQ-9819 A user's name and password for a repository storage is shared between sessions. QMFDQ-9845 More than one connection is required to run a query against a data source with one-time use database passwords. QMFDQ-9877 (PMR79278) An error occurs when you attempt to bind packages against DB2 z/OS if the decimal delimiter in the database is a comma. QMFDQ-9919 (PMR76528) Added parameters to specify advanced properties for an SSL connection. QMFDQ-9973 (PMR86479) Trailing zeros in decimal columns are truncated on the right side when exporting query results with export type text. QMFDQ-10158 An error occurs when you attempt to export query results to a text file with empty delimiters if the Delimit Always option is selected. QMFDQ-10161 (PMR78504) In the Set User Information dialog, when the Remember the password check box is checked and the user's password is different than their password on the mainframe, errors may occur. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 15 ************************************************************* QMFDQ-8266 If a form contains custom edit codes, an error may occur when opening it. QMFDQ-8892 Data Columns items in the Outline view do not have associated context menu. QMFDQ-9364 Made virtual table and column names case insensitive. QMFDQ-9375QMF now automatically grants *EXECUTE privilege for RSBI, Q, RDBI, and QMF/DQ packages libraries for iSeries databases. QMFDQ-9378 (PMR72838) Users may be able to share a data source login and password with other users. QMFDQ-9379 Disabled the ability to rename the Workspaces node in the Repository Explorer view. QMFDQ-9384 If you run a visual report in the HTML rendering mode, then rerun the visual report in the Flash rendering mode, the HTML mode is still displayed in the toolbar. QMFDQ-9387 When you rename a data source that has an associated QMF catalog, if you attempt to expand the data source node, an error occurs. QMFDQ-9542 Added the Export to Excel action to the Results menu. QMFDQ-9545 The Display a Report Using the Current Query Result command doesn't work for OLAP queries. QMFDQ-9559 The startup folder does not refresh new content when the session is reloaded. QMFDQ-9569 (PMR53611) Values provided for substitution variables in classic report headers are ignored after the first page of the report. QMFDQ-9570 In the Info page of the Properties dialog of a data source, the parameter value can not be changed and the same parameter can be added many times. QMFDQ-9571 Entries in the Repository Explorer name filter are case sensitive. QMFDQ-9574 A Procedure stored in a workspace can not find a Visual Report that is stored in the same workspace. QMFDQ-9575 Search in a repository fails with NullPointerException if there is no active repository connection. QMFDQ-9577 The option to create a Workspace is not present under the New option when the Workspaces node is right-clicked. QMFDQ-9579 The link to a QMF catalog object disappears from the Repository Explorer view when the object is renamed. QMFDQ-9581 (PMR76712) The query results grid may take up a lot of memory. QMFDQ-9585 After running a DRAW QUERY procedure command, the RUN QUERY procedure command produces an error. QMFDQ-9591 The More help button in the Save dialog does not work. QMFDQ-9594 Corrected multiple issues which prevented the effective rollout of the new repository security model option that is based upon database accounts. QMFDQ-9609 It is not possible to remove repository storage from the Repositories view. QMFDQ-9611 The Retrieve All command in the Results menu may be disabled even if not all data has been fetched. QMFDQ-9614 The Send to Mail Recipient command in the File menu results in a blank attachment. QMFDQ-9619 Right-clicking a repository and selecting New Repository Connection does not automatically populate the Connection Parameters information. QMFDQ-9645 Administering database based security requires that the user's primary ID has SYSADM authorization on DB2 for z/OS. QMFDQ-9648 Decreasing the width of the Workspaces view and then clicking on a workspace causes an error. QMFDQ-9681 User names and passwords that are stored in the QMF for WebSphere user are not available in QMF for WebSphere Administrator. QMFDQ-9696 The DSQQW_PROC_WNDWS global variable does not work properly when it is set to "2". QMFDQ-9700 An NullPointerException occurs when you attempt to copy a link to a data source if the data source has "none" permissions for the current user. QMFDQ-9713 The custom edit code library is not included in the product. QMFDQ-9734 Prompted queries can not handle ROW condition WHERE clauses with LIKE when character data contains "&". QMFDQ-9754 (PMR00487) The list of available CCSID code pages does not contain 930a. QMFDQ-9819 A user's name and password for a repository storage is shared between sessions. QMFDQ-9845 More than one connection is required to run a query against a data source with one-time use database passwords. QMFDQ-9877 (PMR79278) An error occurs when you attempt to bind packages against DB2 z/OS if the decimal delimiter in the database is a comma. QMFDQ-9919 (PMR76528) Added parameters to specify advanced properties for an SSL connection. QMFDQ-9973 (PMR86479) Trailing zeros in decimal columns are truncated on the right side when exporting query results with export type text. QMFDQ-10158 An error occurs when you attempt to export query results to a text file with empty delimiters if the Delimit Always option is selected. QMFDQ-10161 (PMR78504) In the Set User Information dialog, when the Remember the password check box is checked and the user's password is different than their password on the mainframe, errors may occur.