IBM(R) DataQuant for Multiplatforms, Version 1 Release 1, Fix Pack 2 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 DATAQUANT FOR WORKSTATION 1.1 FIX PACK 2 3.0 DATAQUANT FOR WEBSPHERE 1.1 FIX PACK 2 1.0 ABOUT THIS README FILE Welcome to IBM DataQuant for Multiplatforms, Version 1 Release 1, Fix Pack 2 README file. This README file contains descriptions of fixes for IBM DataQuant for Workstation and DataQuant for WebSphere. 2.0 DATAQUANT for WORKSTATION FIX PACK 2 QMFDQ-104 Multiple improvements and fixes have been implemented for visual reports. QMFDQ-105 Multiple improvements and fixes have been implemented for visual dashboards. QMFDQ-68 OLAP queries are not included in the results after searching a repository. QMFDQ-174 Reference information is incorrectly displayed for some queries. QMFDQ-276 An error can occur when connecting to a database-based repository that has LDAP security using a network connection. QMFDQ-285 Unable to run OLAP queries when connected to an unsecured database-based repository using a web service connection. QMFDQ-299 Unable to set user permissions for an object when connected to a database-based repository that has LDAP security using a network connection. QMFDQ-330 New resource limits group schedules are always created using the values from the default group schedule rather than the values from the selected group schedule. QMFDQ-340 SQL syntax errors are not reported when a query that is running against a database-based repository using a web service or network repository connection fails. QMFDQ-389 After changing a data source's JDBC URL, the new JDBC URL is not updated in the Repository Explorer, Workspace Explorer or Repositories views for any objects that are linked to the data source. QMFDQ-391 Unable to specify ascending or descending sort condition for a column when creating a query using the Diagram Query editor. QMFDQ-401 Errors can occur when renaming objects and folders in the Repository Explorer view. QMFDQ-404 JDBC driver list is not updated in new data source dialog after the driver`s name is changed. QMFDQ-407 Error can occur when a user without administrative privileges accesses a repository that is assigned Internal security and requests a list of objects for a classic form from the Data Source Object dialog. QMFDQ-416 Added the ability to see progress statistics for queries submitted using the command bar. QMFDQ-422 Text of a procedure is corrupted after opening and then canceling the Set Font dialog. QMFDQ-438 Exceptions can occur when expanding reference folders for OLAP queries. QMFDQ-439 Incorrect display of invisible columns in the Diagram Query editor. QMFDQ-443 NULL values in calculated columns are exported to HTML incorrectly. QMFDQ-461 Support added for custom edit codes in classic reports. QMFDQ-463 Blurred images in some non-English user interface dialogs. QMFDQ-481 When filtering the objects listed in the Repository Explorer, every schema instead of just those requested for a specific owner are returned. QMFDQ-493 Parser exceptions can occur for some queries that include the WITH or INSERT INTO keywords; or parameters. QMFDQ-509 Unable to save a table that replaces existing data. QMFDQ-512 Inserting a row into a table that includes a TimeStamp column results in an invalid value for the column. QMFDQ-528 In some cases, Preview page does not display all columns of OLAP query results. QMFDQ-543 For queries that are created using the SQL editor and include the BETWEEN predicate, switching to the Prompted or Diagram editor view may corrupt the SQL text. QMFDQ-544 For queries that are created using the SQL editor and include a simple LIKE statement, switching to the Prompted or Diagram editor view may corrupt the SQL text. QMFDQ-577 Added the ability to open tables with a Table Viewer which opens the table and displays the contents of the table in the query results view; a Query Editor which opens the table in the Diagram Query editor view; or a Table Editor which opens the table in edit mode. QMFDQ-582 Exception can occur when accessing the content assist function using the CTRL + SPACE keys. QMFDQ-591 An error can occur when saving objects with duplicate names and types in the QMF catalog. QMFDQ-595 For some queries, the 'Row conditions' field is not visible or not available in the Diagram Query editor view. QMFDQ-600 The New OLAP Query wizard incorrectly switches to the next processing page even though an incorrect user name and password has been entered and saved for the current data source. QMFDQ-601 Crash or incorrect display of data can occur when moving a column in the query results. QMFDQ-604 Unable to change passwords for repositories that have been created with Internal security. QMFDQ-605 DATE columns display incorrectly in Table Editor. QMFDQ-606 Default object names are not translated for many languages. QMFDQ-607 Repository object types are not translated in some dialogs. QMFDQ-609 For queries that are created using the SQL editor, switching to the Prompted Query editor view to change a row condition will corrupt the SQL statement in SQL editor view. QMFDQ-613 The 'Insert row' dialog accessed using the Table Viewer is not keyboard accessible. QMFDQ-631 Errors can occur when adding multiple tables from the Table List dialog using the Prompted Query editor. QMFDQ-642 After changing an object's name, the links to the object are not updated in the Workspace Explorer. QMFDQ-648 Errors can occur when adding tables using the Diagram Query editor and you are connected to a database-based repository using a web service repository. QMFDQ-650 Confirmation message is not issued when deleting default resource limits values. QMFDQ-656 A search for all tables in a data source returns empty when using the 'Search in Repository' function. QMFDQ-657 Exception can occur when exporting an IXF file to a table in a database. QMFDQ-672 The 'OK', 'Abort' and 'Cancel' buttons that are included in the message dialog issued when a query returns more rows than the cancel resource limit are disabled. QMFDQ-675 Unable to view resource limits when connected to a database-based repository using a web service connection. QMFDQ-677 Unable to create OLAP queries when connected to a database-based repository using a web service connection. QMFDQ-881 Errors can occur when creating groups for a database-based repository that has been assigned Internal security. QMFDQ-682 Adding users for a secured repository requires a carriage return in certain fields after pasting (verses typing) the values into those fields. QMFDQ-684 A 'Delete' item had been added to context menu in the Events view. QMFDQ-692 NullPointerException error can occur when opening a query from a file and there is no connection to a repository. QMFDQ-696 For tables opened using the Table Editor, users can now delete multiple rows with a single action. QMFDQ-706 Exception can occur when expanding the 'References" node for queries that include a complex expression and a GROUP BY clause. QMFDQ-708 By pressing the SHIFT key, multiple copies of a single object selected from the Palette view can be inserted in a visual report or dashboard. QMFDQ-710 Exception can occur when opening an ACCESS table from the 'Recently Used' folder in the Repository Explorer. QMFDQ-721 Incorrect repository name is displayed in the Repository Connections view for any web service repository connection information. QMFDQ-730 Visual projects now open by default in runtime mode and only enter design mode if the user elects to edit them. QMFDQ-732 A new 'Connectivity' tool has been added that enables dashboard designers to easily define the relationship between control objects and data-driven objects. QMFDQ-742 Exception can occur when copying a table from the Search in Repository view to the Repository view. QMFDQ-743 Modifications made to in the Repository Connections view are not saved immediately. QMFDQ-749 Errors can occur when exporting query results to an XML or WQML file. QMFDQ-755 Workspaces view is missing vertical scrollbar. QMFDQ-774 Incorrect formatting can occur in a query results column when a specific number of decimal places for scientific format is specified for the column value. QMFDQ-776 Error can occur saving data from one table to another using the 'Save Data As' command. QMFDQ-777 Results tab is not automatically activated after editing a query in Prompted view and then re-running the query. QMFDQ-795 Unable to scroll to additional data that is not currently displayed in the query results window by dragging the mouse pointer. QMFDQ-796 The options 'Sort Ascending', 'Sort Descending' and 'Remove from Layout' are missing from the 'Layout' menu that is used when formatting query results. QMFDQ-797 Query results formatting options are now available in the Outline view. QMFDQ-799 OLAP cubes and queries are not added to the 'Recently Used Objects' folder in the Repository Explorer. QMFDQ-813 Unable to delete a file-based repository that has been saved to disk. QMFDQ-820 Data is not exported in the correct sort order when one of the primary sort columns is moved to a side group and a calculated column is added after the data is originally sorted. QMFDQ-845 Exception can occur when opening a link to a cube model. QMFDQ-860 Permissions on workspaces are ignored. QMFDQ-878 Exception can occur when working with query containing an 'ORDER BY' clause in Prompted or Diagram editors if query's data source is MSSQL Server. QMFDQ-880 Error can occur when opening a table from a MS ACCESS data source that has a QMF Catalog. QMFDQ-899 Re-running a query that has not completed fetching rows from the original run will cause the 'Results' page to be empty. QMFDQ-901 When copying rows from the OLAP query results page, more data is copied than what was selected. QMFDQ-912 Errors can occur when opening some Object Tracking reports. QMFDQ-915 Added the ability to drag a column from the Project Explorer view directly into a visual report detail section in the Visual Designer view, automatically creating a new label and defining its associated column. QMFDQ-916 Added the ability to drag a table from the Workspace view directly onto the dashboard scene and with this action the query and the data source connection is automatically set up significantly expediting the query portion of the dashboard authoring process. QMFDQ-926 Incorrect quoting of already quoted values in Prompted and Diagram Query views. QMFDQ-945 After changing the QMF catalog for a data source, the Repository Explorer view is not updated and incorrectly displays the content of the previous data source's QMF Catalog. QMFDQ-985 An exception can occur when showing references for a query that includes CASE keyword and multiple row conditions. 3.0 DATAQUANT FOR WEBSPHERE 1.1 Fix Pack 2 QMFDQ-28 Incomplete results due to case sensitivity when searching a repository. QMFDQ-68 OLAP queries are not included in the results after searching a repository. QMFDQ-86 The RAND() function does not return random numbers when used to generate the value of a calculated column. QMFDQ-291 Added the ability to sort query results in ascending or descending order by clicking on a given column's header. QMFDQ-360 Unable to edit data source connection information using DataQuant for WebSphere Administrator. QMFDQ-406 Unable to complete processing when running a query that returns a large result set from the command line. QMFDQ-427 Error occurs when specifying the XML file extension for a LOB column in a table. QMFDQ-465 Several keywords in the pages used to design forms are not translated in some languages. QMFDQ-488 For some languages, the build date in the Status page is displayed in English. QMFDQ-509 Unable to save a table that replaces existing data. QMFDQ-581 In some cases the display of query results that includes groups is corrupted after scrolling. QMFDQ-591 It is possible to save objects with duplicate names and types in the QMF catalog. QMFDQ-604 Unable to change passwords for repositories that have been created with Internal security. QMFDQ-641 Images are missing from some dialogs. QMFDQ-650 Confirmation message is not issued when deleting default resource limits values. QMFDQ-707 When connected to DataQuant for WebSphere using Mozilla under Linux, the 'About' and 'Logon' buttons in the upper-right corner of the screen are only partially painted. QMFDQ-745 The 'OK', 'Abort' and 'Cancel' buttons in the message dialog displayed when "maximum rows to fetch" resource limit is reached are disabled. QMFDQ-753 Unable to open some non-English help systems from login page. QMFDQ-758 Incorrect data is displayed on the last results page when the page is accessed using the 'Last vertical page' button. QMFDQ-776 Error can occur saving data from one table to another using the 'Save Data As' command. QMFDQ-777 Results tab is de-activated after editing a prompted query then re-running the query. QMFDQ-831 NullPointerException error can occur when creating a repository with Internal security and the login and password fields are empty. QMFDQ-884 Changes to the default log levels set using DataQuant for WebSphere Administrator are lost after application restart. QMFDQ-968 NullPointerException error can occur when opening a table with LOB column.