IBM(R) DataQuant for Multiplatforms, Version 1 Release 2, Fix Pack 6 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 DATAQUANT FOR WORKSTATION 1.2 FIX PACK 6 3.0 DataQuant for WebSphere 1.2 Fix Pack 6 ******************************************** 1.0 ABOUT THIS README FILE ******************************************** Welcome to IBM DataQuant for Multiplatforms, Version 1 Release 2, Fix Pack 6 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 6 ********************************************* QMFDQ-229 Incorrect symbols may be displayed in the search results pane of the help window. QMFDQ-2805 The list of object tracking reports displayed in the Object Tracking Reports dialog may not match the reports that are actually available to the user. QMFDQ-2919 Provide the ability to select from all available data sources when inserting a query into a visual project, rather than be limited to the data sources that are represented by connections in the project. QMFDQ-3278 Include a metadata layer which provides a means of defining virtual data sources that hide the complexities of underlying data schemas from content developers and end users. Virtual data sources also provide a means of executing federated queries, joining across tables located in differing databases. QMFDQ-3498 Add the ability to schedule procedures for one-time or periodic execution. Jobs can be submitted for execution on the workstation or for execution on the web server. QMFDQ-3501 Enhance the workspace view with toolbar buttons for stepping into workspace items, navigating back and forth and maximizing and restoring a given workspace view. QMFDQ-3715 While displaying a visual dashboard in the runtime mode, the up arrow and down arrow keys scroll the canvas up and down, instead of zooming in and out. QMFDQ-3962 In the help system and the publications, the URL for the websphere application is incorrect. QMFDQ-4005 In the help system and the publications, typos and errors were found and corrected. QMFDQ-4029 Provide a way for an end user to change their repository password. QMFDQ-4058 In visual dashboards, the background color property value stays set as default when you change a scene's background color to white in the Color dialog. QMFDQ-4083 Include the underlying data source name in the tooltip text presented when hovering over the tab of open queries and tables. QMFDQ-4107 Provide the ability to import and run QMF for Windows job definition files. QMFDQ-4129 Provide ability to reference objects in procedures using a path relative to the location of the procedure. QMFDQ-4144 Introduce extended pie, column and bar charts that allow data points to be rolled up across one or more query columns. This facility provides features comparable to that of displaying multi-dimensional data. QMFDQ-4230 Add a rotation property to provide a means of rotating text labels through 360 degrees. QMFDQ-4264 Page breaks may not be created when converting a classic report to visual report. QMFDQ-4275 Add a drop-down list of common values for the Catalog CCSID when creating a QMF catalog. QMFDQ-4276 Add a new value to the DSQQW_PROC_WNDWS global variable to automatically close a procedure window upon completion when executed non-interactively. QMFDQ-4359 ptToStr function may append extra characters to the generated string. QMFDQ-4416 Enhance the Save to Repository dialog such that defaults to the path last used to save an object. QMFDQ-4471 Incorporate the ability to define visual project templates, allowing content developers to derive new projects from existing templates that contain stock content. QMFDQ-4486 Provide the ability to insert data files as static result sets within visual projects. QMFDQ-4583 The page number may be displayed over the date when converting a classic report to a visual report. QMFDQ-4649 Provide ability to close the new visual project wizards by pressing the Esc key. QMFDQ-4800 Automatically invoke the layout wizard when a query is dragged and dropped onto a dashboard or visual report canvas. QMFDQ-4821 Add support for one-time database passwords such that a given logon is not used by more than one database connection. When a data source is configured to use one-time passwords, the user is prompted for a logon each time a database connection is made. QMFDQ-4893 There is no way to manually export the results of a query without including calculated columns and grid formatting. QMFDQ-4958 Incorporate translation tables within visual projects, allowing content developers to add translated versions of text used in the dashboard. The appropriate string table is then automatically invoked by the visual project, based on the locale of the end user. QMFDQ-5134 In a visual dashboard rendered in HTML, labels may be filled with incorrect background colors. QMFDQ-5158 In visual reports, the AutoHeight property does not work when applied to header or footer sections containing expandable content. QMFDQ-5160 When viewing a report with more than one horizontal page that was saved in a QMF catalog, the move to the next page horizontally button does not work. QMFDQ-5244 Add support for displaying SQL error messages in the output window when running BIRT reports. QMFDQ-5298 Provide a means of sorting properties alphabetically. QMFDQ-5332 Support the localization of system-generated column names (used when a query does not return a column name). QMFDQ-5353 Include the associated action in the output window when a dashboard component generates an error. QMFDQ-5356 In the help system and the publications, the description of the Export Query Results dialog has changed. QMFDQ-5387 Any user can delete repository storage and repositories without authentication. QMFDQ-5403 Add a color picker toolbar button to the expression designer to allow the convenient entry of colors into expressions. QMFDQ-5424 If a visual project references other visual projects, include this information in the references collection in the repository and workspace explorer. QMFDQ-5461 Provide the ability to create local or global variables from directly within the expression designer. QMFDQ-5695 An error may occur when saving an object to the QMF catalog using non-English character sets. QMFDQ-5745 Provide a means of adding new dashboard and visual report items by double-clicking on their respective parent nodes in the project explorer. For example, new queries can be added by double-clicking the Queries node. QMFDQ-5763 An error may occur when simultaneously working with two OLAP queries that have identical dimension names but different cube structures. QMFDQ-5833 In visual dashboards rendered in HTML, an error may occur when viewing a grid object populated by a query containing client side OLAP content. QMFDQ-5925 An error may occur when converting a classic form to HTML when the Include tabular data as an HTML table option is selected. QMFDQ-5983 Add a Personal View which allows users to view Favorites, Recently Used and Startup objects. QMFDQ-5984 A warning dialog appears multiple times when the idle query timeout limit is reached. QMFDQ-6043 Add a manage licenses dialog that provides a convenient means of adding and refreshing product license files. QMFDQ-6069 An error may occur when a visual dashboard object's property value refers to itself. QMFDQ-6082 In the Show References dialog of a visual dashboard object, the Next and Previous buttons do not show consecutive references. QMFDQ-6124 Enhance the table editor to allow users to specify row conditions, thereby subjectively selecting the data rows presented for editing. QMFDQ-6136 An error may occur if the Progress dialog is closed while binding packages in the Protection tab of the QMF Catalog Plug-in Parameters dialog. QMFDQ-6147 Provide the ability to limit access to a given repository to a designated LDAP group. If specified, this group acts as the Everyone collection. LDAP users not in the group are denied logon access to the repository. QMFDQ-6148 If two different driver libraries on two different data sources have the same driver class name, only one will be used. QMFDQ-6174 Provide the ability to specify CLOB values directly in the query text when running stored procedures with CLOBs. QMFDQ-6226 Multidimensional data sources can not be copied from one repository to another using the copy/paste function. QMFDQ-6232 When the LOB data retrieval resource limit is disabled, multiple information messages open when the Retrieve ALL LOB Values option is selected in query results. QMFDQ-6251 If two data sources with the same URL use a QMF catalog resource limits provider, when a resource limit option is changed in the default group of one data source, it affects the other as well. QMFDQ-6266 The Edit action in the context menu of a visual dashboard in the Repository Explorer view fails if the Run action has already been selected twice. QMFDQ-6269 After receiving an error for creating a query using an invalid XMLA data source, changing the query's data source in the dialog does not work. QMFDQ-6271 In visual dashboards rendered in HTML, an error may occur when zooming out past a factor of %0.0015. QMFDQ-6275 If you change the current repository connection's name while an unsaved visual dashboard is open, the Select Items for Saving dialog opens twice. QMFDQ-6276 Top groups in query results may not collapse after being expanded. QMFDQ-6284 In visual dashboard scene properties, English measurement units such as inches appear by default while using language locales that use metric measurement units. QMFDQ-6288 An error may occur when trying to edit a data source's login information without selecting any users or groups first. QMFDQ-6289 Incorrect connection names can be set for visual dashboards in the Project Explorer view. QMFDQ-6294 Using the Set User Information dialog to login as an administrator does not change the current user's information. QMFDQ-6297 An error may occur when trying to create a new sample repository after deleting the previous sample repository. QMFDQ-6298 User name and password fields may not display in the dialog when trying to connect to a repository with a long URL. QMFDQ-6301 While displaying a visual dashboard in the runtime mode, if you use the context menu to jump to another scene, the Navigate forward and Navigate back buttons do not work. QMFDQ-6304 An error may occur when trying to edit the query property of a visual dashboard's simple form object. QMFDQ-6306 An error may occur when trying to delete a polyline object in visual report while the object is being drawn. QMFDQ-6318 An error may occur when trying to change an object tracking report's display mode. QMFDQ-6322 If the LOB options can be overridden option is selected, LOB data can be saved even if LOB data saving isn't enabled. QMFDQ-6328 An error may occur when expanding the references of a prompted query saved to the QMF catalog. QMFDQ-6332 A runtime exception occurs when an invalid value is used for the priority level of a resource limit group schedule. QMFDQ-6335 Invalid repository and workspace objects may be added to the Startup folder of the Personal view. QMFDQ-6339 If two resource limits group schedules exist for the same group, one with Allow SELECT checked and the other unchecked, then the Allow SELECT resource limit may be ignored. QMFDQ-6344 Hot keys do not work in the Workspaces view. QMFDQ-6345 An error may occur when expanding the node of a QMF catalog in the Repository Explorer view after deleting its host data source. QMFDQ-6347 An error may occur when trying to delete an object from the Startup folder that has already been deleted from the repository or workspace. QMFDQ-6349 In secured repositories, if resource limits exist for both users and groups, only the user limits will be applied. QMFDQ-6351 An error occurs when you attempt to rename a multidimensional data source. QMFDQ-6353 While displaying a visual dashboard in the runtime mode, an error may occur if the visual dashboard contains an OLAP query and the XMLA connection was deleted from the Project Explorer. QMFDQ-6357 The Remember Password option is reset every time the Set User Information dialog is opened. QMFDQ-6361 When a new query containing variables is added to a visual dashboard and run, if Cancel is clicked in the Enter Variables dialog and the query is closed and reopened, the query text will be erased. QMFDQ-6363 An error may occur if the TitleRow element of a table object is moved to the table object's data template in the Project Explorer. QMFDQ-6365 An error may occur when using the Zoom Edit dialog in query results. QMFDQ-6366 The maximum rows to fetch resource limit is applied even if it is set for a schedule that is outside the current time range. QMFDQ-6367 When a multidimensional data source is added or deleted from the Repository Explorer, the Create New OLAP Query wizard does not reflect the change. QMFDQ-6368 The contents of the Startup and Recently Used folders in the Personal view do not change when you connect to another repository. QMFDQ-6374 In the Explorer view, some object captions in the right pane do not match their corresponding objects in the left pane. QMFDQ-6375 An error may occur when double-clicking a query in the Repository Explorer view if the default action for objects preference is set to run. QMFDQ-6376 The Finish button may be disabled in the Import dialog when importing a table. QMFDQ-6381 Automatically generate a visual report with images (rather than labels) for LOB query columns that contain image data. QMFDQ-6382 In the help system, invalid characters may exist in the Using object tracking reports and Options resource limits topics. QMFDQ-6384 When adding a row condition to a large table, it may take a long time to complete. QMFDQ-6385 In the QMF Catalog Plug-in Parameters dialog, pressing Alt+R opens the Add Catalog dialog instead of refreshing the current list. QMFDQ-6387 In the Save to QMF Catalog dialog, the OK button is enabled even if none of the text fields are populated. QMFDQ-6389 In the Resource Limits dialog, if a User Space cell is already populated, all data is erased when it is clicked. QMFDQ-6398 In the Server Definition File Import wizard, incorrect library names may be displayed in the Driver combo box. QMFDQ-6400 Added support for preparing queries. QMFDQ-6403 Add the ability to open or edit items from directly within the search results view. QMFDQ-6045 Implement an Explorer view that can be invoked by right-clicking a given parent item in repository explorer or workspace. This new view lists objects in column format, together with the created, last saved and last opened attributes. QMFDQ-6046 Enhance the data source connections view with automatic updates and the ability to terminate a connection. QMFDQ-6411 In the Favorites folder of the Personal view, tables are automatically erased after reconnecting with the repository. QMFDQ-6412 An error may occur when a SQL Server database that contains an underscore in its name fetches table schemas. QMFDQ-6414 If there are no active repository resource limits schedules, an empty limit may be returned instead of the default limit. QMFDQ-6427 In the help system, short descriptions in the search results pane may be displayed incorrectly. QMFDQ-6432 In visual dashboards, an incorrect number of references may be displayed when renaming an object that another object uses as a reference. QMFDQ-6448 While running to sessions of QMF from the QMF API, if you invoke the close method for one of the QMF objects and try to run a query off the second, and error may occur. QMFDQ-6453 In visual dashboards rendered in HTML, the Refresh display on completion option for the Execute SQL even does not work. QMFDQ-6461 In visual dashboards rendered in HTML, if the visual dashboard contains nested layout objects, it may not open correctly. QMFDQ-6478 In the multiplatform edition of the application, when you make a change to JDBC driver settings and restart the application, an error may occur when you try to access data sources. QMFDQ-6494 When the CALC usage code is added to columns in a classic form, incorrect column values may be displayed in query results. QMFDQ-6517 In visual dashboards, when using the connectivity tool in the Palette view, the Connectivity dialog may not display column names. QMFDQ-6520 Forms and Procedures created in QMF for Windows v7.2 may give different results when run using DataQuant v1.2. QMFDQ-6521 Add the iSeries Toolbox JDBC driver to the list of built-in driver types and templates. QMFDQ-6548 In the z/OS edition of the application, the rename action for objects in shared repositories may not work. QMFDQ-6567 When a query returns a large number of rows, if the Maximum Number of Rows to Fetch warning limit and cancel limit are small, the cancel limit may display before the warning limit. QMFDQ-6608 An error may occur when using the RUN procedure command to run a query with global variables using the INSERT statement. QMFDQ-6609 If a user is assigned to a repository based resource limits group that has a name containing Japanese characters, when the application is closed and re-opened, the user will be assigned to the default group. QMFDQ-6610 When the Maximum Rows to Fetch warning limit is reached and the user clicks OK, no other warning is displayed at the next interval and the application continues to fetch rows until the cancel limit is reached. QMFDQ-6640 Provide the ability for a user to change their repository password when their current password has expired. QMFDQ-6641 Calculated columns in queries created using DataQuant v1.2 may not display properly in QMF v8. QMFDQ-6662 In visual dashboards, when a chart axis is switched from a linear to a logarithmic scale, the chart is not displayed properly. QMFDQ-6677 An error may occur when a SQL statement using the SQL Server substring function is switched to the diagram or prompted view or used in a layout object. QMFDQ-6722 If an asterisk is used in the Default table space of the Save Data resource limit, the user will see a blank space in the Save Data tab instead of the SPACE field value of the RDBI.PROFILES_VIEW table. QMFDQ-6852 Sort data sources alphabetically in the 'Set Data Source' dialog for queries and forms. QMFDQ-6977 Incorporate translated help systems covering the BIRT report designer. QMFDQ-6986 If a SELECT statement is put inside parenthesis, individual cells in the query results can not be edited. QMFDQ-7093 An error may occur when you attempt to rename a query saved to an extended QMF catalog. ********************************************** 3.0 DataQuant for WebSphere 1.2 Fix Pack 6 ********************************************** QMFDQ-229 Incorrect symbols may be displayed in the search results pane of the help window. QMFDQ-3278 Include a metadata layer which provides a means of defining virtual data sources that hide the complexities of underlying data schemas from content developers and end users. Virtual data sources also provide a means of executing federated queries, joining across tables located in differing databases. QMFDQ-3498 Add the ability to schedule procedures for one-time or periodic execution. QMFDQ-3501 Enhance the workspace view with toolbar buttons for stepping into workspace items, navigating back and forth and maximizing and restoring a given workspace view. QMFDQ-3532 In a visual dashboard rendered in the applet mode, a wait cursor appears when interacting with visual dashboard objects. QMFDQ-3534 In a visual dashboard rendered in the applet mode, a click event may occur instead of a mouse over event when the cursor is passed over check box label. QMFDQ-3704 When the sample visual dashboard titled Geometry Demo is rendered in the applet mode, the line item may be displayed in incorrect starting positions. QMFDQ-3962 In the help system and the publications, the URL for the websphere application is incorrect. QMFDQ-4005 In the help system and the publications, typos and errors were found and corrected. QMFDQ-4029 Provide a way for an end user to change their repository password. QMFDQ-4083 Include the underlying data source name in the tooltip text presented when hovering over the tab of open queries and tables. QMFDQ-4107 Provide the ability to import and run QMF for Windows job definition files. QMFDQ-4129 Provide ability to reference objects in procedures using a path relative to the location of the procedure. QMFDQ-4144 Introduce extended pie, column and bar charts that allow data points to be rolled up across one or more query columns. This facility provides features comparable to that of displaying multi-dimensional data. QMFDQ-4275 Add a drop-down list of common values for the Catalog CCSID when creating a QMF catalog. QMFDQ-4276 Add a new value to the DSQQW_PROC_WNDWS global variable to automatically close a procedure window upon completion when executed non-interactively. QMFDQ-4416 Enhance the Save to Repository dialog such that defaults to the path last used to save an object. QMFDQ-4583 The page number may be displayed over the date when converting a classic report to a visual report. QMFDQ-4821 Add support for one-time database passwords such that a given logon is not used by more than one database connection. When a data source is configured to use one-time passwords, the user is prompted for a logon each time a database connection is made. QMFDQ-4893 There is no way to manually export the results of a query without including calculated columns and grid formatting. QMFDQ-4958 Incorporate translation tables within visual projects, allowing content developers to add translated versions of text used in the dashboard. The appropriate string table is then automatically invoked by the visual project, based on the locale of the end user. QMFDQ-5134 In a visual dashboard rendered in HTML, labels may be filled with incorrect background colors. QMFDQ-5260 When viewing a visual dashboard, the Navigate back button may not work correctly after jumping to a different visual dashboard. QMFDQ-5298 Provide a means of sorting properties alphabetically. QMFDQ-5332 Support the localization of system-generated column names (used when a query does not return a column name). QMFDQ-5353 Include the associated action in the output window when a dashboard component generates an error. QMFDQ-5356 In the help system and the publications, the description of the Export Query Results dialog has changed. QMFDQ-5387 Any user can delete repository storage and repositories without authentication. QMFDQ-5424 If a visual project references other visual projects, include this information in the references collection in the repository and workspace explorer. QMFDQ-5983 Add a Personal View which allows users to view Favorites, Recently Used and Startup objects. QMFDQ-5984 A warning dialog appears multiple times when the idle query timeout limit is reached. QMFDQ-6045 Implement an Explorer view that can be invoked by right-clicking a given parent item in repository explorer or workspace. This new view lists objects in column format, together with the created, last saved and last opened attributes. QMFDQ-6043 Add a manage licenses dialog that provides a convenient means of adding and refreshing product license files. QMFDQ-6046 Enhance the data source connections view with automatic updates and the ability to terminate a connection. QMFDQ-6147 Provide the ability to limit access to a given repository to a designated LDAP group. If specified, this group acts as the Everyone collection. LDAP users not in the group are denied logon access to the repository. QMFDQ-6174 Provide the ability to specify CLOB values directly in the query text when running stored procedures with CLOBs. QMFDQ-6271 In visual dashboards rendered in HTML, an error may occur when zooming out past a factor of %0.0015. QMFDQ-6276 Top groups in query results may not collapse after being expanded. QMFDQ-6322 If the LOB options can be overridden option is selected, LOB data can be saved even if LOB data saving isn't enabled. QMFDQ-6328 An error may occur when expanding the references of a prompted query saved to the QMF catalog. QMFDQ-6351 An error occurs when you attempt to rename a multidimensional data source. QMFDQ-6381 Automatically generate a visual report with images (rather than labels) for LOB query columns that contain image data. QMFDQ-6384 When adding a row condition to a large table, it may take a long time to complete. QMFDQ-6400 Added support for preparing queries. QMFDQ-6403 Add the ability to open or edit items from directly within the search results view. QMFDQ-6412 An error may occur when a SQL Server database that contains an underscore in its name fetches table schemas. QMFDQ-6414 If there are no active repository resource limits schedules, an empty limit may be returned instead of the default limit. QMFDQ-6427 In the help system, short descriptions in the search results pane may be displayed incorrectly. QMFDQ-6453 In visual dashboards rendered in HTML, the Refresh display on completion option for the Execute SQL even does not work. QMFDQ-6461 In visual dashboards rendered in HTML, if the visual dashboard contains nested layout objects, it may not open correctly. QMFDQ-6518 Using GetObject to embed a visual dashboard in an HTML page may cause an error in the websphere application. QMFDQ-6519 SQL text saved in the QMF catalog using the Workstation application may be displayed in duplicate when opened in the websphere application. QMFDQ-6521 Add the iSeries Toolbox JDBC driver to the list of built-in driver types and templates. QMFDQ-6567 When a query returns a large number of rows, if the Maximum Number of Rows to Fetch warning limit and cancel limit are small, the cancel limit may display before the warning limit. QMFDQ-6608 An error may occur when using the RUN procedure command to run a query with global variables using the INSERT statement. QMFDQ-6609 If a user is assigned to a repository based resource limits group that has a name containing Japanese characters, when the application is closed and re-opened, the user will be assigned to the default group. QMFDQ-6610 When the Maximum Rows to Fetch warning limit is reached and the user clicks OK, no other warning is displayed at the next interval and the application continues to fetch rows until the cancel limit is reached. QMFDQ-6640 Provide the ability for a user to change their repository password when their current password has expired. QMFDQ-6677 An error may occur when a SQL statement using the SQL Server substring function is switched to the diagram or prompted view or used in a layout object. QMFDQ-6852 Sort data sources alphabetically in the 'Set Data Source' dialog for queries and forms. QMFDQ-6902 Add ability to hide the toolbar using an optional URL parameter when embedding content using the getobject http request. QMFDQ-6986 If a SELECT statement is put inside parenthesis, individual cells in the query results can not be edited.