IBM(R) DataQuant for Multiplatforms, Version 1 Release 2, Fix Pack 5 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 DATAQUANT FOR WORKSTATION 1.2 FIX PACK 5 3.0 DataQuant for WebSphere 1.2 Fix Pack 5 ******************************************** 1.0 ABOUT THIS README FILE ******************************************** Welcome to IBM DataQuant for Multiplatforms, Version 1 Release 2, Fix Pack 5 README file. This README file contains descriptions of fixes for IBM DataQuant for Workstation and DataQuant for WebSphere. ********************************************* 2.0 DATAQUANT for WORKSTATION 1.2 FIX PACK 5 ********************************************* 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-767 Support added that enables users to view visual dashboard object references. QMFDQ-812 Unscheduled mouse over and mouse out events occur when user scans dashboard grid object. 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-3324 Support added for label text rotation up to 360 degrees enabling migration from Excel charts that include this feature to DataQuant dashboard charts. 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-3942 Error occurs when using the calculator to evaluate an expression that includes the MOD function. QMFDQ-3989 The Default Tablespace resource limit settings is ignored when data is saved using the SAVE DATA procedure command. QMFDQ-4337 The strToNum() function causes inconsistent results when used to provide a value that triggers a Timer object event. QMFDQ-4562 Added support for two new query result conditional formatting functions "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-4816 Errors can occur when switching between zoom modes in a visual dashboard scene before all queries have completed and the scene is validated. 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-5118 Unable to edit the settings for LDAP secured repositories. 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 generated from 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-5289 Undo and Redo buttons behave incorrectly after copying and pasting pictures to and from visual dashboards. QMFDQ-5295 Exception can occur when moving visual dashboard table and cell information between two tables using the Project Explorer view. 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-5592 Positioning of objects can vary slightly depending on whether a dashboard is rendered in RichClient or HTML mode. QMFDQ-5645 Drag and drop actions in the Project Explorer view cannot be reversed using the application's undo feature. QMFDQ-5674 Exception can occur when a local parameter is removed from the scene. 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-5704 The StartPoint and EndPoint properties of a visual project's line object are incorrect when the line is included in a group. QMFDQ-5714 Users are prematurely prompted to logon to a data source when importing a result set into a data source. QMFDQ-5724 Some data is not displayed correctly in BIRT reports that are generated based on a set of query results using default formatting. 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-5728 Changing ViewerZoom and ViewerY properties is ineffective when visual dashboards are rendered in HTML mode. QMFDQ-5740 Visual project connector objects that are part of a group are not rendered in PDF 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-5744 Visual project elements (such as queries, connections, color sequences) can now be added by double-clicking on their respective folder items in the Project Explorer. QMFDQ-5752 Text in Table objects can be displayed incorrectly when visual dashboards are rendered in PDF mode at runtime. 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-5767 Unable to set zoom percentage when visual dashboard is rendered in Print Preview runtime mode. QMFDQ-5768 Primitive objects' properties can be corrupted after placing the object on the Custom palette. QMFDQ-5770 The Connection Parameters page of the Properties dialog for a new multidimensional (XMLA) data source is empty. QMFDQ-5773 In some cases, the Test Connection button does not result in a connection to a multidimensional (XMLA) data source. QMFDQ-5783 When a dashboard navigates to an independent visual project via a scene event action, the visual project is not listed in the dashboard's references in the Repository Explorer. QMFDQ-5809 Extra blank spaces are added to blocks of tabular data in exported reports that have page heading and page footing text that exceeds the report column width. 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-5840 Unable able to reset the Width property of an object in a visual dashboard using the Undo commands. QMFDQ-5848 Exception occurs when a visual dashboard slicer object filters data from a DB2 Data Warehouse Edition multidimensional data source. QMFDQ-5849 Error can occur when moving a connector object to an alignment panel using the Project Explorer. 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-5890 A query for a visual dashboard is not created after selecting a table in the Add Data Template wizard. QMFDQ-5894 Error occurs when using the substr(str()) function in the expression that defines the contents of a calculated column. QMFDQ-5898 Middle and right mouse buttons are not recognized by OnMouseDown and OnMouseUp events. QMFDQ-5900 Errors can occur parsing calculator expressions that start with zero. 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-5931 Inconsistent widths for identically sized rectangle borders in a visual dashboard. 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, DataQuant 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-5952 Selecting the Refresh Cache button in the Manage Expiration Schedules dialog runs all queries for the visual dashboard rather than just the selected query. QMFDQ-5957 Error can occur determining whether the maximum number of connections to a data source have been exceeded. QMFDQ-5966 Error can occur when creating a BarChart object in a visual dashboard using data from a multidimensional query. 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-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-6041 Zooming action on a visual dashboard PieChart object can make the object disappear. QMFDQ-6042 Exception can occur while using the Drilldown wizard to edit a data level in a visual dashboard. 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-6109 Data is aligned differently between the HTML and Rich Client rendering mode in visual dashboards. QMFDQ-6110 Exception can occur when expanding the list of LDAP repository users from the Repositories view. 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-6120 A LinearMap object is rendered incorrectly if the AutoScaleUpper limit property is set to a negative number. QMFDQ-6123 When an INSERT or UPDATE statement is run, there is no notification of how many rows were affected. QMFDQ-6129 The correct directory is not used as the default when saving visual reports and dashboards to a file. QMFDQ-6144 Error can occur when visual report Label objects are grouped. QMFDQ-6146 Administrators can now control access to LDAP-secured repositories based on membership in specific LDAP groups. QMFDQ-6151 Expand and Collapse buttons are incorrectly disabled when zooming into PieChart objects that include multiple data levels. 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-6163 Copying and pasting a data level in the data template node of a visual dashboard using the Project Explorer produces duplicate data levels. 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-6208 Exception can occur when switching from viewing a visual dashboard in PDF format to viewing it in Swing mode. 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-6258 Application becomes unresponsive when a visual dashboard viewer selects values from two combo objects that control the contents of an embedded scene object. QMFDQ-6311 Users can export data regardless of the 'Enable exporting of data' resource limit setting. ********************************************** 3.0 DataQuant for WebSphere 1.2 Fix Pack 4 ********************************************** DataQuant for WebSphere 1.2 Fix Pack 5 QMFDQ-579 Added support for viewing database connections. QMFDQ-812 Unscheduled mouse over and mouse out events occur when user scans dashboard grid object. QMFDQ-3769 Visual reports may be rendered with an incorrect column width when opened using DataQuant for WebSphere. QMFDQ-3864 For multidimensional data, expanding a top or side groups can cause formatting errors in the query results page. 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-5118 Unable to edit settings for LDAP secured repositories. QMFDQ-5470 Empty lines between data and the final text are skipped 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 DataQuant for WebSphere Administrative interface incorrectly allows the QMF catalog plug-in to be enabled for data sources other than DB2. QMFDQ-5781 Unable to remove a repository storage entry from the Repositories view using the DataQuant for WebSphere Administrator interface. QMFDQ-5838 The CCSID 930a is not displayed in the list of available CCSIDs when updating QMF catalog information. QMFDQ-5882 Quoted strings are processed incorrectly if passed as a stored procedure parameter. QMFDQ-5898 Middle and right mouse buttons are not recognized by OnMouseDown and OnMouseUp events. QMFDQ-5916 First Used, Last Used, and Last Modified date columns were added to the QMF catalog object list. 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-6109 Data is aligned differently between the HTML and Rich Client rendering mode in visual dashboards. QMFDQ-6123 When an INSERT or UPDATE statement is run, there is no notification of how many rows were affected. QMFDQ-6146 Administrators can now control access to LDAP-secured repositories based on membership in specific LDAP groups. 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-6246 Empty cells in HTML tables are displayed without borders. QMFDQ-6258 Application becomes unresponsive when a visual dashboard viewer selects values from two combo objects that control the contents of an embedded scene object. QMFDQ-6311 Users can export data regardless of the 'Enable exporting of data' resource limit setting.