IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 12 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 12 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 12 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 12 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 12 ************************************************************* QMFDQ-3639 Added the Restore Default Value button to the Properties view. QMFDQ-6244 Added support for importing CSV and TXT files as result sets. QMFDQ-6370 Added support for the "Allow access to data source from user interface" resource limit. QMFDQ-6803 Added support for the "Allow printing" and "Enable exporting of data" resource limits in virtual data sources. QMFDQ-7097 Added support to display pictures from LOB data in tool tip boxes. QMFDQ-7100 The Show in repository option of the Search in Repository dialog does not work properly for Link objects. QMFDQ-7104 The Search in selection option of the Find dialog may not work properly in the query results editor. QMFDQ-7271 In the Schedule New Job dialog, jobs may be closed before being fully scheduled. QMFDQ-7305 In visual dashboards, mouse events may run incorrectly after switching to the Flash rendering mode. QMFDQ-7321 Added support for virtual tables to the Prompted Query editor. QMFDQ-7373 An error may occur when trying to view a query that contains modifiers for string literals in the Prompted Query or Diagram Query editors. QMFDQ-7389 In the Import wizard, if a file that does not exist is specified, the Import wizard will fail to work properly afterwards. QMFDQ-7474 An error may occur when deleting several virtual data sources at once. QMFDQ-7475 Moved the Paste context menu option to right below the Copy option. QMFDQ-7479 In the Additional Parameters table of the Properties for dialog, cell editing exists for both keys and values. QMFDQ-7505 Added support for opening repository objects in an Explore window from the Open from repository dialog. QMFDQ-7506 When a new window is opened, repository connection icons are incorrect. QMFDQ-7510 An error may occur when specifying additional JDBC DB2 parameters using the JDBC URL. QMFDQ-7511 An error occurs when attempting to delete a stored function while connected to an Oracle database. QMFDQ-7514 (PMR06859) An error may occur when initializing prepackaged JDBC drivers. QMFDQ-7517 Setting the Driver property for the server is not applied during *.sdf file import. QMFDQ-7530 The Add to export button in the Export to Excel wizard is active for complex component properties. QMFDQ-7540 An error may occur when deleting table columns from a copy of an existing table. QMFDQ-7544 Table in new virtual data sources are copied incorrectly. QMFDQ-7551 In the Scheduled Jobs dialog, setting a procedure clears all variables. QMFDQ-7584 (PMR06731) When data is exported to Excel, it may be formatted differently than in previous versions of the application. QMFDQ-7591 Different logon dialogs open for data sources and data source links in the Search in Repository dialog. QMFDQ-7592 The logon dialog opens for multidimensional data sources even if the User ID and password are not required check box is checked in the repository preferences. QMFDQ-7595 If an error occurs while saving a query, the query closes without saving. QMFDQ-7598 In the Confirm Stored Procedure Parameters dialog, the combo boxes do not allow for text entry. QMFDQ-7604 The cancel button does not work properly in the uninstallation wizard. QMFDQ-7606 Product tutorials are always displayed in the English language. QMFDQ-7608 In the Export wizard, the user is prompted to replace existing data even if the append data option was selected. QMFDQ-7610 Added the Change Password button to the user logon dialog. QMFDQ-7611 Added enhancement to add objects with long owner names to the QMF Catalog in DB2 for z/OS. QMFDQ-7616 A data source that was added in the Repositories view is not available in the Set Data Source option of the Query menu. QMFDQ-7621 Added support for full text to be displayed in the tooltip of a query results cell. QMFDQ-7624 Users can change the password on z/OS base even if they do not have the z/OS license. QMFDQ-7633 In visual reports, selecting Move to the Last Page Vertically in the Flash rendering mode causes the application to hang. QMFDQ-7635 An error may occur when deleting multiple tables in the Repository Explorer view. QMFDQ-7636 The focus does not set to the last editor in a procedure. QMFDQ-7637 Added enhancement to group all customizable object names in one Enter Substitution Variables dialog. QMFDQ-7669 (PMR67135) JDBC driver installation information may not be copied into the workstation directory correctly when running a silent installation. QMFDQ-7673 If an EXPORT command is used without a specified CCSIP parameter, the CCSID from the Results/Export/CSV/CCSID setting is not used. QMFDQ-7674 Added the ability to select the rendering mode from a visual project. QMFDQ-7678 Added the ability for users to change their database passwords and use logon information for every server. QMFDQ-7679 Added the Set Row Limit option to the Query menu. QMFDQ-7699 An error may occur when attempting to join two virtual tables. QMFDQ-7701 Columns that are moved to the side group in the query result set do not resize to fit the data values. QMFDQ-7703 Can not drag and drop virtual tables into the Query Diagram editor. QMFDQ-7704 Count values in the summary line of query results are displayed in the float data format. QMFDQ-7705 In query results, selecting the count option from the Grouping and Aggregation menu does not automatically show total summaries. QMFDQ-7717 Running a procedure with a MAIL TO command that does not specify an SMTP server multiple times causes duplicate file extensions in the procedure. QMFDQ-7718 (PMR31996) Added an enhancement to specify both CCSID numerals and Java encoding names for CCSID encoding pages in the EXPORT procedure command. QMFDQ-7726 (PMR07871) Errors may occur when attempting to access indexes for hidden columns in DB2. QMFDQ-7737 An error may occur while granting permissions for stored procedures in the Protection page of the Create New Repository Storage wizard. QMFDQ-7740 An error occurs if you attempt to paste a copied table after disconnecting from the table's data source. QMFDQ-7766 An error may occur when working with protected repository storage created in an Oracle database. QMFDQ-7773 Enhanced the performance of repository operations for multiple objects. QMFDQ-7799 The error messages were added to the documentation. QMFDQ-7806 Glossaries were added to the documentation. QMFDQ-7826 An error may occur when attempting to export a visual report created using QMF for Windows using the EXPORT REPORT TO procedure command. QMFDQ-7837 The start date for the trial license is calculated incorrectly. QMFDQ-7861 Added enhancement to prompt the user to save an object that has been modified since being opened. QMFDQ-7876 The MAIL TO procedure command does not strip out single quotes from SUBJECT and BODY parameters. QMFDQ-7883 (PMR31996) When exporting data in UTF16 encoding, byte-order-marks are not included in output files. QMFDQ-7898 Added support for U2 databases. QMFDQ-7910 (PMR64149) Incorrect column headers may be displayed working with DB2 for iSeries. QMFDQ-7930 When a procedure runs a query from a repository, the query is marked as changed. QMFDQ-7931 QMF objects such as queries, forms and procedures are saved at files in ANSI encoding instead of UCS-2. QMFDQ-7955 (PMR49106) An error may occur when exporting data to the dBASE file format. QMFDQ-7967 Components move after changing the section height in a Visual Report. QMFDQ-7983 An error may occur when exporting an IXF file for the first time. QMFDQ-7991 The Move up and Move down arrows do not work in the Layout view of a query. QMFDQ-8092 An error occurs while attempting to create a new workspace through the Repositories view. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 12 ************************************************************* QMFDQ-3639 Added the Restore Default Value button to the Properties view. QMFDQ-6244 Added support for importing CSV and TXT files as result sets. QMFDQ-6370 Added support for the "Allow access to data source from user interface" resource limit. QMFDQ-6586 (PMR23087) Added support for Print Scene action. QMFDQ-6803 Added support for the "Allow printing" and "Enable exporting of data" resource limits in virtual data sources. QMFDQ-7100 The Show in repository option of the Search in Repository dialog does not work properly for Link objects. QMFDQ-7104 The Search in selection option of the Find dialog may not work properly in the query results editor. QMFDQ-7271 In the Schedule New Job dialog, jobs may be closed before being fully scheduled. QMFDQ-7241 In the Results menu, the options in the Grouping and Aggregation context menu are doubled every time the user switches to the Results tab in the query editor. QMFDQ-7300 After switching to English from another locale, currency symbols may display incorrectly in the query results window. QMFDQ-7305 In visual dashboards, mouse events may run incorrectly after switching to the Flash rendering mode. QMFDQ-7321 Added support for virtual tables to the Prompted Query editor. QMFDQ-7373 An error may occur when trying to view a query that contains modifiers for string literals in the Prompted Query or Diagram Query editors. QMFDQ-7389 In the Import wizard, if a file that does not exist is specified, the Import wizard will fail to work properly afterwards. QMFDQ-7419 Prompted queries are saved with the *.qry file extension. QMFDQ-7505 Added support for opening repository objects in an Explore window from the Open from repository dialog. QMFDQ-7511 An error occurs when attempting to delete a stored function while connected to an Oracle database. QMFDQ-7514 (PMR06859) An error may occur when initializing prepackaged JDBC drivers. QMFDQ-7517 Setting the Driver property for the server is not applied during *.sdf file import. QMFDQ-7548 If using Internet Explorer 7, the formatting of procedure text may display incorrectly. QMFDQ-7559 When the application is reopened, you do not return to the last opened perspective. QMFDQ-7575 Clicking anywhere in the query editor returns the cursor to the first line of the query. QMFDQ-7602 The Browse button does not work properly in the Import Conditions From File dialog. QMFDQ-7611 Objects with long owner names cannot be saved in the QMF Catalog in DB2 for z/OS. QMFDQ-7618 If the locale settings are changed, the next time a session is started, the startup screen will display with the previous language. QMFDQ-7633 In visual reports, selecting Move to the Last Page Vertically in the Flash rendering mode may cause the application to hang. QMFDQ-7662 Added dynamic theme support, which allows users to control the look and feel of the WebSphere user interface. QMFDQ-7666 Added an OSGI-console page. QMFDQ-7667 Added translations to the UI elements that belong to Eclipse platform. QMFDQ-7674 Added the ability to select the rendering mode when opening visual project. QMFDQ-7678 Added support for "Allow Users to Change Password" and "Use this information for every server I connect to" connection properties. QMFDQ-7679 Added the Set Row Limit option to the Query menu. QMFDQ-7699 An error may occur when attempting to join two virtual tables. QMFDQ-7717 Running a procedure with a MAIL TO command that does not specify an SMTP server multiple times causes duplicate file extensions in the procedure. QMFDQ-7718 (PMR31996) Added an enhancement to specify both CCSID numerals and Java encoding names for CCSID encoding pages in the EXPORT procedure command. QMFDQ-7726 (PMR07871) Errors may occur when trying to access indexes for hidden columns in DB2. QMFDQ-7766 An error may occur when working with protected repository storage created in an Oracle database. QMFDQ-7773 Enhanced the performance of repository operations for multiple objects. QMFDQ-7795 The MAIL TO VISUAL REPORT procedure command does not work properly. QMFDQ-7799 The error messages were added to the documentation. QMFDQ-7806 Glossaries were added to the documentation. QMFDQ-7826 An error may occur when attempting to export a visual report created using QMF for Windows using the EXPORT REPORT TO procedure command. QMFDQ-7837 The start date for the trial license is calculated incorrectly. QMFDQ-7861 Added enhancement to prompt the user to save an object that has been modified since being opened. QMFDQ-7876 The MAIL TO procedure command does not strip out single quotes from SUBJECT and BODY parameters. QMFDQ-7879 (PMR39284) When a DBCS named query result set is exported to a CSV file, the CSV file may not be able to be opened. QMFDQ-7883 (PMR31996) When exporting data in UTF16 encoding, byte-order-marks are not included in output files. QMFDQ-7898 Added support for U2 databases. QMFDQ-7910 (PMR64149) Incorrect column headers may be displayed working with DB2 for iSeries. QMFDQ-7930 When a procedure runs a query from a repository, the query is marked as changed. QMFDQ-7931 QMF objects such as queries, forms and procedures are saved at files in ANSI encoding instead of UCS-2. QMFDQ-7955 (PMR49106) An error may occur when exporting data to the dBASE file format. QMFDQ-7983 An error may occur when exporting an IXF file for the first time. QMFDQ-7991 The Move up and Move down arrows do not work in the Layout view of a query. QMFDQ-8072 An error may occur when attempting to mail a visual report using the MAIL TO procedure command.