IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 10 Release 1, Fix Pack 7 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 10.1 FIX PACK 7 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 10.1 FIX PACK 7 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 10 Release 1, Fix Pack 7 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 10.1 FIX PACK 7 ************************************************************* QMFDQ-7324 Add the capability to export result sets to a Microsoft Excel Spreadsheet (.XLS) file. QMFDQ-12795 Implement the automatic mode for ScrollBar. QMFDQ-12914 When users try to run a query with an SQL syntax error, QMF for Workstation displays an error message but does not position the cursor to the error location. QMFDQ-13570 Analytical Query 'AppendWithSharedPrompts' in Sample repository does not work as designed. QMFDQ-13861 NullPointerException occurs when users have dashboards which contain inserted data as a query and save them as compiled visual projects. QMFDQ-14112 Two 'Enter Substitution Variable Values' windows are displayed when Create QMF Catalog Objects SQL is being created on DB2 for z/OS. QMFDQ-14136 QMF does not display an error message when a REXX procedure is run in the absence of REXX engine. QMFDQ-14138 QMF does not display an error message while running an incorrect REXX procedure in QMF batch mode. QMFDQ-14187 Add the ability to specify an hourly schedule for cache settings for resource limits, scheduled tasks, and expiration schedules. QMFDQ-14219 Add the 'HeightLimit' property to the table layout. QMFDQ-14241 'TIME STAMP WITH TIME ZONE' values are not imported properly from CSV file. QMFDQ-14294 Add the capability to export multiple result sets from one query to Excel Spreadsheets. QMFDQ-14300 Users cannot create Forecasts and Drill-down Paths if the Support for Virtual Data Sources option was not selected during the QMF installation. QMFDQ-14321 A NullPointerException occurs when users create a Visual Report based on an OLAP Query. QMFDQ-14333 In Visual dashboards, an image used for FillStyle.ImageSource property of TableCell is not exported to PDF. QMFDQ-14358 Add the capability to filter column names in the Row Conditions dialog in the Prompted Query mode. QMFDQ-14362 In Drill-down paths, the '%' symbol in column name must be replaced with an HTML-valid character sequence. QMFDQ-14368 Expression designer does not find global variables. QMFDQ-14376 Add the support for more complex conditions when SQL query is converted to a Prompted query. QMFDQ-14386 QMF result sets are exported into database tables with their original column names though the column labels are expected (when using the IBM T4 JDBC Spec 4 driver). QMFDQ-14403 Export to database code ignores DSQDC_COL_LABELS global variable value. QMFDQ-14404 Previously entered comments for the saved QMF objects are lost when these objects are resaved back to QMF catalogs. QMFDQ-14410 Add the Comment column to the Explore view. QMFDQ-14435 In Visual Dashboards, ToolTips are cut off in flash renderer if there is not enough space on the scene. QMFDQ-14459 Data is lost when CSV files are imported from the File menu. QMFDQ-14490 Add Reformat, Comment, and Uncomment items to the Query menu for Visual Queries. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 10.1 FIX PACK 7 ************************************************************* QMFDQ-7324 Add the capability to export result sets to a Microsoft Excel Spreadsheet (.XLS) file. QMFDQ-12914 When users try to run a query with an SQL syntax error, QMF for WebSphere displays an error message but does not position the cursor to the error location. QMFDQ-14112 Two 'Enter Substitution Variable Values' windows are displayed when Create QMF Catalog Objects SQL is being created on DB2 for z/OS. QMFDQ-14136 QMF does not display an error message when a REXX procedure is run in the absence of REXX engine. QMFDQ-14187 Add the ability to specify an hourly schedule for cache settings for resource limits, scheduled tasks, and expiration schedules. QMFDQ-14205 Classic report cannot be exported from the File/Send To menu. QMFDQ-14241 'TIME STAMP WITH TIME ZONE' values are not imported properly from CSV file. QMFDQ-14294 Add the capability to export multiple result sets from one query to Excel Spreadsheets. QMFDQ-14299 Implement the support for Table Editor in the Web client. QMFDQ-14321 A NullPointerException occurs when users create a Visual Report based on an OLAP Query. QMFDQ-14327 The Query Results Page Setup option is not available for all tabs of the Query editor. QMFDQ-14358 Add the capability to filter column names in the Row Conditions dialog in the Prompted Query mode. QMFDQ-14362 In Drill-down paths, the '%' symbol in column name must be replaced with an HTML-valid character sequence. QMFDQ-14376 Add the support for more complex conditions when SQL query is converted to a Prompted query. QMFDQ-14386 QMF result sets are exported into database tables with their original column names though the column labels are expected (when using the IBM T4 JDBC Spec 4 driver). QMFDQ-14410 Add the Comment column to the Explore view. QMFDQ-14459 Data is lost when CSV files are imported from the File menu. QMFDQ-14490 Add Reformat, Comment, and Uncomment items to the Query menu for visual queries.