IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 18 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 18 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 18 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 18 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 18 ************************************************************* QMFDQ-12206 Enhance the CONFIRM profile option to include support for a SELECT statement with DELETE, INSERT, and UPDATE functionality. QMFDQ-12234 An error message is displayed incorrectly when a user with Edit authorization saves table SQL for a virtual data source. QMFDQ-12273 The DRDA connection fails to process static queries of the UPDATE type when run against DB2 v8. QMFDQ-12293 The application cannot save the object to a workspace if the protection method is set to "Stored procedures" in a repository on DB2 for z/OS. QMFDQ-12355 QMF treats 'x0A' and 'x0D' characters in the SQL results as a new line, when it should not. QMFDQ-12398 It is impossible to configure Logging Levels for the QMFWin API. QMFDQ-12400 A NullPointerException occurs when the user switches from the 'Object list' tab to any other tab in the "View/Resource Limits" dialog when working with a data source that has resource limits from the QMF Catalog. QMFDQ-12459 A "Not enough permissions to perform operation" message is displayed incorrectly when calling the API "QMFWin.InitializeRepository". QMFDQ-12515 In the Prompted Query editor, a lower-level user can add a table even though they are not authorized to access the table. QMFDQ-12516 The logic used in the "Confirm database updates" should match the logic used in QMF for Windows v8. QMFDQ-12549 An empty column name might be displayed in the result set when running a query using the DRDA driver. QMFDQ-12725 The DRDA driver incorrectly treats NULL values in DOUBLE columns as zero "0". QMFDQ-12740 When removing a join condition from a query, the Diagram view shows that the join has been removed. However, when you go back into the query, the join condition has been added back into the query. QMFDQ-12753 Queries that contain UPDATE ...SET in the SQL, and a variable with name of column, is incorrectly recognized as a column by content assist. QMFDQ-12760 An SQL query’s IN clause with one parameter gets corrupted when switching to the Diagram view. QMFDQ-12790 Running Favorites reports many times in Report Center causes Report Center to hang. QMFDQ-12797 The DRDA driver contains invalid character encoding descriptors which may cause queries to return empty columns in the Results grid. QMFDQ-12809 It is impossible to save an object to the QMF Catalog if the name of the repository connection exceeds 79 characters in length. QMFDQ-12814 The existing QMF object is deleted erroneously if an error occurs when trying to save a new QMF object overwriting the existing object. QMFDQ-12823 The ROWID for a query is displayed incorrectly. QMFDQ-12837 Scheduled jobs that have been imported do not run. QMFDQ-12843 The RESET GLOBAL procedure command does not accept a closing bracket. QMFDQ-12860 A program loop results when creating a classic report for a query that contains either an INSERT or UPDATE statement. QMFDQ-12879 Database-based security requires Administrator authorization in order to expand Data Source node. Users should be able to expand a data source node without having to have ADMIN privileges. QMFDQ-12892 Support for repository object Caching functionality for saving the content of repository objects (dashboards, visual applications, queries, visual reports etc.) to memory. QMFDQ-12893 An incorrect interpretation of wildcard characters occurs in table names when QMF catalog is enabled. QMFDQ-12897 An error occurs when running the SET GLOBAL command. QMFDQ-12906 Duplicate view names are displayed in the Table list dialog. QMFDQ-12907 You cannot open a table that includes the backslash '\' symbol in its name. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 18 ************************************************************* QMFDQ-12206 Enhance the CONFIRM profile option to include support for a SELECT statement with DELETE, INSERT, and UPDATE functionality. QMFDQ-12234 An error message is displayed incorrectly when a user with Edit authorization saves table SQL for a virtual data source. QMFDQ-12263 An error message is displayed incorrectly when a user creates and saves a query to a Repository on Oracle database. QMFDQ-12273 The DRDA connection fails to process static queries of the UPDATE type when run against DB2 v8. QMFDQ-12293 The application cannot save the object to a workspace if the protection method is set to "Stored procedures" in a repository on DB2 for z/OS. QMFDQ-12355 QMF treats 'x0A' and 'x0D' characters in the SQL results as a new line, when it should not. QMFDQ-12398 It is impossible to configure Logging Levels for the QMFWin API. QMFDQ-12400 A NullPointerException occurs when the user switches from the 'Object list' tab to any other tab in the "View/Resource Limits" dialog when working with a data source that has resource limits from the QMF Catalog. QMFDQ-12459 A "Not enough permissions to perform operation" message is displayed incorrectly when calling the API "QMFWin.InitializeRepository". QMFDQ-12515 In the Prompted Query editor, a lower-level user can add a table even though they are not authorized to access the table. QMFDQ-12516 The logic used in the "Confirm database updates" should match the logic used in QMF for Windows v8. QMFDQ-12549 An empty column name might be displayed in the result set when running a query using the DRDA driver. QMFDQ-12725 The DRDA driver incorrectly treats NULL values in DOUBLE columns as zero "0". QMFDQ-12753 Queries that contain UPDATE ...SET in the SQL, and a variable with name of column, is incorrectly recognized as a column by content assist. QMFDQ-12788 It is impossible to edit a Scheduled Job in QMF for WebSphere when using a WEB services repository connection. QMFDQ-12809 It is impossible to save an object to the QMF Catalog if the name of the repository connection exceeds 79 characters in length. QMFDQ-12814 The existing QMF object is deleted erroneously if an error occurs when trying to save a new QMF object overwriting the existing object. QMFDQ-12823 The ROWID for a query is displayed incorrectly. QMFDQ-12837 Scheduled jobs that have been imported do not run. QMFDQ-12843 The RESET GLOBAL procedure command does not accept a closing bracket. QMFDQ-12844 The QMF for WebSphere application hangs then attempts to remove a scheduled task on web connection. QMFDQ-12860 A program loop results when creating a classic report for a query that contains either an INSERT or UPDATE statement. QMFDQ-12892 Support for repository object Caching functionality for saving the content of repository objects (dashboards, visual applications, queries, visual reports etc.) to memory. QMFDQ-12893 An incorrect interpretation of wildcard characters occurs in table names when QMF catalog is enabled. QMFDQ-12897 An error occurs when running the SET GLOBAL command. QMFDQ-12906 Duplicate view names are displayed in the Table list dialog. QMFDQ-12907 You cannot open a table that includes the backslash symbol '\' in its name.