IBM(R) DataQuant for Multiplatforms, Version 1 Release 2, Fix Pack 2 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 DATAQUANT FOR WORKSTATION 1.2 FIX PACK 2 3.0 DataQuant for WebSphere 1.2 Fix Pack 2 1.0 ABOUT THIS README FILE Welcome to IBM DataQuant for Multiplatforms, Version 1 Release 2, 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 1.2 FIX PACK 2 QMFDQ-980 A query containing 'OVER (order by [col])' SQL text generates a SQL parser exception when viewed in the query diagram or prompted query views, or when viewing query references in the repository explorer. QMFDQ-1011 A query containing 'With [temptable] ... Select [cols] ...' SQL generates a SQL parser exception when viewed in the query diagram or prompted query views, or when viewing query references in the repository explorer. QMFDQ-1013 A query containing 'Select ... From Final Table' SQL generates a SQL parser exception when viewed in the query diagram or prompted query views, or when viewing query references in the repository explorer. QMFDQ-1014 A query containing 'Select ... From Old Table' SQL generates a SQL parser exception when viewed in the query diagram or prompted query views, or when viewing query references in the repository explorer. QMFDQ-1015 A query containing the INCLUDE SQL statement generates a SQL parser exception when viewed in the query diagram or prompted query views, or when viewing query references in the repository explorer. QMFDQ-1087 A query containing 'WITH [table] AS (VALUES ...)' SQL generates a SQL parser exception when viewed in the query diagram or prompted query views, or when viewing query references in the repository explorer. QMFDQ-2633 Enhancement: Provide an ability to define an owner ID when binding packages for both QMF Catalog and Repository Storage protection. QMFDQ-2648 It is not possible to supply NULL parameter values to stored procedures. QMFDQ-2854 Users should be prevented from inserting rows into a table containing one or more LOB columns if the saving of LOB data is prevented by the resource limit policy settings. QMFDQ-2929 When calling a stored procedure via a query in a visual project, the user is prompted with a 'database will be updated' message, irrespective of whether or not the stored procedure contains SQL that updates the database. QMFDQ-3009 The 'set data source' dialog for forms and queries omits data sources with the same name but with differing case. For example, data sources 'sample' and 'Sample' are considered identical and only one is listed in the option list. QMFDQ-3017 It is not possible to define multi-faceted values within visual projects (such as locations) using a semi-colon separator. Such an option is required for locales that use a comma as the decimal separator. QMFDQ-3098 Enhancement: Provide an ability to select through combo box values using the left and right keyboard arrow keys. QMFDQ-3104 A query containing a leading '(' character in the SQL generates a SQL parser exception when viewed in the query diagram or prompted query views, or when viewing query references in the repository explorer. QMFDQ-3167 Data caching for a given table is not invalidated when the table is subsequently edited. Queries continue to return the prior data up to the data cache expiration interval. QMFDQ-3225 The 'save at repository' application action remains enabled despite not being connected to a repository. QMFDQ-3234 Enhancement: Add a date/time selection component to the palette for use in visual projects. QMFDQ-3236 The prompted query view disallows joins between data types CHAR and GRAPHIC, despite the fact that this is valid SQL. QMFDQ-3246 It is not possible to search for database objects (such as tables) across multiple data sources defined in a given repository. QMFDQ-3253 Enhancement: Add a new event action that provides a means of displaying a message via a dialog or the output window. QMFDQ-3311 After zooming into a dashboard scene containing a picture, returning to runtime mode after altering the picture's source property will result in the picture being rendered at 100% zoom, whereas the remaining scene content is rendered at the prior zoom level. QMFDQ-3314 The expression designer does not apply quotes around column name selections when the column names are used as parameters to functions that require quotes. QMFDQ-3381 The strToNum() function is not recognized as a valid source for numeric parameters for certain built-in functions. QMFDQ-3400 An event on object A may perform an event action defined for object B (rather than A) in rare cases within complex dashboards. QMFDQ-3401 Objects set to appear at a particular zoom level remain visible after returning to a zoom level which should preclude them. QMFDQ-3433 The first section in a visual report's heading section is geometrically smaller than all other sections. This incorrect sizing is reset when an item is moved on the report canvas. QMFDQ-3434 Layouts on a visual report are not extended onto adjacent horizontal pages when their content cannot fit on a single page. QMFDQ-3467 Visual report page sections are created with an initial size smaller than the default. Subsequent edits to the report content reset the section size to the correct value. QMFDQ-3470 Visual report layouts are displayed smaller than their actual size when viewed in design mode. QMFDQ-3474 Palette objects in visual projects with gradient settings are not rendered consistently across all output formats. QMFDQ-3482 EmbeddedContent object does not support external file names and paths that contain certain valid characters, such as '[' and '#'. QMFDQ-3499 Enhancement: Provide a means of storing personal repositories directly within an embedded database engine. QMFDQ-3508 A query parameters collection is not presented under visual project components that reference parameterized queries. QMFDQ-3516 The 'Confirm Stored Procedure Parameters' dialog does not display the name of the underlying stored procedure. QMFDQ-3517 It is not possible to define the encoding to be used for CLOB data when passed as a parameter to a stored procedure. QMFDQ-3520 It is not possible to remove a top group from the grid by dragging and dropping the column, unless there is at least one other top or side group defined. QMFDQ-3525 SQL editor content assist incorrectly interprets join clauses, leading to program errors and incorrect auto-completions. QMFDQ-3530 Queries referencing sysibm.sysdummy1 list the special table as a regular table dependency in the repository explorer. QMFDQ-3536 The Query->Prepare menu action does not produce an empty result set when applied to queries that call stored procedures. QMFDQ-3550 Creating a visual report from a parameterized query results in the omission of the query parameter if a parameter of the same name has been defined at the application level. QMFDQ-3561 Query SQL containing an IN clause with a single value in the set will be re-written without the IN clause after transitioning to the query diagram or prompted query views. QMFDQ-3579 Query diagram and prompted query views remove all SQL comments despite no changes being made in either of these editors. QMFDQ-3606 Context help is not provided in the expression designer dialog. QMFDQ-3619 The DSQAO_NUM_FETCHED and DSQAO_QUERY_MODEL global variables are not reset to their default values after query is closed. QMFDQ-3621 The DSQAO_CONNECT_ID global variable is not set in some cases. QMFDQ-3636 The /run command line directive fails to run queries. QMFDQ-3645 Text wrapping in visual projects is inconsistent between differing zoom levels. QMFDQ-3662 The 'undo set as default' context menu option is inappropriately offered for palette objects that have had their settings reset to default values. QMFDQ-3668 The dashboard ViewerMove event is inappropriately fired when moving from design to runtime mode and also does not fire when panning a scene. QMFDQ-3671 Enhancement: Include the repository connections view in the administrator perspective. QMFDQ-3683 The ImageDown, ImageSource and ImageFocus properties of a button are ignored when running a dashboard in HTML mode. QMFDQ-3693 It is possible to assign an empty name to both a repository object and a repository folder. QMFDQ-3696 The query editor does not recognize NAME as a reserved word when working with Informix data sources. QMFDQ-3697 When exporting a classic report to HTML, an additional empty row is added to the footer of the results. QMFDQ-3700 A dashboard may display a radio group state that differs from the radio group value when rendering a dashboard in HTML mode. QMFDQ-3701 Creating a procedure to run a newly created report will generate an exception if the report was generated from a query that was not subsequently saved. QMFDQ-3711 When an object in a data template sets the property of another object in the same template, all instances of the referenced object are changed, rather than just the one associated with the originator of the change. QMFDQ-3717 An inappropriate error message is generated when a user attempts to alter a data source logon mapping for an account to which they have insufficient access rights. QMFDQ-3738 Dates and page numbers are omitted from classic reports when exporting them to PDF format. QMFDQ-3752 After moving between the scene level and data template level in a visual dashboard, the editor's forward and backward buttons continue to provide a means of moving between these levels even after the associated layout is deleted from the scene. QMFDQ-3772 Enhancement: When double-clicking on palette items in the visual report designer, automatically place such items directly into the report section that has input focus. QMFDQ-3782 When exporting results to a table that already exists, a warning message stating that the content will be replaced is displayed multiple times. QMFDQ-3787 The OLAP slicer control may produce multiple copies of the drop-down list when running in HTML mode. QMFDQ-3790 Enhancement: Automatically highlight parameters after inserting a function into the expression designer. QMFDQ-3795 Users are not prevented from starting the process of defining a QMF catalog within a non-DB2 database. QMFDQ-3796 It is possible to delete the last remaining level from a scene or layout, resulting in subsequent application errors. QMFDQ-3801 Horizontal alignment settings for labels are ignored when running in HTML mode. QMFDQ-3803 The data grid may clip the leftmost row number column when running within a visual project. QMFDQ-3804 A dashboard retains its 'changed/unsaved' state after altering a query and subsequently electing not to save the changes to the query. QMFDQ-3808 A newly added 'level of detail' does not default its minimum zoom property to the zoom level associated with the level's transition value. QMFDQ-3809 After exporting a result set to a table and supplying a comment, subsequent exports to the same table do not reflect subsequent changes to the comment field. QMFDQ-3811 When generating a visual report from a query, columns that cannot be accommodated on the first horizontal page are displayed using empty rectangles in the visual designer. QMFDQ-3812 Visual reports that have been generated from classic reports may clip content in adjacent horizontal pages. QMFDQ-3816 When searching for field values in the results grid, the search facility may omit the first or last occurrence of the search term, depending on the direction of the search. QMFDQ-3817 The tree chart does not correctly render items that have no implicit parent item. QMFDQ-3826 The drilldown wizard creates a new parameter in the destination scene even when the user elects to set an existing scene parameter with a passed value. QMFDQ-3828 It is not possible to generate a dashboard in PDF format if the dashboard scene(s) have no content within them. QMFDQ-3831 The preview page for an OLAP query is corrupted after subsequent changes to the included dimensions or measures. QMFDQ-3832 Fixed size checkboxes are not displayed clipped in HTML mode and clicking on the checkbox label does not alter the control's state. QMFDQ-3833 A query's layout page may contain extraneous columns after generating a classic report from the query. QMFDQ-3837 Visual report projects remain in the unsaved state after saving the project. QMFDQ-3838 An empty list is presented when attempting to apply an existing visual report stored in the repository to an open result set. QMFDQ-3841 Dashboards fire the click event twice when a checkbox control is clicked. QMFDQ-3850 A confirmation prompt is displayed twice when copying data between data sources if the destination already has a table of the same name. QMFDQ-3856 An application error will be generated when attempting to preview the report after moving the stored location of a linked query. QMFDQ-3857 Radio buttons in the 'Protection' tab of the QMF Catalog Plug-in parameters dialog are initially presented without default values. QMFDQ-3861 OLAP slicer objects do not automatically present all viable options. QMFDQ-3862 Dependent OLAP query grid(s) do not automatically refresh when changes are made to corresponding slicer selections. QMFDQ-3865 An inappropriate undo action is offered after electing to insert a new image into the global images collection but then subsequently cancelling the insert image dialog. QMFDQ-3867 The insert new data template dialog permits users to click on the 'Done' button even when there are no available queries in the dashboard, subsequently generating an application error upon dismissing the dialog. QMFDQ-3868 It is possible to save an object with a period as the first character in the object name. Such named objects are subsequently omitted from the repository explorer. QMFDQ-3870 An invalid error message is displayed after inserting a link to a data source that requires authentication and subsequently cancelling the logon dialog. QMFDQ-3871 Objects within the data template of a layout that is itself included in a data template receive values for outer query columns that are based on the inner query row number rather than the corresponding outer query row number. QMFDQ-3873 Enhancement: Provide visual feedback as packages are being created at a given data source. QMFDQ-3874 The OLAP slicer wizard continues to present OLAP terminology after the user elects to populate the slicer control using a relational query. QMFDQ-3875 A layout that cannot run due to a missing parameter value is not refreshed when the parameter value is subsequently supplied via an event action. QMFDQ-3876 Resource limit errors may occur when defining a DB2 data source without enabling the QMF catalog plugin. QMFDQ-3878 When pasting an object onto a visual project that has the same name as an existing object, the rename dialog erroneously disables the OK button after responding to the user's attempt to enter an identical name and reverting to a valid name. QMFDQ-3880 The slider's pointer facet is painted beyond the graduation range when displayed in the maximum value position in HTML mode. QMFDQ-3881 A type conversion error is not generated upon supplying an empty default value for a non-text parameter type. QMFDQ-3882 The 'switch repository' dialog permits users to close the dialog with an OK action even when there are no defined repository connections. This results in an application error upon dismissing the dialog. QMFDQ-3883 Entering an invalid property value does not provide a visual indication of the error, other than a message in the output window. A message should be displayed in the property value area. QMFDQ-3885 An error may be generated while browsing objects within a QMF Catalog that is associated with an Oracle database. QMFDQ-3888 PDF content generated from query results may contain incorrect border calculations, resulting in layout errors in the document. QMFDQ-3889 When synchronizing offline tables, child items are not automatically checked when parent items are defaulted to checked values, resulting in unexpected behavior when the 'Remove not checked offline entries' option is selected. QMFDQ-3890 An erroneous 'More authentication information required' message may be generated when renaming or manipulating links to repository objects. QMFDQ-3891 An error message may be generated while creating or deleting/re-creating stored procedure protection of repository tables within a data source. QMFDQ-3893 When transferring a query to a QMF catalog associated with a data source that does not contain tables referenced by the query, an error is not generated when the query is opened. QMFDQ-3900 An error message may be generated when attempting to connect to a protected repository located within an Informix data source. QMFDQ-3902 The 'Enter substitution variables' dialog may repeatedly appear while editing one of several data templates associated with a given visual project layout. QMFDQ-3903 The caption in the application title bar is not updated after closing a visual dashboard. QMFDQ-3905 It is not possible to supply null values to date/time data types within BIRT reports. QMFDQ-3908 Queries containing 'select ... into" clauses lose their 'into' clause when viewing the query in the query diagram or prompted views. QMFDQ-3913 Labels within HTML-rendered visual projects clip from the start of the text rather than from the end of it. QMFDQ-3914 A 'LOB data saving is denied' resource limit error may be issued even if LOB saving options have been granted. QMFDQ-3918 Queries containing double-quotes around column names generate errors when executed against Informix data sources. QMFDQ-3921 Command Library Interface fails to execute form directives supplied in the qmfbatch.cfg line. QMFDQ-3922 The expression designer erroneously reports syntax errors when entering a correctly formatted fieldValue() expression. QMFDQ-3924 Running a query by double-clicking on the query item will produce no rows if the query's output columns collection was expanded prior to running the query. QMFDQ-3929 An error occurs in the Expression Designer if the tab key is pressed while the caret is not located at or within a function parameter. QMFDQ-3930 Table borders are removed when viewing a visual report at the 50% zoom level. QMFDQ-3940 Enhancement: Add support for the "?/?" formatNum template. For example, ?/? with 0.5 should return 1/2. QMFDQ-3941 Comparisons between two string expressions return incorrect values. QMFDQ-3943 An application error may occur when double-clicking on the prompted query's table list after cancelling the 'Add Column' dialog. QMFDQ-3944 A 'More authentication information needed' message is displayed when issuing a command bar statement against a data source that has a QMF catalog hosted in a differing data source. QMFDQ-3948 It is possible to drag and drop a data template level from a visual dashboard to a visual report, even though visual reports only support one data template level. QMFDQ-3950 Enhancement: Provide a means of executing QMF Job Definition Files on the command line. QMFDQ-3952 The dateToDB function generates forward slash separated date values, rather than dash separated values. QMFDQ-3953 Pointsets are displayed with dimension units when manipulated in the calculator view. QMFDQ-3954 An application error is generated when attempting to run a visual report with a query that does not have default parameter values. QMFDQ-3960 The calculator view does not support Undo/Redo actions. QMFDQ-3963 The display report procedure command only considers visual reports when locating the referenced report. In addition, the RESET GLOBAL ALL may not take effect prior to running a given object in the same procedure. QMFDQ-3964 Enhancement: Add support for referring to objects within procedures using paths relative to the procedure's location. QMFDQ-3966 Errors may occur when attempting to manipulate an object's properties during a dashboard scene's LoadComplete event. QMFDQ-3967 Multiple page footings in a visual report are rendered in reverse order when viewed in preview mode. QMFDQ-3968 Page orientation changes cannot be made to a visual report if the page has been defined using a custom width and height. QMFDQ-3974 Enhancement: Provide a mechanism by which an end user can change their repository password. QMFDQ-3978 The JDBC URL is not initialized to the JDBC driver's template when a new driver is selected. QMFDQ-3980 It is possible to select the 'Open from QMF Catalog' option when working with a data source that has the QMF Catalog plug-in disabled. QMFDQ-3983 The perm(n, m) function generates an error despite being called with valid parameter values. QMFDQ-3988 Table aliases are not displayed when applied to data sources that do not have a QMF catalog defined. QMFDQ-3990 An unsaved visual project continues to be closed after the user elects to save changes but then cancels through the subsequent save dialog. QMFDQ-3991 An erroneous warning message is displayed when creating a new workspace in a repository that is secured using internal security. QMFDQ-3995 The application may hang when altering a query used by a scene that is currently in runtime mode if the scene is then subsequently refreshed using the dashboard toolbar's refresh option. QMFDQ-4007 An application error may occur when converting a classic report to a visual report if the report contains a BREAK on columns other than the first column. QMFDQ-4009 The 'Print as PDF' and 'Print report on the server' BIRT report options generate errors when selected. QMFDQ-4012 Navigating to a dashboard from another dashboard results in differing destination scenes, based on whether or not the destination dashboard is opened in a new tab. QMFDQ-4015 The 'collect support data' menu action saves an empty log file when running on z/OS. QMFDQ-4016 A 'concurrent modification' error may be generated when repeatedly editing a given expression in the event action's 'set values' dialog. QMFDQ-4024 The DISPLAY REPORT and EXPORT REPORT procedure commands cannot be applied to visual reports when running via the command library interface. QMFDQ-4026 When generating a classic report from a large query, all rows from the query are fetched before the report is generated. Users should be given the option to fetch all rows or work with the partial result that has been already retrieved. QMFDQ-4027 Enhancement: Remember the last repository location under which an item was saved and default to this location when saving new items. QMFDQ-4028 The Open from QMF Catalog keyboard accelerator (Ctrl+Shift+F12) invokes the dialog even when the action is not applicable and the corresponding menu item is disabled. QMFDQ-4037 Attempting to paste a dashboard that has been subsequently deleted results in an application error. QMFDQ-4044 Bar charts cannot be added to dashboards when the product is running under a V6 Java runtime environment. QMFDQ-4047 An application exception may occur when consecutively adding and then removing users and groups from the logon mappings for a given data source. QMFDQ-4048 A destination dashboard is not displayed in full screen mode when navigating from a prior dashboard that is in full screen mode, if the navigation requires the destination to be displayed in a new tab. QMFDQ-4051 An 'Index out of bounds' error may be displayed when completing the layout wizard for hierarchical layouts if the parent field was set to a given column and then altered to another column before closing the wizard. QMFDQ-4053 An application error may be generated when attempting to set user permissions for an object immediately following prior add and remove group/user actions. QMFDQ-4057 The 'last updated property' value for a dashboard is not updated immediately following further saves to the dashboard. QMFDQ-4062 It is not possible to open a visual project by copy and pasting it into the project explorer. QMFDQ-4063 It is not possible to paste images from the clipboard into a scene or report in design mode. Such an action should result in inserting the pasted image as a new picture. QMFDQ-4189 CSV files are not generated with semi-colon delimiters when generated in locales that use such a character for a separator. QMFDQ-4223 Entering multiple parameters for the 'isNull()' function in the expression designer, such as isNull(1,2), results in application errors. QMFDQ-4229 Erroneous configuration information entered during the definition of an LDAP-based repository cannot be subsequently corrected. QMFDQ-4240 Assigning a subsequent user or group to resource limits which already has assigned groups will result in an application error. QMFDQ-4243 Logical expressions should be listed under Logical folder in the expression designer, rather than the Arithmetic folder. QMFDQ-4247 Enhancement: Provide an additional option to close command line launched procedure windows after the procedures have completed their execution. QMFDQ-4251 The expression designer's content assist facility is not enabled unless the expression starts with an equals sign. QMFDQ-4252 Content assist in the SQL query view places does not insert a space between a column name and the ASC or DESC sort order directive. QMFDQ-4255 It is not possible to connect to a protected repository that is contained within an Oracle database. QMFDQ-4256 After opening an running a query stored in the repository and then dragging the query into a visual dashboard project, subsequently closing the original query and then re-running the dashboard's reference to the query will result in an empty result set being returned when run for the first time. Subsequent executions will return results as expected. QMFDQ-4261 Saving a Form to PDF that is set to continuous mode results in a one page PDF document, despite the form yielding multiple pages of data. QMFDQ-4263 An application error may be generated when switching between multiple runtime dashboard scenes using the Ctrl+PgUp and Ctrl+PgDn keyboard shortcuts. QMFDQ-4271 Default CCSID values for extended QMF catalogs differ between the workstation and web admin facilities. QMFDQ-4273 ViewerX and ViewerY global variables reflect changes to the viewer's viewpoint when a scene is zoomed in or out. QMFDQ-4277 After concurrently creating multiple unsaved dashboards, the File->Save All menu action only prompts to save the currently selected dashboard. QMFDQ-4288 Cancelling out of a DB logon dialog when creating a new query against a data source results in repeated prompting for the same logon information. QMFDQ-4289 Creating a new OLAP query via the File->New application menu action may result in an application error. QMFDQ-4297 The expression designer should automatically preface a format number expression with an equals sign if the current property value does not lead with one. QMFDQ-4299 Changes to a visual project are not always detected, preventing the user from saving such changes or being prompted to save them when the project is closed. QMFDQ-4302 The report footing on the last page of a visual report is displayed before the page heading when the report is displayed in PDF form. QMFDQ-4309 It is not possible to rename repository objects that contain specific character sequences that resemble repository paths. QMFDQ-4313 Enhancement: Provide a means of directly referencing scene, global or application global variables within an Execute SQL Statement event action. Variable references are resolved from local to global to application global. If not defined at any level, the user will be prompted for the parameter value. QMFDQ-4315 When placing layouts within a visual report's detail section that use the same query as that driving the report sections, references to a given query column return the last row processed by the layout rather than the current row associated with the detail section itself. QMFDQ-4318 After defining a comment on a query, the comment may be subsequently removed if the query is opened and re-saved during the same application instance. QMFDQ-4323 Changes made to an OLAP query by the layout wizard of an OLAP-capable layout are not reflected in an open OLAP query view until the user switches between the query's display tabs. QMFDQ-4324 It is not possible to print a query result set using the Ctrl+P keystroke if two or more query results views are concurrently open. QMFDQ-4330 When generating a classic report from a query with at least one calculated column, the user is erroneously prompted for substitution variables, irrespective of whether or not the query SQL contains parameters. QMFDQ-4331 The repository protection checkbox is displayed as unchecked when reviewing the properties of a repository storage that has been created with repository protection. QMFDQ-4343 Enhancement: Provide a drop-down list of valid values when prompting for catalog CCSID values. QMFDQ-4350 An application error is generated when renaming a user that is a member of two or more groups. QMFDQ-4355 The default table space contains extraneous spaces when applied to resource limits associated with DB2 on z\OS data sources. QMFDQ-4357 The default font setting for classic reports is not applied to reports created by QMF for Windows V7. QMFDQ-4358 Type conversion errors may be erroneously generated when entering certain function and parameter combinations in visual projects. QMFDQ-4368 Insert query option should be renamed to insert data file when attempting to add an external file to a visual project that does not contain data source connections QMFDQ-4370 The last accessed data source should be retained between application sessions and used as the default data source when creating new objects. QMFDQ-4379 The EXPORT procedure command prepends an asterisk to the name of an ad-hoc query referenced by it. QMFDQ-4381 After selecting the Query->Prepare menu action on an empty query, subsequently entering SQL text returns an empty result set when the query is executed. QMFDQ-4389 An application error is generated when attempting to render nested data-driven tables in PDF format. QMFDQ-4390 It is not possible to edit a fixed list of combo or listbox option list values if the value property setting is not contained within the option list. QMFDQ-4392 The PRINTER attribute of the RUN procedure command requires case-sensitive references to installed printers and automatically uses the default printer if an explicit match is not made. The command should raise an error if the specified printer cannot be located. In addition, the printer name should be case-insensitive. QMFDQ-4393 Space is devoted to pie slices that are currently marked as invisible. QMFDQ-4394 Enhancement: Simplify the logon mapping dialog to increase ease of use. QMFDQ-4401 An application error will be generated after opening a dashboard from a file and then re-connecting to the same repository or connecting to a differing repository without closing the dashboard project. QMFDQ-4403 An application error is generated when reviewing the resource limits associated with the 'Queries' element under a QMF Catalog within the repository or workspace explorer. QMFDQ-4404 The sort order of items in the properties view for visual project elements may change when transitioning from runtime to design time modes. QMFDQ-4408 After correcting a reference to a non-existent object in the 'set values' event action dialog, an error relating to the prior missing object reference is still presented when attempting to apply the new 'set value' expression. QMFDQ-4425 The 'Emulate Host QMF Column Naming' data source property is presented as a free-form editable field even though true and false are the only valid options QMFDQ-4431 Supplying a default value for a DateTime query parameter with the YYYY-MM-DD format is converted to an invalid format when the visual project is subsequently re-opened. QMFDQ-4445 The application may hang when running a visual project that contains one or more circular references QMFDQ-4450 The visual designer does not prevent a user from adding objects within a table's data template that are not a direct or indirect child of a table row. QMFDQ-4452 Deleting line items in the 'set values' event action may result in an application error in certain cases. QMFDQ-4465 An application error may occur when running a visual project located in an 'Internal security' repository if connecting via a network repository connection. QMFDQ-4466 An application error is generated when executing a command bar statement that requires a data source logon if the subsequent logon dialog is cancelled. QMFDQ-4474 The File->New Relational Data Source wizard does not appear when selected upon first loading the application. QMFDQ-4478 It is not possible to return to the first page of the new OLAP Query wizard using the back button on the second page. QMFDQ-4488 The query parameters collection is not presented under a visual project object if the fieldValue() function referring the parameterized query contains variables or expressions, rather than explicit values. QMFDQ-4548 A 'Jump to new location' dashboard event action generates an application error if it is programmed to set the value of a scene parameter that has been subsequently deleted. QMFDQ-4550 Time formatting is added to date/time types when supplying certain date-only expressions, such as to 'Oct 15, 2007'. QMFDQ-4555 The 'Insert Fixed Page' context menu should be restricted to the 'Fixed Pages' tree item and should not appear on fixed page items under it. QMFDQ-4557 Visual projects continue to display a modified status when saved under a new name or location. QMFDQ-4564 The parameter list may contain duplicates when repeatedly selecting the retrieve parameters button in the 'jump to new location' event action dialog. QMFDQ-4571 A visual report may skip detail section rows if the detail section contains one or more data-driven layouts. QMFDQ-4683 A 'result set index 0 for query...' error message may be generated when running parameterized queries within visual projects in HTML mode. ********************************************** 3.0 DataQuant for WebSphere 1.2 Fix Pack 2 ********************************************** QMFDQ-980 A query containing 'OVER (order by [col])' SQL text generates a SQL parser exception when viewed in the prompted query view. QMFDQ-1011 A query containing 'With [temptable] ... Select [cols] ...' SQL generates a SQL parser exception when viewed in the prompted query view. QMFDQ-1013 A query containing 'Select ... From Final Table' SQL generates a SQL parser exception when viewed in the prompted query view. QMFDQ-1014 A query containing 'Select ... From Old Table' SQL generates a SQL parser exception when viewed in the prompted query view. QMFDQ-1015 A query containing the INCLUDE SQL statement generates a SQL parser exception when viewed in the prompted query view. QMFDQ-1087 A query containing 'WITH [table] AS (VALUES ...)' SQL generates a SQL parser exception when viewed in the prompted query view. QMFDQ-2633 Enhancement: Provide an ability to define an owner ID when binding packages for both QMF Catalog and Repository Storage protection. QMFDQ-2648 It is not possible to supply NULL parameter values to stored procedures. QMFDQ-2929 When calling a stored procedure via a query in a visual project, the user is prompted with a 'database will be updated' message, irrespective of whether or not the stored procedure contains SQL that updates the database. QMFDQ-3089 WebSphere admin console requires a username and password when defining repository storage, irrespective of whether or not the data source requires one. QMFDQ-3104 A query containing a leading '(' character in the SQL generates a SQL parser exception when viewed in the prompted query view. QMFDQ-3234 Enhancement: Add a date/time selection component to the palette for use in visual projects. QMFDQ-3236 The prompted query view disallows joins between data types CHAR and GRAPHIC, despite the fact that this is valid SQL. QMFDQ-3253 Enhancement: Add a new event action that provides a means of displaying a message via a dialog or the output window. QMFDQ-3400 An event on object A may perform an event action defined for object B (rather than A) in rare cases within complex dashboards. QMFDQ-3401 Objects set to appear at a particular zoom level remain visible after returning to a zoom level which should preclude them. QMFDQ-3433 The first section in a visual report's heading section is geometrically smaller than all other sections. This incorrect sizing is reset when an item is moved on the report canvas. QMFDQ-3434 Layouts on a visual report are not extended onto adjacent horizontal pages when their content cannot fit on a single page. QMFDQ-3474 Palette objects in visual projects with gradient settings are not rendered consistently across all output formats. QMFDQ-3482 EmbeddedContent object does not support external file names and paths that contain certain valid characters, such as '[' and '#'. QMFDQ-3517 It is not possible to define the encoding to be used for CLOB data when passed as a parameter to a stored procedure. QMFDQ-3561 Query SQL containing an IN clause with a single value in the set will be re-written without the IN clause after transitioning to the prompted query view. QMFDQ-3569 A dashboard may display an inappropriate level for a given zoom percentage. QMFDQ-3579 The prompted query view removes all SQL comments despite no changes being made in the editor. QMFDQ-3645 Text wrapping in visual projects is inconsistent between differing zoom levels. QMFDQ-3683 The ImageDown, ImageSource and ImageFocus properties of a button are ignored when running a dashboard in HTML mode. QMFDQ-3693 It is possible to assign an empty name to both a repository object and a repository folder. QMFDQ-3696 The query editor does not recognize NAME as a reserved word when working with Informix data sources. QMFDQ-3700 A dashboard may display a radio group state that differs from the radio group value when rendering a dashboard in HTML mode. QMFDQ-3711 When an object in a data template sets the property of another object in the same template, all instances of the referenced object are changed, rather than just the one associated with the originator of the change. QMFDQ-3738 Dates and page numbers are omitted from classic reports when exporting them to PDF format. QMFDQ-3787 The OLAP slicer control may produce multiple copies of the drop-down list when running in HTML mode. QMFDQ-3792 A repository connection is no longer displayed in the administration console after setting an incorrect username and password and subsequently restarting the web application. QMFDQ-3795 Users are not prevented from starting the process of defining a QMF catalog within a non-DB2 database. QMFDQ-3801 Horizontal alignment settings for labels are ignored when running in HTML mode. QMFDQ-3803 The data grid may clip the leftmost row number column when running within a visual project. QMFDQ-3812 Visual reports that have been generated from classic reports may clip content in adjacent horizontal pages. QMFDQ-3817 The tree chart does not correctly render items that have no implicit parent item. QMFDQ-3825 The administration console erroneously reports missing string resources to a debug console when adding, removing or editing data sources. QMFDQ-3828 It is not possible to generate a dashboard in PDF format if the dashboard scene(s) have no content within them. QMFDQ-3832 Fixed size checkboxes are not displayed clipped in HTML mode and clicking on the checkbox label does not alter the control's state. QMFDQ-3833 A query's layout page may contain extraneous columns after generating a classic report from the query. QMFDQ-3836 When applying multiple inappropriate usage codes for columns in a classic report, the report continues to report an error message related to the first problem, even after the first issue is resolved (provided other issues remain). QMFDQ-3841 Dashboards fire the click event twice when a checkbox control is clicked. QMFDQ-3842 The workstation product provides a means of generating a report from an OLAP query. The web client offers no such option. QMFDQ-3854 An exception may be reported after logging out of the web application session. QMFDQ-3855 Repository and data source lists are sorted inconsistently in the admin console. QMFDQ-3861 OLAP slicer objects do not automatically present all viable options. QMFDQ-3868 It is possible to save an object with a period as the first character in the object name. Such named objects are subsequently omitted from the repository explorer. QMFDQ-3871 Objects within the data template of a layout that is itself included in a data template receive values for outer query columns that are based on the inner query row number rather than the corresponding outer query row number. QMFDQ-3875 A layout that cannot run due to a missing parameter value is not refreshed when the parameter value is subsequently supplied via an event action. QMFDQ-3876 Resource limit errors may occur when defining a DB2 data source without enabling the QMF catalog plugin. QMFDQ-3877 The getNodeChildren web service API method does not return the list of data sources defined in a given repository. QMFDQ-3880 The slider's pointer facet is painted beyond the graduation range when displayed in the maximum value position in HTML mode. QMFDQ-3885 An error may be generated while browsing objects within a QMF Catalog that is associated with an Oracle database. QMFDQ-3888 PDF content generated from query results may contain incorrect border calculations, resulting in layout errors in the document. QMFDQ-3891 An error message may be generated while creating or deleting/re-creating stored procedure protection of repository tables within a data source. QMFDQ-3892 An application error is generated while attempting to create a QMF catalog during the definition of a new data source via the admin console. QMFDQ-3893 When transferring a query to a QMF catalog associated with a data source that does not contain tables referenced by the query, an error is not generated when the query is opened. QMFDQ-3894 Database views are not rendered with appropriate icons when displayed in the workspace explorer. QMFDQ-3896 An 'Undefined or wrong catalog identifier' message may be displayed while attempting to define an LDAP repository via the admin console. QMFDQ-3897 If the user generates an error in the LDAP dialog pages in the admin console, subsequent dismissals of the error dialogs also dismiss the underlying LDAP dialog pages. QMFDQ-3898 Permissions settings remain partially defined after deleting the group to which the permissions refer. QMFDQ-3900 An error message may be generated when attempting to connect to a protected repository located within an Informix data source. QMFDQ-3905 It is not possible to supply null values to date/time data types within BIRT reports. QMFDQ-3908 Queries containing 'select ... into" clauses lose their 'into' clause when viewing the query in the prompted view. QMFDQ-3913 Labels within HTML-rendered visual projects clip from the start of the text rather than from the end of it. QMFDQ-3918 Queries containing double-quotes around column names generate errors when executed against Informix data sources. QMFDQ-3930 Table borders are removed when viewing a visual report at the 50% zoom level. QMFDQ-3935 The 'Remember this Information' checkbox state does not restore the user's prior selection. QMFDQ-3940 Enhancement: Add support for the "?/?" formatNum template. For example, ?/? with 0.5 should return 1/2. QMFDQ-3941 Comparisons between two string expressions return incorrect values. QMFDQ-3944 A 'More authentication information needed' message is displayed when issuing a command bar statement against a data source that has a QMF catalog hosted in a differing data source. QMFDQ-3952 The dateToDB function generates forward slash separated date values, rather than dash separated values. QMFDQ-3954 An application error is generated when attempting to run a visual report with a query that does not have default parameter values. QMFDQ-3963 The display report procedure command only considers visual reports when locating the referenced report. In addition, the RESET GLOBAL ALL may not take effect prior to running a given object in the same procedure. QMFDQ-3964 Enhancement: Add support for referring to objects within procedures using paths relative to the procedure's location. QMFDQ-3966 Errors may occur when attempting to manipulate an object's properties during a dashboard scene's LoadComplete event. QMFDQ-3967 Multiple page footings in a visual report are rendered in reverse order. QMFDQ-3970 It is not possible to pass a query parameter to a getObject method, nor is it possible to repeatedly call for differing repository content using the same getObject browser session. QMFDQ-3974 Enhancement: Provide a mechanism by which an end user can change their repository password. QMFDQ-3979 The admin console user interface permits users to alter the security model for a given repository even though this action is not programmatically supported. QMFDQ-3983 The perm(n, m) function generates an error despite being called with valid parameter values. QMFDQ-3988 Table aliases are not displayed when applied to data sources that do not have a QMF catalog defined. QMFDQ-4009 The 'Print as PDF' and 'Print report on the server' BIRT report options generate errors when selected. QMFDQ-4012 Navigating to a dashboard from another dashboard results in differing destination scenes, based on whether or not the destination dashboard is opened in a new tab. QMFDQ-4026 When generating a classic report from a large query, all rows from the query are fetched before the report is generated. Users should be given the option to fetch all rows or work with the partial result that has been already retrieved. QMFDQ-4027 Enhancement: Remember the last repository location under which an item was saved and default to this location when saving new items. QMFDQ-4030 The Open from QMF Catalog option is enabled when no applicable data sources are defined in the repository. This action subsequently results in an application error. QMFDQ-4040 An application error may occur when attempting to create new XMLA Data Source in the admin console. QMFDQ-4059 Application errors may be generated when editing internal security user accounts using the admin console. QMFDQ-4189 CSV files are not generated with semi-colon delimiters when generated in locales that use such a character for a separator. QMFDQ-4229 Erroneous configuration information entered during the definition of an LDAP-based repository cannot be subsequently corrected. QMFDQ-4255 It is not possible to connect to a protected repository that is contained within an Oracle database. QMFDQ-4261 Saving a Form to PDF that is set to continuous mode results in a one page PDF document, despite the form yielding multiple pages of data. QMFDQ-4271 Default CCSID values for extended QMF catalogs differ between the workstation and web admin facilities. QMFDQ-4273 ViewerX and ViewerY global variables reflect changes to the viewer's viewpoint when a scene is zoomed in or out. QMFDQ-4281 An application error is generated when attempting to edit the definition of an XMLA data source that contains invalid connection parameters. QMFDQ-4302 The report footing on the last page of a visual report is displayed before the page heading when the report is displayed in PDF form. QMFDQ-4313 Enhancement: Provide a means of directly referencing scene, global or application global variables within an Execute SQL Statement event action. Variable references are resolved from local to global to application global. If not defined at any level, the user will be prompted for the parameter value. QMFDQ-4315 When placing layouts within a visual report's detail section that use the same query as that driving the report sections, references to a given query column return the last row processed by the layout rather than the current row associated with the detail section itself. QMFDQ-4330 When generating a classic report from a query with at least one calculated column, the user is erroneously prompted for substitution variables, irrespective of whether or not the query SQL contains parameters. QMFDQ-4343 Enhancement: Provide a drop-down list of valid values when prompting for catalog CCSID values. QMFDQ-4355 The default table space contains extraneous spaces when applied to resource limits associated with DB2 on z\OS data sources. QMFDQ-4357 The default font setting for classic reports is not applied to reports created by QMF for Windows V7. QMFDQ-4370 The last accessed data source should be retained between application sessions and used as the default data source when creating new objects. QMFDQ-4371 Navigating from a visual dashboard to a visual report via an event action may result in an application hang. QMFDQ-4389 An application error is generated when attempting to render nested data-driven tables in PDF format. QMFDQ-4392 The PRINTER attribute of the RUN procedure command requires case-sensitive references to installed printers and automatically uses the default printer if an explicit match is not made. The command should raise an error if the specified printer cannot be located. In addition, the printer name should be case-insensitive. QMFDQ-4393 Space is devoted to pie slices that are currently marked as invisible. QMFDQ-4421 Errors may occur when attempting to create a new OLAP query against a DB2 Cube Views data source. QMFDQ-4445 The application may hang when running a visual project that contains one or more circular references. QMFDQ-4453 The list of repositories contained within a given repository storage is presented unsorted in the admin console. QMFDQ-4548 A 'Jump to new location' dashboard event action generates an application error if it is programmed to set the value of a scene parameter that has been subsequently deleted. QMFDQ-4560 The application may hang when formatting query results with a multi-column page width and when navigating to the last horizontal page. QMFDQ-4571 A visual report may skip detail section rows if the detail section contains one or more data-driven layouts. QMFDQ-4683 A 'result set index 0 for query...' error message may be generated when running parameterized queries within visual projects in HTML mode. QMFDQ-4684 A 'navigate to an external dashboard' event action fails if the source dashboard is rendered in HTML and the destination dashboard is set to a 'user defined' rendering option.