Intelligent Decision Server 1.0.2 OS/2 Server and Workstation Fixes Problems that are fixed by "jw95f" fix level: *NOTE: This fixpack will required the DISBIND command to be executed for databases on DB2/2 and DB2/UDB/OS2. 40157- PC RFT converts more than selected text. For example, select and copy 1 line of text from a paragraph over to the PC RFT icon. Now select and copy the PC RFT icon to a blank text icon, more than one line of text appears. 42213- Spreadsheet regions stops on row 9992, when it should expand to row 9999. 43170- Query's General Qualifier does not use SQLNAME. 43589- Layout with Courier font 8, resets IDS when Report header is optioned. 43700- DBA tool, time column lost when added to the logical database. 43707- Unable to open the DBA tool. The Query, Reporter and Data Entry tools displays this error message: DBTYPE: Value that specifies the characteristics of the database cannot be found. 43717- When logging in as the operator on the File Service console, the commands for STATUS and DETAILS are not working. 43170- Phost port to Windows. When printing with the new PHost printer for Win95/NT machines, only 1 copy is supported. 43723- 100% CPU CATRANS problem. 43734- Data Entry, Bi-Month, Year and Quarter are displayed incorrectly. 43744- Forms Design connected to a Text icon, when executed in a Capsule, results in a reset of IDS. 43778- Data Entry choice fields that are dependent on other fields within the tool, resets IDS when Enter button is selected. 43785- Text tool, region with @ variables that includes tabs, resets IDS when the Get @ values option is executed. 43801- Spreadsheet to Query not updating correctly. When executed in Capsule, Query will process the first row of data as a header. 43817- Data Entry, Update and Retrieval forms displayed incorrect date resolution. 43828- Reference Capsule that looses it's path to the Master Capsule, resets IDS when the Run button is executed. 43833- Data Entry, retrieval form not displaying the first column of data. 43835- Return a collapsed window to the foreground when the minimized button is selected. 43948- Function keys do not work on the Windows95 System desktop. 44086- When WT_TABLES and WT_COLUMNS SQLNAME do not match, all Data Access tools display the following error message: Table or Column name could not be found in the WTDD. Problem that are fixed by "jw8bo" fix level: 40167- @ICON function is now supported in the Reporter tool. 41262- PC.WK1 icon cannot connect to any transformer. This is how the tool is designed to work. Work around is to place a Spreadsheet between the PC.WK1 icon and transformer. This will be documented in a read.me. 41292- Scroll bar does not appear on a Reporter when the 'Hide Label Only' function is used. 41377- In the Browser tool, the category window does not display scroll bar. 42779- Copying and renaming an existing desktop, a -3505 error will appear when a user tries to open the 'Data Access Controls' on the copied desktop. This problem only occurs on a Windows desktop. 42789- Capsule receives an error after removing a disk from drive a:. This problem only occurs on a Windows desktop. 42805- Printer host, 3 files are missing from the installation that are required for printing reporters. 43109- Text report from IDS, set to RTF and landscape, sends 8.5X11 which MS Word receives as 8.5X11 paper as portrait. 43124- Spreadsheet, PF4 key for option does not change cursor to clock display. 43156- Copying data from a Select transformer to a Layout results in a reset of IDS. 43230- Optioning a cell in an IDS tool appears on the screen significantly slower than in IDS 1.0.1. 43242- BASIC tool returning incorrect results. Extra characters are being placed randomly in the displayed data. 43258- The cursor on a Windows desktop is not working correctly. When selecting in Text document, the cursor is placed one character to the left. Also when selecting on the scroll bar of any tool, a user has to place the cursor at the very right edge in order to select it. Cursor seems to be off centered. 43299- Undersized option windows in Forms Design, Query and Reporter tools. 43308- Print Server, and Printer Host will not coexist on the same OS/2 system together without crashing on start up. 43587- When set preferences has a comma defined as the thousandths separator, the Function transformer will cause a hang of IDS when executed. 43590- Continued copying of results from the Find Icon listing to a Text document, will result in an IDS reset. 43596- Layout percent (%) symbol displays incorrectly in any transformer. 43629- Data Entry not displaying data with decimal placement of three (10,3) correctly. The results are displayed rounded, when no rounding should occur. 43630- No year 2000 selection capability in Capsule Service Alias option. 43638- Pivot transformer cannot handle more than 100 columns. Problems that are fixed by the "jo86u" fix level: 40099- When opening a computed options window in a Query tool, the cursor focus is not on the label text field. 41176- If you attempt to add a database gateway and specify 0 for "Maximum Number of Session", you receive the error message "Illegal maximum sessions. The maximum number you can specify is 150." 41449- Set Disk Quota transformer resets IDS when you do not copy input data in to the transformer. 41677- In the Query expert functions, under the box for the General Qualifyer is another box for Query Strategy. This box is obsolete and needs to be removed. 41745- Scroll bars in the browser tool do not work. 41756- In the Reporter tool, the window vertical length is to short to display window contents. 42001- No thumb-tack in vertical scrollbar of Capsule Server window. 42212- Text spell checker resets IDS after selecting the English UK dictionary. 42353- Show Log button in SA/Capsule Service tool displays incorrect error message. 42752- Iterrating Capsule set for 28 iterrations, resets IDS. 42773- A Reporter tool sending data to a Spreadsheet with Bold and Italics are displayed in the Spreadsheet with overstrikes. 42775- A Pivot transformer with 15,775 rows and 11 columns resets IDS. 42784- WK1 files, created from IDS Spreadsheet using conversion services, contain corrupted DBCS characters. 42790- Data Entry with choice fields generate incorrect SQL. 42798- Data Format transformer, in the controls the 'Character string append parameter has a value defined, but that value is not displayed in final results. 42811- Data Entry, @FIELD function fails to update when blanks are present in data row. 42833- IDS resets when trying to open a 1.3m Text document. 42847- The NONE date separator does not work with CONCAT formula in Spreadsheet. 42874- Reporter tool resets IDS when in the computed options window, a user selects 'Some in the Headings to Exclude Box', then selects 'None in the Headings to Exclude Box'. 42888- Capsule error causes a GPF on Capsule Server EE. 42899- FSCNSL backup choice is misspelled. Displays BACUPLISTING when it should be BACKUPLISTING. 42903- In the Capsule Server, the run time alias rescheduled jobs incorrectly due to the New Year. 42904- Spreadsheet to Query fails to insert rows when titles/headers are present in the Spreadsheet. 42924- Closing a Query before it is done retrieving data, resets IDS. 42937- No data being passed to the Function transformer, resets IDS. 42943- Copying a row of data from one Spreadsheet to another Spreadsheet, resets IDS. 42985- Date Format transformer is not setting date from MDY to Year. 43016- In the SA Tool, OS/400 needs to be deleted from the OS/2 Gateway setup screen. 43106- Text header with @page function does not work correctly when a value is defined in @P in the 'Controls window' of a Capsule. 43113- Layout is transferring extra blank heading rows. 43114- Spreadsheet, deleting 2 rows, one has data the other blank, resets IDS. 43122- Disk Statistic log icon connected to an inner Capsule, resets IDS. 43125- An undefined Layout connected to a Text icon, resets IDS. An undefined Layout, is a Layout tool that has data, but the Quick Report has not been implemented. 43131- Iterate Until Capsule fails with message: Incorrect number of rows in controls. 43132- A Query that is setting the Controls for an embedded Iterrating Capsule, is adding an extra row of data. 43157- Memory leaks were found in the FontMgr. 43158- Memory leaks were found in Attribute Manager. 43159- Memory leaks were found in variable.c for IDS workstation. 43182- Memory leaks were found in xtitcp for IDS workstation. 43256- Spreadsheets with regions creates a corrupted WK1 file. Users are unable to load the WK1 files into 1-2-3 or Excel. 43322- Computed columns with percentage (%) displays data incorrectly. Problems that are fixed by the "jo7b6" fix level: 42310- Reporter tool SQL fails because there is no space between the comma and the order by values. This problem is most likely due to the DB2 preference for Spain which allows the use of comma as decimal separator. 42236- Printing to P-Host printer from both OS/2 and Windows desktops does not carry over font and bold attributes. 42322- Joins defined by the Query tool are being dropped when a read of the DBA category is executed. 42355- In the Mail Service setup window, the following string appears in English even though a user is accessing under another language: "Set configuration will end Mail Service". 42377- Sorting dates incorrectly using the SA Tool, in the ODAS console History window. 42378- Unable to scroll all the way to the bottom in the SA Tool, ODAS console History window. 42382- In the SA Tool, the Sort control window should have a cancel button so users can make changes to the sort settings they have defined. 42449- Using 8 point system font results in a display problem in the SA Tool. For example, desktop preferences is set with Helvetica 8 font, open Asset Management in the SA Tool. The resources will be widely spaced. 42481- Mail from IDS does not get delivered to cc:mail Post Office. 42498- Virtual keyboard receives error: Virtual keyboard is disabled. This is seen when a user is at the logon screen, go to the Special (*) button and select Show Keyboard. 42513- Capture SQL feature in DBA tool does not translate to French. 42531- Remove disable/enable security function from ODAS console screen. Password checking is done when opening the console. 42570- DBA tool not using WTDD Owner as specified in it's Option window. 42577- Data Entry tool accessing Oracle database, not using 4 digit years. 42632- Spreadsheet->.dif conversion uses the wrong country desktop. For example, a user accessing an English desktop will receive a space and comma for the thousands and decimal separator. This is a default for the French desktop. 42651- DB2 MVS from a native host services gateway is incorrectly handling timestamp date. 42690- When down loading data from a Spreadsheet to a Query, a message is generated: "0 rows updated and 0 rows inserted". 42699- A text document with footer and page numbers at the bottom of the page will not print the page numbers. 42716- Data Entry not using the WTTDOWNER name defined in it's option sheet. 42717- Receiving a trap error when trying to access DB2/2J. This is a problem with non-English DB2 for OS/2. 42723- A reset of IDS occurs when retrieving data in a Data Entry tool. 42732- Converting a WK1 file includes the Print Range Record. The fix will be to not include this information. 42739- In a Capsule, have Control Database Connections set to Reuse, Retry=2. When the option Run and Log off desktop is used, a reset occurs of IDS. 42786- Unable to use the virtual keyboard, error message seen, 'Virtual keyboard cannot be changed. Bitmap not available'.