IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 14 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 14 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 14 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 14 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 14 ************************************************************* QMF for Workstation 9.1 Fix Pack 14 QMFDQ-6386 Can not save a query to the QMF Catalog when using the 1200 and 13844 CCSID. QMFDQ-7884 The Create Table operation does not handle PRIMARY KEYs correctly. QMFDQ-7996 An error occurs when accessing a multidimensional data source that gets its resource limits from a QMF catalog. QMFDQ-8401 (PMR15973) Removed the Scan for Updates link from the Help system. QMFDQ-8480 Implemented a database-based security provider. QMFDQ-8495 (MR1216094343) Added the ability to define the default name filter. QMFDQ-8605 (PMR64011) Page footers do not display properly when printing default classic forms. QMFDQ-8619 The Rename Object dialog for QMF objects may not work correctly. QMFDQ-8631 Can not view schemas from a QMF catalog in the Explore view. QMFDQ-8635 The Explore view is not refreshed after renaming objects from a QMF catalog. QMFDQ-8639 Importing a table from a text file is not possible. QMFDQ-8640 The list of databases in the Import Table Wizard is not sorted. QMFDQ-8657 An unnecessary error message might open if an invalid repository storage URL is entered in the Create New Shared Repository wizard. QMFDQ-8661 Can not import tables from WQML files. QMFDQ-8678 Export result set generates invalid XML. QMFDQ-8681 The Setup Properties dialog may not work correctly. QMFDQ-8685 An error might occur if you open and close the Outline view and then select a result set node. QMFDQ-8686 The Validate function in the Edit Driver Library dialog does not display errors. QMFDQ-8695 A table with double quotes in its path causes errors when you link to it. QMFDQ-8698 QMF objects are not displayed in the Repository Explorer view under the Schemas node after they are created. QMFDQ-8706 QMF catalog properties are not fully disabled in a shared repository Properties dialog after being deleted. QMFDQ-8710 OLAP query dimensions aren't filled when they are expanded in the results view. QMFDQ-8720 Only the first page of OLAP query results can be viewed. QMFDQ-8721 An error occurs when you attempt to rename the same query from two different instances of the application. QMFDQ-8725 Added support for multi-line comments in repositories. QMFDQ-8744 If a procedure has more than one hundred objects, running with DSQQW_PROC_WNDWS=0 and DSQQW_REUSE_OBJS=0 does not close the objects. QMFDQ-8750 The 'M' code is displayed twice in the classic report edit codes combo box. QMFDQ-8752 (PMR28520) Ampersands that are used in the Add Row Condition dialog are stripped out when the dialog closes. QMFDQ-8758 While creating a new relational data source, the application attempts to connect to a data source even if you cancel out of the wizard. QMFDQ-8759 An error may occur when you attempt to delete a collection ID. QMFDQ-8769 In the query results editor, selecting Grouping and Aggregation > No Aggregation does not reset the original order of the columns. QMFDQ-8779 When the application hangs for a period of time, the hourglass cursor does not display. QMFDQ-8781 Improved the current security model. QMFDQ-8785 An extra column may display in the content assist drop down list in the SQL query editor. QMFDQ-8813 The invalid query error message does not display for MSSQL 2000 data sources. QMFDQ-8819 (PMR78504) Users encounter the same error message over and over when in invalid user ID is entered into the Set User Information menu and Remember the Password is selected. QMFDQ-8831 You can not add 'none' repositories to the Startup folder unless you expand the repository in the Repositories view. QMFDQ-8837 An error may occur when you attempt to delete the Samples repository. QMFDQ-8850 (PMR74494) The Setup delimiter options page of the Export CVS dialog should not be displayed. QMFDQ-8851 The file extension of an exported result set can not be changed from CSV to PDF while in the Export wizard. QMFDQ-8863 You can not switch between a query's statements and the Prompted query editor. QMFDQ-8864 A query may not refresh its tables when switching between the SQL and Prompted query editors. QMFDQ-8866 When the Run icon is clicked twice in a row, the open query is run twice, simultaneously. QMFDQ-8880 The Apply to all columns Results menu item does not work properly. QMFDQ-8900 Changes to options in Form Options in a classic form are not registered as changes and you can not save the form. QMFDQ-8915 The Explore view does not refresh when you enable a QMF catalog in a data source. QMFDQ-8938 (PMR65979) The application fails to handle the Number of Fixed Columns in the Report option when it is set to 79 or another extraordinary number. QMFDQ-8949 (PMR66094) A form with a BREAK1 column and multiple BREAK1X columns exports or prints the contents in two pages instead of one. QMFDQ-8962 The Object List dialog of the Create New Query Using Draw Query Wizard does not display all of the available virtual data sources. QMFDQ-8978 A query might display with a different name in the Recently Used folder than in the repository tree. QMFDQ-8983 The second References node displays for a query in the Explore view when the query is renamed in the Workspaces view. QMFDQ-8985 An error may occur when you attempt to bind packages for a new shared repository storage. QMFDQ-8989 In the JDBC URL combo box of the Create New Repository Connection wizard, one repository storage may be displayed twice. QMFDQ-9000 Repository icons may appear differently in different views. QMFDQ-9002 Enabled case sensitivity in virtual table and column names. QMFDQ-9005 The Default resource limit group name and comment are always displayed in English. QMFDQ-9007 Can not rename objects in the Search view. QMFDQ-9009 The EDIT FORM and EDIT REPORT procedure commands do not open the report in the design view. QMFDQ-9011 An incorrect error message is displayed when an incorrect password is entered at the data source log on dialog. QMFDQ-9023 Running a query with substitution variables a second time fails to prompt for variable values. QMFDQ-9024 The USE procedure command connects to a repository but the Repository Connections and Repository Explorer views are not refreshed. QMFDQ-9031 In the Visual Designer page of the Preferences dialog, the data/time combo boxes contain non-translated values. QMFDQ-9032 The OLAP query selection in the New Object wizard is not enabled. QMFDQ-9033 An error may occur when attempting to open an OLAP query. QMFDQ-9034 Some expressions can not be entered in the Field cells of the Diagram query editor. QMFDQ-9038 The Workspace menu command is incorrectly present in the Repositories view context menu. QMFDQ-9047 (PMR66345) Procedures stop running when an ERASE command is set against a non-existent table. QMFDQ-9055 The Select resource limits provider page of the Create New Relational Data Source wizard should not display if the QMF plug-in is not activated. QMFDQ-9058 It is possible to create two resource limits user profiles with the same name. QMFDQ-9059 Inserting a query into an existing visual report may cause an error to display. QMFDQ-9063 When saving a visual report, if you check the Save as template checkbox, click next, then go back and deselect it, the visual report is still saved as a template. QMFDQ-9077 In the Diagram query editor, the Average and Sum aggregation options are incorrectly available for date and time columns. QMFDQ-9079 An error may occur when adding multiple tables to a query while in the Diagram query editor. QMFDQ-9081 If you try to run an empty query from the Layout query editor, then switch to the SQL query editor and author a query, that query will not run. QMFDQ-9107 (PMR12776) A query that has a COUNT(*) function without a column alias might not work correctly. QMFDQ-9116 If you create a query that has multiple row conditions in the SQL query editor, then switch back and forth from the Diagram to the Prompted query editors, a row condition is deleted and an error occurs. QMFDQ-9132 Every time you select Results -> Find, a different Find dialog opens. QMFDQ-9133 (PMR15973) When adding a table to a new query, the application does not remember the table owner from the previous use. QMFDQ-9134 (PMR66141) Some of the queries that are displayed in the QMF V8 List window do not appear in the application Object List dialog. QMFDQ-9137 An error may occur when attempting to set the connection of a new data source with a Direct DRDA connection. QMFDQ-9159 An error may occur when adding tables to a query using both the Diagram and Prompted query editors. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 14 ************************************************************* QMF for WebSphere 9.1 Fix Pack 14 QMFDQ-6386 Can not save a query to the QMF Catalog when using the 1200 and 13844 CCSID. QMFDQ-7884 The Create Table operation does not handle PRIMARY KEYs correctly. QMFDQ-7976 The table dialog stays open after setting a table in the Row Conditions panes. QMFDQ-8401 (PMR15973) Removed the Scan for Updates link from the Help system. QMFDQ-8480 Implemented a database-based security provider. QMFDQ-8495 (MR1216094343) Added the ability to define the default name filter. QMFDQ-8605 (PMR64011) Page footers do not display properly when printing default classic forms. QMFDQ-8619 The Rename Object dialog for QMF objects may not work correctly. QMFDQ-8631 Can not view schemas from a QMF catalog in the Explore view. QMFDQ-8635 The Explore view is not refreshed after renaming objects from a QMF catalog. QMFDQ-8639 Importing a table from a text file is not possible. QMFDQ-8640 The list of databases in the Import Table Wizard is not sorted. QMFDQ-8647 It is possible to create a data source while in the User perspective. QMFDQ-8678 Export result set generates invalid XML. QMFDQ-8685 An error might occur if you open and close the Outline view and then select a result set node. QMFDQ-8686 The Validate function in the Edit Driver Library dialog does not display errors. QMFDQ-8695 A table with double quotes in its path causes errors when you link to it. QMFDQ-8698 QMF objects are not displayed in the Repository Explorer view under the Schemas node after they are created. QMFDQ-8706 QMF catalog properties are not fully disabled in a shared repository Properties dialog after being deleted. QMFDQ-8708 The Relational Data Sources node does not automatically refresh after a data source is deleted from the Repository Explorer view. QMFDQ-8710 OLAP query dimensions aren't filled when they are expanded in the results view. QMFDQ-8720 Only the first page of OLAP query results can be viewed. QMFDQ-8725 Added support for multi-line comments in repositories. QMFDQ-8744 If a procedure has more than one hundred objects, running with DSQQW_PROC_WNDWS=0 and DSQQW_REUSE_OBJS=0 does not close the objects. QMFDQ-8749 Clicking Enter while in the Add Calculated Column dialog closes the dialog. QMFDQ-8750 The 'M' code is displayed twice in the classic report edit codes combo box. QMFDQ-8752 (PMR28520) Ampersands that are used in the Add Row Condition dialog are stripped out when the dialog closes. QMFDQ-8769 In the query results editor, selecting Grouping and Aggregation > No Aggregation does not reset the original order of the columns. QMFDQ-8770 Queries that are opened in the Query Editor are incorrectly labeled as 'Edited'. QMFDQ-8773 Joined tables are not displayed in the tables pane of the Prompted query editor. QMFDQ-8775 The up and down arrows do not work in an open content assist drop down list in the SQL query editor. QMFDQ-8778 Classic reports that are saved to the file system are assigned incorrect links. QMFDQ-8781 Improved the current security model. QMFDQ-8786 The content assist drop down list displays different values between the thin and rich client. QMFDQ-8819 (PMR78504) Users encounter the same error message over and over when in invalid user ID is entered into the Set User Information menu and Remember the Password is selected. QMFDQ-8826 (PMR74481) Copy, Paste, and Delete functions do not work in the SQL query editor. QMFDQ-8831 You can not add 'none' repositories to the Startup folder unless you expand the repository in the Repositories view. QMFDQ-8842 An error may occur when you close the Repository Explorer view after opening an object from the Recently Used folder. QMFDQ-8850 (PMR74494) The Setup delimiter options page of the Export CVS dialog should not be displayed. QMFDQ-8863 You can not switch between a query's statements and the Prompted query editor. QMFDQ-8864 A query may not refresh its tables when switching between the SQL and Prompted query editors. QMFDQ-8896 The Find and Go to menu commands do not work properly in the query results editor. QMFDQ-8899 (PMR74490) Japanese characters are incorrectly displayed in exported zip files. QMFDQ-8915 The Explore view does not refresh when you enable a QMF catalog in a data source. QMFDQ-8971 The Save As command does not update a query's name. QMFDQ-8993 (PMR76847) The WebSphere client may hang unexpectedly. QMFDQ-8996 The Data Source Connections view does not work correctly. QMFDQ-9002 Enabled case sensitivity in virtual table and column names. QMFDQ-9005 The Default resource limit group name and comment are always displayed in English. QMFDQ-9023 Running a query with substitution variables a second time fails to prompt for variable values. QMFDQ-9024 The USE procedure command connects to a repository but the Repository Connections and Repository Explorer views are not refreshed. QMFDQ-9031 In the Visual Designer page of the Preferences dialog, the data/time combo boxes contain non-translated values. QMFDQ-9032 The OLAP query selection in the New Object wizard is not enabled. QMFDQ-9034 Some expressions can not be entered in the Field cells of the Diagram query editor. QMFDQ-9038 The Workspace menu command is incorrectly present in the Repositories view context menu. QMFDQ-9047 (PMR66345) Procedures stop running when an ERASE command is set against a non-existent table. QMFDQ-9055 The Select resource limits provider page of the Create New Relational Data Source wizard should not display if the QMF plug-in is not activated. QMFDQ-9060 (PMR75953) The Query editor does not switch applications when using the Alt+Tab key combination. QMFDQ-9077 In the Diagram query editor, the Average and Sum aggregation options are incorrectly available for date and time columns. QMFDQ-9079 An error may occur when adding multiple tables to a query while in the Diagram query editor. QMFDQ-9081 If you try to run an empty query from the Layout query editor, then switch to the SQL query editor and author a query, that query will not run. QMFDQ-9107 (PMR12776) A query that has a COUNT(*) function without a column alias might not work correctly. QMFDQ-9133 (PMR15973) When adding a table to a new query, the application does not remember the table owner from the previous use. QMFDQ-9136 Exported query results files may be saved with only their file extensions in their file names. QMFDQ-9137 An error may occur when attempting to set the connection of a new data source with a Direct DRDA connection.