IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 9 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 9 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 9 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 9 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 9 ************************************************************* QMFDQ-450 Error can occur when parsing query with a parameter. QMFDQ-579 Added support for viewing database connections. QMFDQ-616 Error can occur when parsing a query that contains a MERGE command. QMFDQ-1085 Error can occur when parsing a query statement that includes a "+". QMFDQ-1086 Error can occur when parsing a query statement that includes the word TEMPORARY. QMFDQ-2815 Extra line-break symbols are added to the SQL text of query object during the save process. QMFDQ-3026 Exception can occur when calling editing the SQL of a query and invoking the content assist feature. QMFDQ-3047 Empty values are incorrectly displayed as null values in a visual report. QMFDQ-3177 Unable to uninstall German, Swiss German, or Portuguese versions of the application when they are installed on a Linux system. QMFDQ-3609 Error occurs when editing a SQL statement using the content assist feature and selecting FETCH from the list of content assist options. QMFDQ-3672 Re-sizing the query editor window can corrupt the display of query results in the grid. QMFDQ-3989 The Default Tablespace resource limit settings is ignored when data is saved using the SAVE DATA procedure command. QMFDQ-4562 Added support for two new query result conditional formatting function "ISNULL" and "ISNOTNULL" that can be used in conditions and expressions. QMFDQ-4579 Columns can be rendered with an incorrect width when a visual report is created using the Convert Form to Visual Report command. QMFDQ-4579 Page numbers are rendered incorrectly when a visual report is created using the Convert Form to Visual Report command. QMFDQ-4629 Added support for the sorting of properties in the Properties view. QMFDQ-4630 Time data may be incorrectly displayed in a visual report that has been generated based on the current query. QMFDQ-4866 Visual report incorrectly displays a column of data with a data type of TIMESTAMP as data with a data type of DATE. QMFDQ-5164 In some cases, the BOTTOM procedure command does not scroll to the bottom of the query results. QMFDQ-5175 Visual reports that are created based on query results incorrectly display calculated columns that include null values. QMFDQ-5198 The General page of the Layout Properties dialog becomes unavailable after formatting query results columns. QMFDQ-5220 Exception can occur when exporting query results to an IXF file. QMFDQ-5470 Some tables that include an empty line between the table and the final text may display incorrectly in visual reports. QMFDQ-5510 The CSUM function returns a null value when performing the aggregation over a column which contains one or more null data values. QMFDQ-5680 Exception can occur when exporting query results to a file. QMFDQ-5702 An error can occur when opening a z/OS DB2 table that has one or more columns with mixed SBCS and DBCS characters. QMFDQ-5714 Users are prematurely prompted to logon to a data source when importing a result set into a data source. QMFDQ-5725 Calculated column data values are displayed incorrectly after the data type of the calculated column changes. QMFDQ-5726 Incorrect resource limits schedule in effect due to incorrect schedule search parameters. QMFDQ-5727 The OpenFromFile command opens a visual dashboard that has been saved to a file in the incorrect mode. QMFDQ-5742 In some cases, an error can occur when creating or updating catalog objects on DB2 for z/OS using the IBM Type 2 JDBC driver. QMFDQ-5760 The value for 'Owner ID' entered in the package binding dialogs is not processed correctly. QMFDQ-5761 The Finish button on the Create New Query dialog is incorrectly enabled allowing users to create a query even though no data sources have been defined. QMFDQ-5765 If the user enters an expression in the Expression Designer which results in a syntax error, the error message is not cleared when the erring expression is undone using the application’s undo facility. QMFDQ-5799 Several buttons on the Protect QMF Catalog tables are incorrectly enabled when the Protect option is selected. QMFDQ-5830 An exported report that uses the ACROSS usage code displays a blank line for column headings if there are no column headings to display. QMFDQ-5857 An 'Idle Connection Timeout' resource limit value of zero is processed incorrectly. QMFDQ-5861 Repository connection information has now been added to objects saved to the file system. Users can now run objects that have been saved to a file (by double-clicking), and the application will use the repository connection appropriate for the object, rather than the last-used repository connection. QMFDQ-5894 Error occurs when using the substr(str()) function in the expression that defines the contents of a calculated column. QMFDQ-5912 The title bar for an open query does not update after changing the query's data source. QMFDQ-5913 Added the ability to view data source details on each open query tab, as well as in the tooltip text for that tab. QMFDQ-5914 The Getting Started publication has been updated to correct the erroneous statement that changes to the workbench layout must be saved. QMFDQ-5915 Support has been added for a new Personal view which includes the folders Favorites, Recently Used, and StartUp. QMFDQ-5916 QMF catalog object list is missing the First Used, Last Used, and Last Modified date fields. QMFDQ-5917 Selecting the 'Enable single sign-on support' application preference without actually having a single sign-on configuration locks the user out of the application. QMFDQ-5918 The Data Source Connections view now lists data sources by name (rather than JDBC URL) and allows users to terminate connections directly from the view. In addition, the data source connection information is automatically refreshed. QMFDQ-5919 Unable to export JDBC driver definitions that were pre-defined in the software using the Export Connection and JDBC Library Settings option. QMFDQ-5921 When a query repeatedly calls the same procedure, only the first set of parameter values are used even though each call specifies a unique set of parameter values. QMFDQ-5938 The 'Find and Install' menu option has been removed. QMFDQ-5939 If the user ID and password are not saved as the logon information for a data source, QMF now defaults to the last user ID that was entered when next prompting for a logon to the data source. QMFDQ-5951 Error occurs opening an exported IXF file. QMFDQ-5957 Error can occur determining whether the maximum number of connections to a data source have been exceeded. QMFDQ-5969 Users without permissions can access a QMF catalog that is located on a data source other than the one that hosts the repository storage. QMFDQ-5986 Trailing zeros in TIMESTAMP data are truncated when selected from a table that is created using the CREATE SQL statement and updated using the INSERT statement. QMFDQ-5987 The content of a single query results cell that includes a carriage control is incorrectly placed into multiple cells when exported to Excel or to a CSV file. QMFDQ-6010 Add support that allows users who are controlled by repository based resource limits to specify a table space when saving data. QMFDQ-6016 The Personal View tree is not refreshed after items are deleted. QMFDQ-6027 Unable to substitute the correct value of a global variable when it is used in a query results calculated column expression. QMFDQ-6035 Incorrect parsing of values containing single quotes in the SET GLOBAL procedure command. QMFDQ-6036 Unable to find a form that resides in the same folder as the procedure, when the FORM parameter of the RUN procedure command does not specify the entire path to the form. QMFDQ-6037 When a form is specified as a RUN procedure command parameter, the variable values that are required should be taken from the command line. QMFDQ-6038 In the command bar, the Data Source drop down list is not populated with all available data sources upon startup of the application. QMFDQ-6039 Added support for Network and Web service repository connections. QMFDQ-6054 Added support for specifying the data type for a query results calculated column. QMFDQ-6056 Error can occur while application is fetching results for an OLAP query. QMFDQ-6060 Introduced a new Explorer view that lists the contents of a folder selected from the Workspace view. Objects are listed by name, type, create date, last updated date, and last used date. QMFDQ-6087 Sort conditions are not saved with the query in the Prompted query editor. QMFDQ-6092 Exception can occur if Visual Designer attempts to use a font whose name starts with "+". QMFDQ-6100 Users that have been granted permission cannot gain access to a QMF catalog that is located on non-DB2 data source. QMFDQ-6104 Users are able to use the Table Editor even if the 'Enable Table Editing' resource limit is set to 'NO'. QMFDQ-6116 When running a procedure that includes an EXPORT query results data command, the status bar shows an incorrect number of retrieved rows. QMFDQ-6123 When an INSERT or UPDATE statement is run, there is no notification of how many rows were affected. QMFDQ-6144 Error can occur when visual report Label objects are grouped. QMFDQ-6153 Comments that have been specified for a column are not displayed in the Columns dialog. QMFDQ-6161 The 'Share the object with other users' setting for objects saved in the QMF catalog is ignored. QMFDQ-6167 Support added that enables users to specify a CLOB value directly in the query text of a stored procedure. QMFDQ-6168 The default Cancel resource limit for a query is set incorrectly. QMFDQ-6184 DB2 V9 Fix Pack 6 Type 2 JDBC driver returns incorrect size values for Graphic columns. QMFDQ-6192 Selecting the 'Allow running saved queries only' resource limit does not prevent users from creating and running new queries; editing and running saved queries; or saving edited and new queries. QMFDQ-6220 Incorrect default value for the 'Allow running saved queries only' resource limit. QMFDQ-6235 Error can occur when an object tracking report for repository based objects is opened and the repository where the objects reside is not defined as a data source. QMFDQ-6311 Users can export data regardless of the 'Enable exporting of data' resource limit setting. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF for WebSphere 9.1 Fix Pack 9 ************************************************************* QMFDQ-579 Added support for viewing database connections. QMFDQ-3769 Visual reports may be rendered with an incorrect column width when opened using QMF for WebSphere. QMFDQ-4866 Visual report incorrectly displays a column of data with a data type of TIMESTAMP as data with a data type of DATE. QMFDQ-5470 Some tables that include an empty line between the table and the final text may display incorrectly in visual reports. QMFDQ-5510 The CSUM function returns a null value when performing the aggregation over a column which contains one or more null data values. QMFDQ-5702 An error can occur when opening a z/OS DB2 table that has one or more columns with mixed SBCS and DBCS characters. QMFDQ-5746 QMF for WebSphere Administrative interface incorrectly allows the QMF catalog plug-in to be enabled for data sources other DB2. QMFDQ-5838 The CCSID 930a is not displayed in the list of available CCSIDs when updating QMF catalog information. QMFDQ-5882 Display errors occur as a result of improper processing of quoted strings as parameters to stored procedures. QMFDQ-5916 QMF catalog object list is missing the First Used, Last Used, and Last Modified date fields. QMFDQ-5921 When a query repeatedly calls the same procedure, only the first set of parameter values are used even though each call specifies a unique set of parameter values. QMFDQ-5926 When multiple users are using the same repository and are connected to the same data source, the user who most recently sets a Name Filter for a particular data source changes the Name Filter used by all users. QMFDQ-5929 Errors occur as a result of running the IMPORT procedure command. QMFDQ-5986 Trailing zeros in TIMESTAMP data are truncated when selected from a table that is created using the CREATE SQL statement and updated using the INSERT statement. QMFDQ-5988 When exporting a query result set that exceeds 950,000 rows to a file, the File Download page does not appear automatically. QMFDQ-6054 Added support for specifying the data type for a query results calculated column. QMFDQ-6087 Sort conditions are not saved with the query in the Prompted query editor. QMFDQ-6104 Users are able to use the Table Editor even if the 'Enable Table Editing' resource limit is set to 'NO'. QMFDQ-6123 When an INSERT or UPDATE statement is run, there is no notification of how many rows were affected. QMFDQ-6153 Comments that have been specified for a column are not displayed in the Columns dialog. QMFDQ-6167 Support added that enables users to specify a CLOB value directly in the query text of a stored procedure. QMFDQ-6168 The default Cancel resource limit for a query is set incorrectly. QMFDQ-6191 When DBCS characters are entered in a SQL statement, all other text is deleted. QMFDQ-6192 Selecting the 'Allow running saved queries only' resource limit does not prevent users from creating and running new queries; editing and running saved queries; or saving edited or new queries. QMFDQ-6193 A query can be opened from the QMF catalog by specifying its full name even if it is not displayed in the Object List pane. QMFDQ-6216 Cancel button on left side bar does not cancel the query that is currently running. QMFDQ-6220 Incorrect default value for the 'Allow running saved queries only' resource limit. QMFDQ-6311 Users can export data regardless of the 'Enable exporting of data' resource limit setting.