IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 5 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 5 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 5 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 5 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 5 ************************************************************* QMFDQ-280 Exception occurs when opening a file with a .xml extension and that file is not in XML format. QMFDQ-698 Progress information is now displayed when copying entries between repositories. QMFDQ-948 Error can occur when opening a XML table using the 'Open from file' command. QMFDQ-2984 Visual report generated from a classic report can contain a corrupted calculated column. QMFDQ-3067 The 'Require use of this catalog when accessing the current server' checkbox is missing from the QMF plugin parameters dialog. QMFDQ-3106 Error can occur when viewing a visual report in 'Preview' mode and the 'NewPage' property value is set to true. QMFDQ-3107 The 'FixedPages' property value for a visual report is corrupted after viewing the report in 'Preview' mode. QMFDQ-3141 Creating, saving and deleting objects using procedure commands will now trigger a refresh of the Repository Explorer, Repositories, and Workspaces views. QMFDQ-3151 Unable to store a comment when updating a table. QMFDQ-3163 Error occurs when the 'Name' tab in the 'Data Source Connections' view is selected. QMFDQ-3181 Errors can occur when protecting QMF catalog tables using stored procedures and if specified collection ID already exists. QMFDQ-3244 Data source name is not shown in Set Name Filter dialog. QMFDQ-3266 Cache resource limits should be disabled if caching is not enabled. QMFDQ-3395 More information is included in the error message that is issued when a database that does not have a JDBC driver installed is accessed. QMFDQ-3414 Improper update of global variables DSQAO_OBJ_NAME and DSQAO_OBJ_QWNER when a new object is saved to a repository. QMFDQ-3416 Unable to set a default result set number in a stored procedure using the global variable DSQEC_SP_RS_NUM. QMFDQ-3423 Exception can occur when placing the reserved variable &REF in the heading of a classic report. QMFDQ-3441 Provide the ability to page through content in the SQL and MDX editors using the page up/page down buttons. QMFDQ-3442 The list of tables is truncated in the 'Draw Query' dialog. QMFDQ-3455 Enhancement to automatically add the appropriate file extension when saving objects to a file and to automatically remove the file extension when saving the file back into the repository. QMFDQ-3457 All saved projects in the Project Explorer should be closed by selecting 'Close All Saved’ from the File menu. QMFDQ-3460 Exception occurs if one proceeds with the draw query wizard after repeatedly canceling the database logon prompt. QMFDQ-3462 A selected roll-up row in the data grid remains partially selected after the row is expanded by clicking on the plus sign. QMFDQ-3464 Under certain conditions, expanding and collapsing grid roll-ups results in the incorrect placement of the plus and minus signs in the grid cells. QMFDQ-3476 Support has been added for BIGINT values in the query diagram and prompted query editors. QMFDQ-3489 After receiving an error while attempting to add a non-existent data source (e.g. BadDBName1), further attempts to add other non-existent data sources (e.g. BadDBName2) will continue to report the error related to the first data source (BadDBName1). QMFDQ-3492 Expression Designer does not keep an accurate record of the typing order of expressions, leading to an incorrect 'Undo' and 'Redo' history. QMFDQ-3497 Support added to automatically upgrade a repository when an administrator attempts to connect to a repository with an obsolete structure. QMFDQ-3500 Quoted values associated with query column names that are also quoted are preserved in the row conditions section of the prompted query facility. QMFDQ-3510 Error occurs displaying references associated with a query which cites a non-existent table. QMFDQ-3511 Error occurs displaying references associated with a query which contains a ‘count(*) as alias’ expression. QMFDQ-3513 Saving data to a data source that does not permit such actions results in an incomplete error message. QMFDQ-3518 Instances of a matched item in the data grid are not progressively highlighted as the user selects the ‘Find Next’ button. QMFDQ-3524 Added the ability to type content directly into report labels when the label is selected in the design mode (without the need to click twice to enter edit mode). QMFDQ-3526 A query displays redundant references when the SQL references the same columns with and without an alias. QMFDQ-3527 Adding a carriage return within a quoted value in the SQL editor results in incorrect SQL colorization. QMFDQ-3544 Unable to copy the contents of a label using the Ctrl+C keystroke combination. QMFDQ-3545 Visual reports do not support global variables that are defined at the application level (including QMF global variables). QMFDQ-3549 Added global variable value is not used if the variable already has a cached value. QMFDQ-3555 Exception can occur when exporting query results while connected to a repository with no data source definitions. QMFDQ-3574 Unable to view a query in the query diagram or prompted query editor if the query text is fully enclosed within parenthesis. QMFDQ-3580 Cancelling a query which has returned a partial result set does not release the database connection and has no effect on the suspended query state. QMFDQ-3592 Adding corrupt or unsupported JPG files results in an application error or blank rendering of the JPG content, depending on the nature of the JPG file. QMFDQ-3618 The DSQAO_CURSOR_OPEN global variable always reports the value of 2, irrespective of the state of the database cursor. QMFDQ-3653 Unable to create a global variable and set its value to a single quote using the following procedure statement: SET GLOBAL (VARNAME=' QMFDQ-3563 Invalid connection information is added to a visual project when incorrect logon information is specified while adding a data source connection to the project. QMFDQ-3571 Query results grid scrolls its content horizontally while selecting multiple vertical rows. QMFDQ-3572 Unable to use 'Find' or 'Replace' in the Output view. QMFDQ-3573 Unable to distinguish between double and single quote characters in the Expression Designer text box when the characters are used adjacent to each other. QMFDQ-3587 The ‘rename’ context menu item, offered within the repository search results, does not carry out the rename action when selected by the user. QMFDQ-3599 Subsequent resizing of a label, whose 'Height' property is set to 0, using the mouse alters the height of the label in design mode. QMFDQ-3600 Label content is not clipped to the label’s bounds when the report is displayed in ‘Print Preview’ mode. QMFDQ-3611 Properties view does not remain set on the last selected component when the report is moved from design mode to runtime mode. QMFDQ-3613 Conditional formatting expressions in the results grid do not accept conditions that contain negative numbers. QMFDQ-3624 Unable to add an item from the report palette using a copy and paste action, despite these options being listed in the respective context menus. QMFDQ-3635 Error can occur if quotes are removed from a query alias which is also a reserved word and the query is subsequently saved to a file. QMFDQ-3669 The '/Batch' command line parameter results in a ‘file not found’ error. QMFDQ-3689 A true 'Stretch' image property value is ignored when running a report in HTML mode. QMFDQ-3702 Report objects may be removed when ungrouping collections which contain the same child object names. QMFDQ-3709 A visual report project may incorrectly remain open when a user switches repositories. QMFDQ-3713 The Command Library interface does not support the execution of objects stored in arbitrary repository locations; objects must reside in a QMF catalog. QMFDQ-3722 The repository creation mechanism does not check for the existence of the RSBI database logon when creating a repository within SQL server. This results in an error message should the account already exist within the database. QMFDQ-3725 Duplicate mapping values are presented in the LOB file extension mapping dialog. QMFDQ-3744 After setting the height of a report image to zero, attempts to resize the image using the mouse result in the incorrect rendering of the image in design mode. QMFDQ-3751 An open visual report project may not be listed if the project was opened while the Project Explorer was hidden from view. QMFDQ-3756 The error message region at the top of the Expression Designer should include a vertical scrollbar since the error message often exceeds the allocated area. QMFDQ-3779 Error occurs when re-running a query whose previously run query results had columns deleted. QMFDQ-3780 Users without rights to the SYSIBM.SYSDUMMY1 table cannot connect to a repository. QMFDQ-3783 Unable to create a repository within an Oracle database that is secured with LDAP-based authentication. QMFDQ-3788 Unable to update Oracle-based repositories. QMFDQ-3824 SQL statements that use the ‘Select Into’ clause against Informix databases fail to execute due to the erroneous addition of optimization clauses. QMFDQ-3834 Error can occur when saving an object (query, report, form) to a workspace if the object has the same name as an existing object in the workspace. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF for WebSphere 9.1 Fix Pack 5 ************************************************************* QMFDQ-877 Unable to configure JDBC drivers by copying driver file to WEB-INF/Config. QMFDQ-3023 In BiDi version of QMF for WebSphere Administrator some icons overlap text in the sidebar tree. QMFDQ-3080 Error can occur when testing the connection to a data source that does not require login information. QMFDQ-3083 In QMF for WebSphere Administrator, options to create a QMF catalog on a non-DB2 data source should be disabled. QMFDQ-3106 Error can occur when viewing a visual report in 'Preview' mode and the 'NewPage' property value is set to true. QMFDQ-3266 Cache resource limits should be disabled if caching is not enabled. QMFDQ-3410 Header items display incorrectly in the query results grid when the horizontal alignment is set to left justify. QMFDQ-3412 Error can occur when creating a side group from the Layout tab in the query results window. QMFDQ-3414 Improper update of global variables DSQAO_OBJ_NAME and DSQAO_OBJ_QWNER when a new object is saved to a repository. QMFDQ-3416 Unable to set a default result set number in a stored procedure using the global variable DSQEC_SP_RS_NUM. QMFDQ-3424 Added 'Restore to default' button to the Global Variables dialog. QMFDQ-3429 Error occurs using the IMPORT query from file procedure command. QMFDQ-3431 Application hangs when adding a new global variable after the SHOW global variables procedure command has run. QMFDQ-3455 Enhancement to automatically add the appropriate file extension when saving objects to a file and to automatically remove the file extension when saving the file back into the repository. QMFDQ-3464 Under certain conditions, expanding and collapsing grid roll-ups results in the incorrect placement of the plus and minus signs in the grid cells. QMFDQ-3476 Support has been added for BIGINT values in the query diagram and prompted query editors. QMFDQ-3497 Support added to automatically upgrade a repository when an administrator attempts to connect to a repository with an obsolete structure. QMFDQ-3500 Quoted values associated with query column names that are also quoted are preserved in the row conditions section of the prompted query facility. QMFDQ-3510 Error occurs displaying references associated with a query which cites a non-existent table. QMFDQ-3511 Error occurs displaying references associated with a query which contains a ‘count(*) as alias’ expression. QMFDQ-3513 Saving data to a data source that does not permit such actions results in an incomplete error message. QMFDQ-3526 A query displays redundant references when the SQL references the same columns with and without an alias. QMFDQ-3527 Adding a carriage return within a quoted value in the SQL editor results in incorrect SQL colorization. QMFDQ-3545 Visual reports do not support global variables that are defined at the application level (including QMF global variables). QMFDQ-3549 Added global variable value is not used if the variable already has a cached value. QMFDQ-3574 Unable to view a query in the prompted query editor if the query text is fully enclosed within parenthesis. QMFDQ-3580 Cancelling a query which has returned a partial result set does not release the database connection and has no effect on the suspended query state. QMFDQ-3592 Adding corrupt or unsupported JPG files results in an application error or blank rendering of the JPG content, depending on the nature of the JPG file. QMFDQ-3618 The DSQAO_CURSOR_OPEN global variable always reports the value of 2, irrespective of the state of the database cursor. QMFDQ-3653 Unable to create a global variable and set its value to a single quote using the following procedure statement: SET GLOBAL (VARNAME=' QMFDQ-3689 A true 'Stretch' image property value is ignored when running a report in HTML mode. QMFDQ-3719 A ‘conversion error’ message may appear after enabling the QMF Catalog plug-in against a SQL Server database. QMFDQ-3722 The repository creation mechanism does not check for the existence of the RSBI database logon when creating a repository within SQL server. This results in an error message should the account already exist within the database. QMFDQ-3723 The EXPORT procedure command does not support the exporting of results to a file when running via a web browser. QMFDQ-3724 Exporting the results of an open query view to a file results in the query tab being renamed to that of the results file. QMFDQ-3725 Duplicate mapping values are presented in the LOB file extension mapping dialog. QMFDQ-3779 Error occurs when re-running a query whose previously run query results had columns deleted. QMFDQ-3780 Users without rights to the SYSIBM.SYSDUMMY1 table cannot connect to a repository. QMFDQ-3783 Unable to create a repository within an Oracle database that is secured with LDAP-based authentication. QMFDQ-3788 Unable to update Oracle-based repositories. QMFDQ-3824 SQL statements that use the ‘Select Into’ clause against Informix databases fail to execute due to the erroneous addition of optimization clauses. QMFDQ-3834 Error can occur when saving an object (query, report, form) to a workspace if the object has the same name as an existing object in the workspace.