IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 17 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 17 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 17 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 17 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 17 ************************************************************* QMFDQ-9932 There is a problem with copy/paste data with 'lowval' to MS Excel with QMF. QMFDQ-10224 The report does not print in HTML format even though the global variable DSQQW_RPT_OUT_TYP is set to 2 (DSQQW_RPT_OUT_TYP = 2). QMFDQ-10704 The RUN QUERY (CONFIRM=YES) parameter does not work when running the query from a procedure. So the user is not prompted about whether to apply the updates to the database. QMFDQ-11304 Implemented methods to work with repository connections in the QMF for Windows API. QMFDQ-11340 Unable to print a Resultset using the "print query" command. QMFDQ-11349 Support for the IBM solidDB database has been added. QMFDQ-11382 Prompted queries do not handle parameters in XML functions correctly when switching from the SQL view to the Prompted view. QMFDQ-11383 User interface hangs when the user tries to run a query after switching from the SQL view to Prompted view. QMFDQ-11411 The 'Set Name Filter' for a relational data source returns an incorrect list of owners when the data source contains owners with identical names that are specified using a different case (for example "owner name" and "OWNER NAME"). QMFDQ-11444 After the user selects Query/Prepare an exception occurs. QMFDQ-11447 The user cannot edit resource limit values for a repository when using a DRDA driver in static queries protection mode. QMFDQ-11464 Procedures stored in a common QMF catalog on a DB2 database other than the one housing the tables of interest and with a different login/password cannot be run from a Job. QMFDQ-11542 The DRDA driver fails to get the list of schemas for user that has an unprivileged login. QMFDQ-11552 The process for configuring repository storage protection mode has been simplified. QMFDQ-11607 The "EXPORT TABLE" procedure command fails to dispose of the Query after the operation completes. QMFDQ-11760 The product allows the user to select "Static SQL packages" protection mode for an iSeries Toolbox driver even though that driver does not support this type of protection mode. QMFDQ-11761 DB2 for VM/VSE databases are incorrectly classified due to incorrect or incomplete database signatures defined in the product. QMFDQ-11777 Non-English locale data is exported with wrong symbols (for separating, null values) in situations where the original exported data was performed using the English locale. QMFDQ-11831 An error message occurs when the user tries to synchronize an offline Virtual Data Source with a copied table. QMFDQ-11841 An unused option "What data" is presented on the 'Setup save options' page of the wizard when importing a table. QMFDQ-11866 The product incorrectly detects an XML data type with DB2 JDBC 4 driver. QMFDQ-11886 The product provides incomplete support for the XML data type for MS SQL Server database. The product should provide separate native type for data type XML. QMFDQ-11908 In the QMF Report Center, the "Set User Information" dialog box displays the repository connection name instead of database name. QMFDQ-11957 A NullPointerException error occurs when creating the repository with database-based security if the repository with the same name already exists. QMFDQ-11967 The QMF for Windows API prompts twice for secure repository even when security is "database-based". QMFDQ-11970 The tilde (~) DBCS character (0x8160) is displayed incorrectly in reports generated by Report Center. QMFDQ-11975 Procedure-generated reports run from a batch program are not being formatted in a way that is consistent with running the reports from the workstation. QMFDQ-11984 Support has been added for Global Variable DSQEC_RUN_MQ, which determines whether multistatement SQL queries can be run. QMFDQ-12079 QMF objects with names that start with "." (dot) are not copied from QMF catalog to repository. QMFDQ-12101 An "Application error index 0, size 0" error occurs when creating objects for a new shared repository that uses the Distributed Relational Database Architecture (DRDA) driver to connect to DB2. QMFDQ-12104 An "SQM02008 database access error" occurs when the system attempts to connect to a database using the DRDA driver type after modifications were made to the repository or QMF structures. QMFDQ-12118 After exporting a classic report by using the EXPORT REPORT command, the calculated column does not display in the Report tab. QMFDQ-12120 Add capability to control line width when reformatting SQL queries. QMFDQ-12177 The RDBI.SERVER_INFO is missing when creating the database objects. QMFDQ-12184 The message 'Illegal date or time format detected' displays after running the query with XML aggregation using the DRDA driver. QMFDQ-12203 A NullPointerException error occurs while using Content Assistant. QMFDQ-12235 Table in virtual data source disappears after a user with Full Permission security level changes the table SQL by using the 'Edit SQL Table' operation. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 17 ************************************************************* QMFDQ-10224 The report does not print in HTML format even though the global variable DSQQW_RPT_OUT_TYP is set to 2 (DSQQW_RPT_OUT_TYP = 2). QMFDQ-11349 Support for the IBM solidDB database has been added. QMFDQ-11351 The "Show In Repository" action does not display expected results from activity in QMF catalog. QMFDQ-11383 User interface hangs when the user tries to run a query after switching from the SQL view to Prompted view. QMFDQ-11411 The 'Set Name Filter' for a relational data source returns an incorrect list of owners when the data source contains owners with identical names that are specified using a different case (for example "owner name" and "OWNER NAME"). QMFDQ-11425 The export to Excel operation does not export the entire Resultset. QMFDQ-11444 After the user selects Query/Prepare an exception occurs. QMFDQ-11464 Procedures stored in a common QMF catalog on a DB2 database other than the one housing the tables of interest and with a different login/password cannot be run from a Job. QMFDQ-11542 The DRDA driver fails to get the list of schemas for user that has an unprivileged login. QMFDQ-11552 The process for configuring repository storage protection mode has been simplified. QMFDQ-11607 The "EXPORT TABLE" procedure command fails to dispose of the Query after the operation completes. QMFDQ-11760 The product allows the user to select "Static SQL packages" protection mode for an iSeries Toolbox driver even though that driver does not support this type of protection mode. QMFDQ-11866 The product incorrectly detects an XML data type with DB2 JDBC 4 driver. QMFDQ-11886 The product provides incomplete support for the XML data type for MS SQL Server database. The product should provide separate native type for data type XML. QMFDQ-11972 Nothing happens when you try to import certain queries (with large comments) from QMF for Windows V8 into QMF WebSphere V9. QMFDQ-11984 Support has been added for Global Variable DSQEC_RUN_MQ, which determines whether multistatement SQL queries can be run. QMFDQ-12003 Some characters entered in SQL query text are converted to HTML special symbols, rather than being encoded. QMFDQ-12079 QMF objects with names that start with "." (dot) are not copied from QMF catalog to repository. QMFDQ-12101 An "Application error index 0, size 0" error occurs when creating objects for a new shared repository that uses the Distributed Relational Database Architecture (DRDA) driver to connect to DB2. QMFDQ-12104 An "SQM02008 database access error" occurs when the system attempts to connect to a database using the DRDA driver type after modifications were made to the repository or QMF structures. QMFDQ-12118 After exporting a classic report by using the EXPORT REPORT command, the calculated column does not display in the Report tab. QMFDQ-12120 Add capability to control line width when reformatting SQL queries. QMFDQ-12177 The RDBI.SERVER_INFO is missing when creating the database objects. QMFDQ-12184 The message 'Illegal date or time format detected' displays after running the query with XML aggregation using the DRDA driver. QMFDQ-12235 Table in virtual data source disappears after a user with Full Permission security level changes the table SQL by using the 'Edit SQL Table' operation.