IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 13 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 13 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 13 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 13, 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 13 ************************************************************* QMF for Workstation 9.1 Fix Pack 13 QMFDQ-594 Implemented the DSQQW_REUSE_OBJS global variable, that specifies whether objects that are already open in a window are retrieved or if the existing window is used. QMFDQ-772 Added the ability to bind packages using a command line option. QMFDQ-2918 It is not possible to set an empty string as the default null value in the Preferences dialog. QMFDQ-3118 An error may occur when setting an overly long table name in the Repository Explorer. QMFDQ-4021 In visual reports, columns may be truncated when the default language is set to Japanese. QMFDQ-6397 The Move to the Next Page icon in the Preview tab may not work correctly if the page setup is changed. QMFDQ-6776 Added support for JNDI data sources. QMFDQ-7186 Tables that have special characters as the first character in their names may not be able to be opened. QMFDQ-7345 Classic reports with landscape orientation export with portrait orientation. QMFDQ-7500 When adding a new schedule to the scheduled job list, if you delete a job, the list will not refresh. QMFDQ-7617 When opening a second query while a previous query is running, the previous query's Results tab may not open. QMFDQ-7875 User defined results grid column headers are lost after editing the query SQL text. QMFDQ-7932 Fixed several issues with the job scheduler function. QMFDQ-7958 Added the ability to determine whether or not a scene is running in an embedded scene object. QMFDQ-7970 Login mapping does not work properly in repositories protected by LDAP security provider. QMFDQ-7985 An error may occur when double-clicking on a table in the Explorer view when the default action is run object. QMFDQ-7999 It is impossible to create a copy of a workspace with the same name within the same repository. QMFDQ-8083 When importing a table from a file, the owner name is incorrectly displayed as the table name in the Repository Explorer view. QMFDQ-8148 Added the ability to drag-and-drop fields between two open queries in the Layout editor. QMFDQ-8153 Added support for QMF catalogs and repository storage on DB2 z/OS V10. QMFDQ-8159 The PRINT TABLE procedure command may work incorrectly. QMFDQ-8163 Queries are not marked as changed when their row limit is changed. QMFDQ-8181 The Show in Repository action does not work properly in the Explorer view. QMFDQ-8196 (PMR15968) (PMR26503) The Ctrl+R and Ctrl+B functions to run a query and to display an Excel Sheet do not work correctly. QMFDQ-8206 A cyclic error message may be displayed when entering invalid login details for a multidimensional data source. QMFDQ-8215 Added the ability to specify the encoding for an imported SDF file. QMFDQ-8216 (PMR15966) In the Prompted query editor, date values in the Row Conditions dialog may be expressed incorrectly in the SQL query editor. QMFDQ-8252 Procedure that opens multiple objects activate the first one when finished. QMFDQ-8301 In classic reports, summary lines may be incorrectly aligned. QMFDQ-8308 When importing IXF files, timestamp values with a year less than 1900 import incorrectly. QMFDQ-8346 (PMR26503) Substitution variables in a procedure are prompted alphabetically rather than how they are ordered in the procedure. QMFDQ-8359 In classic reports, the Across heading separator option was not taken into account. QMFDQ-8382 The DSQQW_SV_DATA_T_M global variable may not work properly. QMFDQ-8390 Several memory leaks cause error messages after a certain amount of processing time. QMFDQ-8399 (PMR15973) When using greater than functions for row conditions in the Prompted query editor, spaces are not quoted correctly. QMFDQ-8418 (PMR00913) When a column is added in the Prompted query editor, if you switch to the SQL query editor, extra spaces may be added around column names. QMFDQ-8419 (PMR15969) In the query results editor, the horizontal scroll bar automatically scrolls to the very end of the page. QMFDQ-8422 (PMR28104) If there are any incorrect parameters in LDAP configuration, it is impossible to go back and edit settings. QMFDQ-8429 An error may occur when you drag an image from the Project Explorer to a visual report. QMFDQ-8435 It is impossible to join tables from a virtual data source using the Diagram editor. QMFDQ-8436 (PMR68764) An error may occur during customization/bind against DB2 z/OS if the decimal delimiter is set to comma. QMFDQ-8439 Aggregation of columns is lost when you change the order of columns in the Layout query editor. QMFDQ-8442 Added support for parameters in virtual table SQL. QMFDQ-8447 An error may occur when running a procedure that contains the ERASE command. QMFDQ-8455 (PMR29539) An error may occur after installing a fix pack using a silent installation. QMFDQ-8460 When the DSQQW_REUSE_OBJS global variable equals zero, results in only the first and last query grids are populated. QMFDQ-8461 When the Display null values as preference is changed in the Appearance preference page, the Results page of the query results editor is not refreshed. QMFDQ-8474 It is impossible to create a new LDAP repository without providing a master account in the LDAP security provider options page. QMFDQ-8481 Edited LDAP repository properties only take effect after the application is restarted. QMFDQ-8485 (PMR94255) Added the ability to change a QMF object's owner and name. QMFDQ-8494 Added the ability to display the database account in a query tab's tooltip. QMFDQ-8496 Added the ability to drag and drop tables and columns into the Prompted query editor. QMFDQ-8506 An incorrect error message is displayed when an overly long name is entered during a rename action in the Repository Explorer view. QMFDQ-8533 Owner settings are not retained in the Display Report dialog. QMFDQ-8535 Added toleration of unsupported QMF TSO commands. QMFDQ-8536 Added the ability to import dBase files. QMFDQ-8605 (PMR64011) In classic reports, the page footer may not display if options are changed in the Page Setup dialog. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 13 ************************************************************* QMFDQ-594 Implemented the DSQQW_REUSE_OBJS global variable, that specifies whether objects that are already open in a window are retrieved or if the existing window is used. QMFDQ-772 Added the ability to bind packages using a command line option. QMFDQ-2918 It is not possible to set an empty string as the default null value in the Preferences dialog. QMFDQ-3118 An error may occur when setting an overly long table name in the Repository Explorer. QMFDQ-4021 In visual reports, columns may be truncated when the default language is set to Japanese. QMFDQ-6397 The Move to the Next Page icon in the Preview tab may not work correctly if the page setup is changed. QMFDQ-6776 Added support for JNDI data sources. QMFDQ-7186 Tables that have special characters as the first character in their names may not be able to be opened. QMFDQ-7500 When adding a new schedule to the scheduled job list, if you delete a job, the list will not refresh. QMFDQ-7617 When opening a second query while a previous query is running, the previous query's Results tab may not open. QMFDQ-7662 Added support for user interface themes. QMFDQ-7875 User defined results grid column headers are lost after editing the query SQL text. QMFDQ-7985 An error may occur when double-clicking on a table in the Explorer view when the default action is run object. QMFDQ-8083 When importing a table from a file, the owner name is incorrectly displayed as the table name in the Repository Explorer view. QMFDQ-8105 Added the ability to remember user names and passwords in getObject mode. QMFDQ-8142 Can not copy a visual report between repositories. QMFDQ-8153 Added support for QMF catalogs and repository storage on DB2 z/OS V10. QMFDQ-8159 The PRINT TABLE procedure command may work incorrectly. QMFDQ-8181 The Show in Repository action does not work properly in the Explorer view. QMFDQ-8196 (PMR15968) (PMR26503) The Ctrl+R and Ctrl+B functions to run a query and to display an Excel Sheet do not work correctly. QMFDQ-8206 A cyclic error message may be displayed when entering invalid login details for a multidimensional data source. QMFDQ-8215 Added the ability to specify the encoding for an imported SDF file. QMFDQ-8216 (PMR15966) In the Prompted query editor, date values in the Row Conditions dialog may be expressed incorrectly in the SQL query editor. QMFDQ-8252 Procedure that opens multiple objects activate the first one when finished. QMFDQ-8269 Images are not included when exporting visual report into HTML file. QMFDQ-8301 In classic reports, summary lines may be incorrectly aligned. QMFDQ-8308 When importing IXF files, timestamp values with a year less than 1900 import incorrectly. QMFDQ-8346 (PMR26503) Substitution variables in a procedure are prompted alphabetically rather than how they are ordered in the procedure. QMFDQ-8359 In classic reports, the Across heading separator option was not taken into account. QMFDQ-8373 Added paging support to large tree views. QMFDQ-8382 The DSQQW_SV_DATA_T_M global variable may not work properly. QMFDQ-8390 Several memory leaks cause error messages after a certain amount of processing time. QMFDQ-8399 (PMR15973) When using greater than functions for row conditions in the Prompted query editor, spaces are not quoted correctly. QMFDQ-8418 (PMR00913) When a column is added in the Prompted query editor, if you switch to the SQL query editor, extra spaces may be added around column names. QMFDQ-8419 (PMR15969) In the query results editor, the horizontal scroll bar automatically scrolls to the very end of the page. QMFDQ-8422 (PMR28104) If there are any incorrect parameters in LDAP configuration, it is impossible to go back and edit settings. QMFDQ-8436 (PMR68764) An error may occur during customization/bind against DB2 z/OS if the decimal delimiter is set to comma. QMFDQ-8442 Added support for parameters in virtual table SQL. QMFDQ-8447 An error may occur when running a procedure that contains the ERASE command. QMFDQ-8475 The comment field does not work properly when creating a repository. QMFDQ-8478 Multiword values may be displayed incorrectly in the Results page of the query results editor. QMFDQ-8485 (PMR94255) Added the ability to change a QMF object's owner and name. QMFDQ-8494 Added the ability to display the database account in a query tab's tooltip. QMFDQ-8506 An incorrect error message is displayed when an overly long name is entered during a rename action in the Repository Explorer view. QMFDQ-8532 Improved support for cluster environments. QMFDQ-8533 Owner settings are not retained in the Display Report dialog. QMFDQ-8535 Added toleration of unsupported QMF TSO commands. QMFDQ-8536 Added the ability to import dBase files. QMFDQ-8605 (PMR64011) In classic reports, the page footer may not display if options are changed in the Page Setup dialog.