============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R3M0 Cumulative Service Pack Level ------------- SI18651 ------------- (c) Copyright IBM Corporation 2004. All rights reserved. ======================================================================== IMPORTANT NOTE: Service pack SI18651 replaces SI18398. After SI18398 was released on June 22nd, 2005, a problem with Management Central was discovered. When rebuilding the service pack, a decision was made to also include two other iSeries Navigator fixes. Here are the fixes in this replacement service pack: APAR SE20674: CA400EXP-COMM ISERIES NAV CRASHES WHEN SCROLLING DOWN TO VIEW When opening the joblog of a job shown in the monitor, particularly if the joblog required scrolling down to see the whole joblog would receive msg CWBUNNAV.EXE and then program not responding. Clicking "End now" ended the Joblog view, the monitor window, and the iSeries Navigator window. APAR SE20678: CA400EXP-OPNAV MGTC CONNECTION DELAY OR FAILURE Management Central connection fails from iSeries Navigator after installing iSeries Service Pack SI18398. The RMI connection for the Java server is creating a base Java socket with a short timeout period which leads to the unpredictable behavior. This will be changed to use the appropriate timeout value. APAR SE20685: CA400EXP-CUSTCONTROLS-INCORROUT CONTEXT MENU HANDLERS After installing SI17742 it is possible to use V5R2 specific plugins with iSeries Navigator. However, one of the object types is not handled correctly. My Connections -> (a system) -> Basic Operations -> Printers -> (A printer) Right click on one of the printer output items -> Esend Options -> Send Attached The plugin would not necessarily be Esend, it could be any other plugin that is installed under a Printer in V5R3. When the GetPublicList API is called by the plugin, a fault is caused in iSeries Navigator and the process ends. If you use iSeries Navigator or Management Central, you should install SI18651 (automatically will include the updated corequisite PTF SI18632) to replace SI18398. SI18651 contains all fixes in SI18398 plus the three additional fixes mentioned above. ======================================================================== Co-requisite PTF SI18632 is automatically included with any shipment or web download of SI18651. SI18632 exists only for packaging reasons. All service pack level references will be to SI18651. SI18651 can be installed on any PC/server that is at V5R3 service level SI10817 or newer. See iSeries Access for Windows Properties in the IBM iSeries Access for Windows folder to determine current service level. NOTICE: ------- Application of this PTF may disable or render ineffective programs that use system memory addresses not generated by the IBM translator, including programs that circumvent control technology designed to limit interactive capacity to purchased levels. This PTF may be a prerequisite for future PTFs. By applying this PTF you authorize and agree to the foregoing. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN iSeries SYSTEM 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE 2.0 RECOMMENDATIONS/RESTRICTIONS 2.1 iSeries SERVER FIXES 2.2 APPLICATION DEVELOPMENT FUNCTION WITHIN iSeries NAVIGATOR 2.3 UNIVERSAL CONNECTION WIZARD WITHIN iSeries NAVIGATOR 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI18651 (June 2005) 4.0 INSTALL/UNINSTALL CONSIDERATIONS 4.1 REMOVING THE SERVICE PACK 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? 4.3 SERVICE PACK CONTROL 5.0 DATA TRANSFER CONSIDERATIONS 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 --------------------------------------------------------------------- 1.0 INSTALLATION INSTRUCTIONS ------------------------------ 1.1 INSTALLING FROM AN iSeries SYSTEM -------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack through the iSeries PTF ordering process either as an individual PTF order or as part of an OS/400 PTF cumulative package. Once this service pack has been applied to an iSeries system with the LODPTF and APYPTF iSeries commands, it can be installed on individual PC's with the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Check Service Level, controlled by the iSeries Access for Windows Properties Service tab, will detect that the Service source directory has been updated, and will present the user with the option to install the service pack at startup time as well. The APYPTF will update the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) on the iSeries. Any client that installs iSeries Access for Windows (or selected components) from this image will automatically receive this service pack level (no extra steps or reboots). In this scenario, the service pack cannot be uninstalled on the client PC because it is merged in with the base release. Running setupsp.bat from the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) will launch the service pack install wizard. View setupsp.bat via Notepad or Wordpad to see instructions on how to invoke setupsp.bat to record or run a silent service pack install. RMVPTF will restore your iSeries install image to the prior service level (or the base release if there was no prior service pack applied). 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE --------------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack as a set of install image files via a download from IBM's FTP site. Install the service pack by running the "SETUP.EXE" program from your PC. This program is part of the install image files shipped with a service pack. If you change the iSeries Access for Windows Properties Service tab Source Directory to the directory containing these install image files, you can also use the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Before running this program, copy the service pack install image files to a local drive on your PC or to any accessible network drive. Once the install setup program has completed, you can then remove the install image files from that drive. 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE ------------------------------------------------------------------------------------- The following method could be used if you downloaded the service pack image from the iSeries Access for Windows web page location: http://www-1.ibm.com/servers/eserver/iseries/clientaccess/casp.htm The iSeries Access for Windows service pack PTFs are combined with the original iSeries Access for Windows installation image in QIBM\ProdData\Access\Windows\Install\Image NOTE: this directory is a symbolic link to QIBM\ProdData\CA400\Express\Install\Image There is one physical directory - either of these paths will access the directory. This means that a user can install (or upgrade) iSeries Access for Windows from this combined image directory and get the latest applied service level automatically in one integrated step - since the original installation image files have been replaced by updated versions via the service pack PTF. Selectively installing components from this combined image directory will also automatically get the latest applied service level for that component. If you tailored the iSeries Access for Windows install image to another directory (for instance, on another server), using the Create Tailored Installation Image (cwbinimg.bat) tool, you can use the PTFFORM.EXE download in the FTP directory to duplicate the function of applying the iSeries PTF by following these steps: 1. Download PTFFORM.EXE (from the tailored/ FTP directory) to a directory on your PC or server. 2. Run PTFFORM.EXE to automatically expand the service pack image files to a temporary directory. 3. You will then be prompted via a wizard panel to select the iSeries Access for Windows install image directory to update to the new service level. 4. The components that are contained in the target install image will be automatically updated to the new service level from the files in the temporary directory, and then the temporary directory will be removed. 5. After completion, you can delete the downloaded PTFFORM.exe file, as it is no longer needed. Now you have combined this service pack level with the iSeries Access for Windows installation image, so that users can install iSeries Access for Windows plus this service pack in one integrated step. Note that this procedure also works if the installation image has already been combined with a prior service pack level. This procedure will replace the prior service level in the combined image with this new level. Alternatively, if you have a full copy of the original iSeries Access for Windows install image in a directory, you can combine PTFFORM.EXE with this full image, using the same 5-step procedure detailed above. Then you can run Create Tailored Installation Image (cwbinimg.bat) from this full image directory, to create tailored image directories that will automatically have the service pack merged in. 2.0 RECOMMENDATIONS/RESTRICTIONS --------------------------------- 2.1 iSeries SERVER FIXES -------------------------- In addition to installing the iSeries Access for Windows Service Pack, all servers should stay current on the latest Cumulative PTF Package, HIPER Group PTF, and Database Group PTF. Refer to IBM eServer iSeries Technical Support: Recommended fixes at http://www-912.ibm.com/s_dir/slkbase.nsf/recommendedfixes 2.2 Application Development function within iSeries Navigator --------------------------------------------------------------- The Application Development folder within iSeries Navigator is being added back in V5R3 when the iSeries Navigator Network component is installed. All help and panels associated with Application Development functions will appear in English language only. To see the Application Development folder within the iSeries Navigator hierarchy, perform either of the following: -- Selectively Install (or initially install) the Network component of iSeries Navigator from an installation image containing V5R3 service pack SI13587 or newer. -- If the Network component is already installed on the PC, install service pack SI13587 or newer to receive the Application Development folder in the hierarchy. Application Administration can be used to restrict the display of the Application Development folder to certain users or groups of users. If secondary languages are installed on the PC, the Application Development English help and panels will be copied to each installed language directory. If a subsequent secondary language is installed, install service pack SI13587 or newer to copy the Application Development English help and panels into the new language directory. 2.3 Universal Connection Wizard within iSeries Navigator ---------------------------------------------------------- Running the Universal Connection Wizard to a V5R3M0 server that has not had PTF SI15166 for 5722SS1 installed could produce non-working universal connections in some scenarios. 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 ------------------------------------------ PTF 5722XE1 V5R3M0 SI16716 contains Java Runtime Environment (JRE) 1.4.2 which will replace version 1.4.1, which was on the original iSeries Access for Windows V5R3M0 media. The following APARs are fixed in JRE 1.4.2: APAR SE17968: CA400EXP-OPNAV USER-DEFINED CHARACTERS HALT STARTUP When a user-defined character(GAIJI) is created on the Windows client, iSeries Navigator does not start. The window screen appears a moment, but it ends immediately. This problem occurs on Windows XP and doesn't occur on Windows 2000. This problem disappears if we delete the GAIJI file named EUDC.EUF and EUDC.TTE from the C:\Windows\Fonts directory. A problem was found in the version of the Java Runtime Environment (JRE 1.4.1) that is shipped with iSeries Navigator. An update of the JRE to 1.4.2 is being provided to solve this problem. CIRCUMVENTION: Remove private characters to continue using iSeries Navigator without this fix. APAR SE18028: CA400EXP-OPNAV-WAIT ISERIES NAVIGATOR HANGS WITH IPV6 When Microsoft Extended TCP/IP Version 6 (IPV6) protocol is configured on the PC, iSeries Navigator Basic Operations, Printer Output never displays, and the user gets a message that iSeries Navigator is no longer responding. A problem was found in the version 1.4.1 of the Java Runtime Environment (JRE) that is shipped with iSeries Navigator. An update of the JRE to version 1.4.2 is required to solve this problem. CIRCUMVENTION: Remove Microsoft Extended TCP/IP Version 6 (IPV6) protocol by running the following from a PC Command Prompt: ipv6 uninstall If SI16716 is applied to the iSeries, and a service pack install is run from that iSeries image, the service pack install will upgrade the JRE level, if needed. Subsequent service packs will not reinstall the JRE if the latest level already exists on the PC. A new install, reinstall, or upgrade from an install image with SI16716 applied, will install the new JRE 1.4.2. For best results with reinstalls, apply PTF 5722XE1 V5R3M0 SI17496 (APAR SE19431) so that you don't have any obsolete files left over after the reinstall. A JRE 1.4.2 install package will also be provided on the IBM FTP site in a subdirectory off of the service pack FTP directory, for those users that prefer to get their service packs from the IBM FTP site. The following APAR addresses a side-effect of JRE 1.4.2 which will be fixed in the next release of iSeries Access for Windows: APAR SE19540: CA400EXP-OPNAV-INCORROUT JRE 1.4.2 INSTALL DIRECTORY When iSeries Navigator (with Java Runtime Environment (JRE) 1.4.2) is installed into a PC directory with a parenthesis '(' or ')' in the directory name, unpredictable results occur with Java operations. In particular, this is a problem with the default installation directory name on 64-bit Windows servers: C:\Program Files (x86)\IBM\Client Access This will be fixed in the iSeries Access for Windows release following V5R3M0. CIRCUMVENTION: Install into a PC directory that does not contain a parenthesis character '(' or ')'. If the PC already has iSeries Access for Windows installed into such a directory, uninstall iSeries Access for Windows, and install it again into a PC directory with no parenthesis character, prior to using iSeries Navigator with Java Runtime Environment 1.4.2. 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS -------------------------------------------------------- This a list of APAR fixes included in this service pack. Each service pack is cumulative; the current service pack includes all the fixes from the prior service pack levels. The APAR abstracts are listed by installable component within a service pack level. --------------------------------- Service Pack Level = SI18651 Build date = June 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE18981: CA400EXP-PC5250-INCORROUT INCOMPATIBILITY WITH PCOMM COMBO iSeries Access for Windows and PCOMM 5.6 combo compatibility issues: When attempting to use iSeries Navigator, connections, right click on system name, display emulator, the following error is issued: "Session profile from newer version of Personal Communication, The profile you've choosen is from a later release of personal communications. To use this profile you should upgrade your copy of Personal Communications". Same error is also issued when using Start, programs, iSeries Access for Windows, Emulator, Start or configure session and attempt to start the same above .ws (which is automatically created by iSeries Navigator if it doesn't exist). The VERSION= number in the *.ws files will be set to match the PComm version installed. CIRCUMVENTION: Change the Version= in the *.ws file to match your installed PComm version. APAR SE19493: CA400EXP-INCORROUT CWBDB APIs not using extended formats The customer's application uses the cwbDB APIs. If a general server warning (return code 6407) occurs when cwbDB_StartServer is called, the cwbDB APIs fail to set the "use extended formats" in the initial server attributes. This results in errors or incorrect behavior when executing statements that require the extended formats. Errors could include incorrect handling of LOB data, incorrect handling of the ROWID data type, and incorrect handling of any other type of data that requires the extended formats. CIRCUMVENTION: Examine the host server job (QZDASOINIT) joblog for warnings and errors that occur when your connection is opened. Take action to ensure the warnings or errors are resolved and no longer occur. APAR SE19733: CA400EXP-APIS Some cwbx (ActiveX) API names changed case In V5R3, some iSeries Access for Windows ActiveX symbol (property, method, and parameter) names changed case. For example, instead of program.LibraryName (as in the V5R2 client), cwbx.dll now exports program.libraryName. This causes problems when using case-sensitive programming languages. This problem occurred because of a side-effect of the Microsoft MIDL compiler. This PTF fixes the reported problem by working around the side-effect. However, this fix may cause applications written to work specifically with V5R3 iSeries Access for Windows to fail if they use the symbols whose names have been restored to their previous case. Such applications will need to be changed to use the updated case for these symbols. Once the fixed names are used, the application should work with both V5R3 iSeries Access for Windows and with earlier supported versions. The symbols whose names have changed are as follows: Name of symbol: - in V5R2 : Type - in V5R3, before this PTF : type - in V5R3, with this PTF : Type Name of symbol: - in V5R2 : pcFile - in V5R3, before this PTF : PCFile - in V5R3, with this PTF : pcFile Name of symbol: - in V5R2 : fileDescriptionFile - in V5R3, before this PTF : FileDescriptionFile - in V5R3, with this PTF : fileDescriptionFile Name of symbol: - in V5R2 : LibraryName - in V5R3, before this PTF : libraryName - in V5R3, with this PTF : LibraryName APAR SE19809: CA400EXP-INSTALL-INCORROUT SELECTIVE FROM PREVIOUS SP LEVEL If a user at a V5R3M0 iSeries Access for Windows service pack level of SI15176 or higher runs Selective Setup to install an additional component from an installation image at an earlier service pack level (but still higher than SI13587), two problems exist. -- The user is not reminded by a message box or Check Service Level to install the service pack again to pick up changes for the new component. -- The overall service pack level (as seen on iSeries Access for Windows Properties) will be changed to match the old service level of the new component. This will be fixed in the next service pack after SI17742. Any selective installs from an installation image with a service level newer than SI17742 will work properly. CIRCUMVENTION: Selectively install additional components from an installation image at the same service level as what is currently installed on the PC. Or, selectively install from the initial V5R3M0 media (service level SI10817). APAR SE19880: CA400EXP-ODBC-INCORROUT - MTS FAILURE IN ODBC/OLE DB ON XA_START On newer Windows server boxes (like Windows 2003 server), MTS (Microsoft Transaction Server) may fail with iSeries Access for Windows during the xa_start operation. MTS locates the iSeries Access XA dll by looking at a special registry entry. Microsoft added a registry key for any XA DLLs that will be used with their Distributed Transaction Coordinator. This change is documented in their knowledge base article 817066. (http://support.microsoft.com/default.aspx?scid=kb;EN-US;817066) If either the ODBC or OLE DB iSeries Access for Windows components are installed on the PC, the service pack install will automatically add the necessary registry keyvalue for the XA DLL cwbcore.dll. Also, any install, upgrade, reinstall, or selective install from an installation image containing this service pack level, will automatically add the necessary registry keyvalue. Note: the keyvalue will only be added if the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL key already exists. CIRCUMVENTION: Open regedit by going to the Start menu, selecting the Run... option, typing in regedit, and clicking OK. If the following registry key does not exist, create it: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL Add a new string under this key with the corresponding iSeries Access XA dll name. This example is for V5R3M0: String Value: cwbcore.dll Value data: C:\WINDOWS\system32\cwbcore.dll APAR SE20136: CA400EXP-DTRANSFER-INCORROUT UTF8 PADDING TOO MUCH Converting to and from UTF8 might cause padding to be written past the end of the target buffer. The UTF8 converters will be fixed. APAR SE20196: CA400EXP-SERVICE-INCORROUT ADD REMOVE SERVICE PACK ICON The iSeries Access for Windows service pack entry in the 'Add or Remove Programs' Control Panel applet sometimes has an incorrect or random icon associated with it on Windows 2000/XP. The V5R3 service pack install program (after SI17742) will add the proper DisplayIcon keyvalue for the service pack uninstall entry in the 'Add or Remove Programs' applet. 'Add or Remove Programs' will now use the same icon as the main iSeries Access for Windows uninstall program instead of the icon determined by a Windows algorithm. This will only be fixed in V5R3 and beyond, and is not an issue for Windows 9x, or NT, since only Windows 2000 and beyond uses icons in the 'Add or Remove Programs' applet. CIRCUMVENTION: Using regedit, can add the following String Value to the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\ CurrentVersion\Uninstall\ClientAccessExpressSP Name: DisplayIcon Data: "C:\Program Files\IBM\Client Access\caexpres.ico" Note: If iSeries Access for Windows was installed to a different path on the PC, use that path instead. APAR SE20324: CA400EXP - Enhance XDA header file with 64-bit BLOB support A SQL0302 message is getting returned when using BLOBs over the AMD64 supported XDA Windows client. The XDA header file has been enhanced to support BLOBs over the AMD64 supported XDA Windows client. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE19783: CA400EXP-INRMTCMD IRC shutdown vulnerability Certain inputs to Incoming Remote Command (the iSeries Access for Windows Remote Command service) can cause a fault, stopping the service. iSeries NAVIGATOR ----------------- APAR SE19153: CA400EXP-OPNAV USER IS NOT ALLOWED TO ADD CONNECTIONS TO ENVIRONMENT User is unable to add connections in iSeries Navigator after scanning the Administration System. This is because of the settings defined in the 'Application Administration (Central Settings) Advanced' dialog, under the 'Environments' page. When the 'Allow user to add connections to environment' option is not selected, it means no connections can be added to the environments defined in iSeries Navigator. However, the problem is that, when there is no environment defined in the 'Environments' page, the 'Allow user to add connections to environment' option is disabled and user can not select it. CIRCUMVENTION: To enable the 'Allow user to add connections to environment' check box when there is no environment defined: 1. From the 'Application Administration (Central settings) Advanced' dialog, select the 'Environments' page. 2. Click on 'Add Environment' and create a temporary environment, the 'Allow user to add connections to environment' option will be enabled. 3. Change the state of the check box. 4. Delete the temporary environment, select the environment previously created and click on 'Remove'. APAR SE19538: CA400EXP-OPNAV-NETWORK DHCP Deletes config file After opening DHCP configuration with iSeries Navigator v5r3 client, user tries to write back changes, for example, adding hosts, subnets, etc., but it fails with a "Unable to save dhcpsd.cfg" message. After this, dhcpsd.cfg file is empty (0 KB). The code will be enhanced to accept latin characters and, in case it finds unreadable characters, it will replace them with a '?' and the file will be saved in all cases. CIRCUMVENTION: Remove or replace the latin characters in dhcpsd.cfg file with english characters (a, u, etc). APAR SE19550: CA400EXP-OPNAV-NETWORK-INCORROUT Rules editor fix for NLS The Packet rules editor does not work when certain NLS characters are used (e.g. Japanese, Turkish). APAR SE19732: CA400EXP-OPNAV-DBASE-MSGSQL0204 CALLING EXTERNAL PROGRAM The SQL CALL statement calls SQL stored procedures, functions, as well as external programs not encapsulated with an SQL procedure or function. Run SQL Scripts signals MSGSQL0204 for CALL statements that specify such an external program, instead of performing the call. Run SQL Scripts will execute the CALL statement if a matching SQL procedure or function is not found. CIRCUMVENTION: Create a stored procedure or function for the external program with the CREATE PROCEDURE SQL statement. APAR SE19801: CA400EXP-OPNAV-OUTPUT DATA NOT VALID IN 'USERS:' ERROR iSeries Navigator allows you to work with another user's spooled files by going into Basic Operations > Printer Output, selecting View > Customize this View > Include from the menu bar (or pressing the F11 key) and then setting the Users field to a specific user profile, instead of using "Current User". This worked fine when running V5R2M0 iSeries Access for Windows, as long as the user profile had proper authority to work with other's spooled files, but fails after upgrading to V5R3M0 iSeries Access for Windows. When trying to do this after the upgrade, an error message is received that says "Data not valid in 'Users:'." in the title and says something like "QSECOFR is not a valid name" as the error message. APAR SE19802: CA400EXP-OPNAV-DBASE DISABLE SUSPEND FOR EXISTING REORGANIZE The 'Reorganize table' dialog enables the 'Suspend' button for an operation that is already running. Since the reorganize was not started by this instance of the dialog, the 'Suspend' button is not able to stop the operation. The button will have no effect when pressed. The 'Suspend' button will be disabled when the dialog is displaying the status of a reorganize operation already in progress. In a future release, the 'Suspend' button will be able to suspend the reorganize that is in progress. APAR SE19804: CA400EXP-OPNAV-DBASE TRAVERSE PREVIOUS EXPLAINABLE STATEMENTS List Explainable statements displays 1000 explainable statements at a time for performance reasons for large SQL Performance monitors. The user can traverse the list in a forward direction, but must use the Refresh button and repeat the process to display the previous set of statements. List Explainable Statements provides functionality to return to the set of 1000 statements that immediately precedes the statements that are currently displayed. APAR SE20003: CA400EXP-OPNAV-INCORROUT MONITOR LOSES TIME SLICE ON RESTART When a monitor fails and the it's restarted, values goes back to the default view of 5 minutes instead of the one was specified by the user. Monitor function has been changed to not lose the value specified by the user. CIRCUMVENTION: Closing and reopening monitor window should recover display time value on the graph grid. APAR SE20034: CA400EXP start checkbox in Director Server does not work When trying to use iSeries Navigator to configure the Director TCP server and the "Start when TCP/IP is started" checkbox is selected. The next time the properties are displayed the checkbox is unchecked. APAR SE20035: CA400EXP-OPNAV-JOBS Refresh loses customization When auto-refresh occurs, some of the "Customize this View" settings are lost. APAR SE20231: CA400EXP- Parity problems in Service Tools When using iSeries Navigator Service Tools with server versions newer than v5r3, trying to stop or start parity will result in error messages. The code will be corrected to support the newer servers. CIRCUMVENTION: Use OS/400 commands or menus to start and stop parity. APAR SE20248: CA400EXP- Unable to perform exclude using service tools gui When using iSeries Navigator Service Tools you are not able to perform an exclude on certain parity protected disk units. The code will be updated to be compatible with all types of servers' disks that support parity. CIRCUMVENTION: Use Dedicated Service Tools on OS/400 to perform this operation. APAR SE20276: CA400EXP Description is wrong for Sign On server Description is wrong for Sign On server APAR SE20396: CA400EXP-OPNAV-NETWORK-INCORROUT DNS NOT SAVING TIME UNITS DNS configuration fails when trying to change the Cache Time interval of a resource on a primary zone with iSeries Navigator in a different language than English. The code will be updated to be compatible with all languages to allow changing the units of time on the Cache Time interval. APAR SE20600: CA400EXP-OPNAV-INCORROUT EIM WIzard fails joining a domain with authentication problem An error occurs when attempting to join a domain using the EIM configuration wizard. The Specify User For Connection panel fails with an authentication failure when either the Verify Connection or Next buttons are clicked. The error is indicating that the authentication method is not supported and that the specified DN may not have a password. APAR SE20674: CA400EXP-COMM ISERIES NAV CRASHES WHEN SCROLLING DOWN TO VIEW When opening the joblog of a job shown in the monitor, particularly if the joblog required scrolling down to see the whole joblog would receive msg CWBUNNAV.EXE and then program not responding. Clicking "End now" ended the Joblog view, the monitor window, and the iSeries Navigator window. APAR SE20678: CA400EXP-OPNAV MGTC CONNECTION DELAY OR FAILURE Management Central connection fails from iSeries Navigator after installing iSeries Service Pack SI18398. The RMI connection for the Java server is creating a base Java socket with a short timeout period which leads to the unpredictable behavior. This will be changed to use the appropriate timeout value. APAR SE20685: CA400EXP-CUSTCONTROLS-INCORROUT CONTEXT MENU HANDLERS After installing SI17742 it is possible to use V5R2 specific plugins with iSeries Navigator. However, one of the object types is not handled correctly. My Connections -> (a system) -> Basic Operations -> Printers -> (A printer) Right click on one of the printer output items -> Esend Options -> Send Attached The plugin would not necessarily be Esend, it could be any other plugin that is installed under a Printer in V5R3. When the GetPublicList API is called by the plugin, a fault is caused in iSeries Navigator and the process ends. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE19537: CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD WITH NO CONVERSION When uploading PC data to an iSeries source physical file, message CWBTF0005 is issued if the PC locale determines a decimal separator that is different than a period. APAR SE19586: CA400EXP-DTRANSFER FILE IN USE MSG NOT DISPLAYED iSeries Data transfer to iSeries fails with no message when the file being uploaded is in use on the PC by another application. APAR SE19590: CA400EXP-DTRANSFER-UNPRED WARNING BEHAVIOR The Display Warnings During Data Transfer option is being set and checked at inconsistent times. This problem could result in warnings (CWBTF0020, among others) being issued to Data Transfer users even if the option to display warnings is disabled. APAR SE19604: CA400EXP-DTRANSFER-MSGCWBDB0014 VIA ACTIVEX INTERFACE useConnectedSystemObject was not being enabled correctly in the Data Transfer layer. This caused previously working applications coded to the cwbDB APIs to start failing with CWBDB0014. APAR SE19746: CA400EXP-DTRANSFER-MSGCWBDB0014 INITIAL LIBRARY LIST *NONE Initial library list *NONE in JOBD causes CWBDB0014 in DataTransfer when using the Browse function. Also, if a valid library list exists and the user enters a valid libraryname/filename pair and presses the Browse button, the libraryname/filename pair is ignored. APAR SE19774: CA400EXP-DTRANSFER INCORRECT DATA INSERTED INTO FILE iSeries Access for Windows Data Transfer is incorrectly setting the NULL indicator for open columns on the EXECUTE request. The data transfer program sends data to the iSeries, as seen in the CWBCOTRC, but since the null indicator is enabled for the column the data is ignored by DB. No error message is issued since DB has no way of knowing anything is wrong with the request. APAR SE19871: CA400EXP-DTRANSFER CRFF not treated as EOL With iSeries Access for Windows V5R1 original media level, user data could contain both 0x0D0A and 0x0D0C as EOL markers and they would be treated as such. When the first service pack for V5R1 was installed, 0x0D0C was no longer accepted as an EOL marker and was instead treated as data and sent to the host. The change that was made to not accept EOL markers other than 0x0D0A was deemed correct, and matched the industry standard. Unfortunately it broke some customer applications. A circumvention would be to modify existing data and replace the 0x0D0C with 0x0D0A. But given the amout of data that would need to be changed in this particular case, it was not feasible. Instead a flag has been added to the CWBTFR.INI file to allow 0x0D0C to also be allowed as an EOL marker. In order to activate this fix, the CWBTFR.INI file must be create/modified to include the following lines [Client Access Data Transfer] AlternateEOL=1 If the CWBTFR.INI file already exists on the PC, then only the second line needs to be added. The location of the CWBTFR.INI file, by default, would be in C:\WINNT on WinNT and Win2000, and in C:\WINDOWS on WinXP. This fix only applies to files of type "ASCII Text" as defined in the Data Transfer to iSeries GUI. APAR SE19882: CA400EXP-DTRANSFER WARNINGS NOT SUPRESSED IN EXCEL CWBTF0019 message not suppressed by iSeries Access for Windows Excel Add-In APAR SE19885: CA400EXP-DTRANSFER EXCEL SCAN DEFAULTS TO UNICODE Prior to V5R3 iSeries Access for Windows, when the Excel Add-in scanned the excel spreadsheet, the field types would default to CHAR for character data. With V5R3, they default to UNICODE (GRAPHIC). Some applications on the host can not handle GRAPHIC data, so the user has to manually change the field types on the PC prior to the transfer beginning. This can be rather labor intensive for spreadsheets with mulitple columns. A new .exe file is being supplied along with internal code changes. To activate this fix, invoke cwbtfdft.exe. This file will reside, by default, in C:\Program Files\ IBM\Client Access. Specify cwbtfdft /? for a list of options. This fix only applies to the Excel add-in. APAR SE19921: CA400EXP-DTRANSFER CWBTF0012 FOR PROTECTED WORKSHEET After upgrading iSeries Access for Windows to V5R3, data transfer download using an Excel add-in transfer request is failing with msgCWBTF0012: An unexpected error has been detected while processing transfer request. This error occurs when the Excel spreadsheet is protected. iSeries Access for Windows V5R2 would display an Excel message stating the sheet is protected. APAR SE20069: CA400EXP-DTRANSFER EXCEL NUMERIC TO CHAR User has an iSeries file containing a CHAR(10) field. The field contains a value of 1234567890. User downloads the data to an Excel (biff8) file. User opens the file with Excel and changes the cell format from General to Numeric. User then uploads the file to the iSeries specifying the "Allow numeric data in character columns to be converted to character data". The resulting data on this host is 1.23457E+0. The data is in scientific notation with the last 2 bytes truncated. This is working as designed, but the conversion makes the data unusable in this scenario. When Data Transfer asks Excel for the contents of a cell whose format is Number, Excel returns it as a double. For 1234567890, Excel would return 1234567890.0000. Data Transfer then calls a Windows API to format the double as a character, and the result is 1.23457E+009. Since the host field is only defined as CHAR(10), the last 2 bytes are truncated. Even if the host field was defined as CHAR(12), the scientific notation would still be used, based on the format specification we use. The format specification chosen was done so based on customer input. Unfortunately, it does not work for all customers. This PTF will allow the user to specify a format specification for formatting Excel Numbers (which Excel stores as Doubles) when used in conjunction with the "Allow numeric data in character columns to be converted to character data" option of iSeries Access for Windows Data Transfer to iSeries. Details on format specification strings can be found at http://msdn.microsoft.com/library/default.asp?url=/library/en-us /vccore98/HTML/_crt_format_specification_fields_.2d_.printf_and_wprintf_functions To activate the PTF, creation/modification of cwbtfr.ini is required. This file is located in c:\winnt on WinNT and Win2000 and c:\windows on WinXP. If the file does not exist on the PC, create the file and add the following lines: [Client Access Data Transfer] ExcelNumericFormatter=%.10G If it does exist, merge in the following line ExcelNumericFormatter=%.10G In this example, the field on the host is defined as a CHAR(10) and the numbers in Excel range up to 10 digits (i.e. 1234567890). Without this format specification, the numbers are converted to scientific notaion with possible rounding and truncation. With this format specification, the numbers are converted to the form 1234567890. The format specification must be in the form of %[flags] [width] [.precision] [{h | l | I64 | L}]type as defined at the URL supplied above. Maximum length is 20 characters. Only 1 format specification is allowed. If the Excel spreadsheet has a combination of different numerical value formats (i.e 123456, 1234.56, 123456.1234), an ideal format specification may not be possible. A tool, cwbtftstfmt.exe, is included and can be used to test different format specifications. All instances of Data Transfer and Excel must be ended and then restarted for modifications to cwbtfr.ini to take affect. APAR SE20247: CA400EXP-DTRANSFER-UNPRED SETTING DEFAULT USERID IN DATA In Data Transfer properties, on the connection tab, the user is allowed to set Specify a userid and then type in a userid to be used as the default userid for connections. It appears that if you have a userid longer than 9 characters only the first 9 characters are used as the default userid. APAR SE20257: CA400EXP-DTRANSFER DESCRIPTION NOT DISPLAYED FOR DETAILS When the Data Options button, followed by the Details button, is selected in Data Transfer From iSeries the description column is not always populated correctly. APAR SE20527: CA400EXP-DTRANSFER UNICODE DATA WITH X'1A' IN THE DATA Data Transfer will detect EOF when the second byte of a unicode word is x'1A'. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE19889: CA400EXP-ODBC-INCORROUT - END DISTRIBUTED TRANSACTION FAILURE When ending a distributed transaction through ODBC, a call to SQLSetConnectAttr is made for the SQL_ATTR_ENLIST_IN_DTC option. The parameter passed in on the call is a NULL transaction ID. The distributed transaction coordinator normally calls xa_end before asking for the unenlist to happen. However, in some cases it does not. The driver should do an xa_end before moving out of distributed transaction mode on that connection. The current behavior results in a "SQL0428 - SQL statement cannot be run" error being reported. APAR SE20073: CA400EXP-ODBC - ODBC REPORTING OF UTF8 FIELDS On V5R3 iSeries, there is a UTF-8 Unicode CCSID that can be applied to character data types. If someone creates a table with a CHAR(10) CCSID 1208, the ODBC driver currently does the following: - If the SQLColumns API is called, the string "CHAR() CCSID 1208" is returned for the data type string. - If the SQLGetTypeInfo API is called, "CHAR() CCSID 1208" is being reported as a valid data type for SQL_CHAR. Due to the way the driver is behaving, tools like SQL Server end up creating tables with UTF-8 fields. Since that is different behavior than in past ODBC drivers, a change is required. There are two changes being made to handle this problem: 1) The ODBC driver will not return additional rows through SQLGetTypeInfo for the UTF-8 fields. 2) The ODBC driver will now externalize a REPORTTYPES keyword. ReportDataTypes also can be used. This keyword affects how the catalog APIs (like SQLColumns, SQLProcedureColumns, ...) report data types. This option has the following values: 1 = Report all CHAR fields the same way regardless of the CCSID (Default) 2 = Report UTF-8 fields differently than other CHAR fields Note: CCSID 65535 is one exception for both cases. Character fields tagged with CCSID 65535 are reported differently depending on the setting of the "Convert binary data (CCSID 65535) to text" DSN option. APAR SE20125: CA400EXP-ODBC-INCORROUT getting SQL0302 when passing zero-length to Packed Decimal An ODBC application is getting an error message of: "SQL0302 - Conversion error on input host variable or parameter *N." This problem occurs when using a parameter marker and accessing a packed decimal field in a table. The problem is that the application binds a parameter as SQL_C_CHAR with a zero-length string. It was determined that the correct behavior on this would be for the driver to convert this to a packed decimal value of 0. CIRCUMVENTION: If the application calls the SQLBindParameter API with the StrLen_or_IndPtr set to 1 with a buffer containing "0" this problem would be avoided. APAR SE20243: ODBC - CALL TO SQLPROCEDURES THROWS 'ACCESS VIOLATION IN MOD 'Access Violation at address xxxxxxxx in module cwbodbc.dll' thrown from within ODBC application using SQLProcedures API. Whether the problem occurs or not , depends on the number of libraries in the user portion of the library list. CIRCUMVENTION: Reduce the number of libraries in the USER part of library list. APAR SE20344: CA400EXP-ODBC-PERFM - REVISE CHECKING FOR DOWN CONNECTIONS In V5R3 Service Pack SI17411, a change was introduced to allow the ODBC driver to better detect connections when the SQL_ATTR_CONNECTION_DEAD connection attribute was called. Due to performance problems in an ADO.NET environment with this fix, a change is needed. The SQL_ATTR_CONNECTION_DEAD behavior will be modified to work closer to how it worked in previous Windows ODBC drivers. The ODBC driver will still periodically do a more thorough check to verify if a connection is up or down, but that will mainly be for cases where a connection has been idle for some time. APAR SE20395: CA400EXP-ODBC-INCORROUT -SQL0332 on Length function Call There is problem with the way we are handling the escape syntax for the length function. As an example that demonstrates that problem, you can run the following statement: SELECT {fn LENGTH( CAST( GX'BB88' AS VARGRAPHIC( 10000 ) ) )} AS GLEN FROM QIWS.QCUSTCDT It seems we could convert the length function a bit better and still return the length of the actual data. Right now we convert this to: LENGTH(STRIP(CAST( GX'BB88' AS VARGRAPHIC( 10000 ) ),T,' ')) And that fails of course because the literal space value will be interpreted in the job ccsid and the string is a double byte string. If we just dropped that optional literal value, the strip function will default to using a space of the appropriate type (documented in the SQL reference under the TRIM function, STRIP just says it works the same as TRIM). So if we converted this to : LENGTH(STRIP(CAST( GX'BB88' AS VARGRAPHIC( 10000 ) ),T)) It will work. OLE DB PROVIDER --------------- APAR SE19872: CA400EXP-OLEDB CANNOT DERIVE PARAMETER INFORMATION The application creates a command that has no parameters, for example: select * from qiws.qcustcdt The application then calls cmd.Parameters.Refresh to derive the parameter information. The Refresh fails with: Run-time error '-2147217839 (80040e51)': Provider cannot derive parameter information and SetParameterInfo has not been called. APAR SE20376: CA400EXP-OLEDB SQL0518 WHEN EXECUTE HAPPENS IN MIDDLE OF When the same statement, which does not have parameters and is not a select statement, is run consecutively it fails with SQL0518 error trying to execute an unprepared SQL statement. CIRCUMVENTION: Prepare the statement before the execute. APAR SE20510: CA400EXP-OLEDB SQL0104 with updateable cursor When an updateable cursor builds a very long statement it is truncated and fails with an SQL0104, Invalid Token, host error. .NET DATA PROVIDER ------------------ APAR SE19683: CA400EXP iDB2DATA Recycled kerberos connection fails When a connection configured for kerberos is recycled, for example due to reaching the MaximumUseCount on a pooled connection, the provider incorrectly passes the Userid on the reconnect. As a result, the recycled connection does not use kerberos, but instead connects with a userid, and the application may receive a logon prompt asking for the password. APAR SE19924: CA400EXP IDB2DATA CMDBLDR FAILS W/ROWID, IDENTITY, AND VIEWS Programs using the native iSeries .NET managed provider (IBM.Data.DB2.iSeries) to update a data set using the command builder and data adapter will get an error if the table contains an identity column or rowid which specifies the GENERATED ALWAYS identifier. The update statement generated by the command builder will attempt to update the identity or rowid column which is normally a read-only column in this case, resulting in SQL0798. Another problem exists with the command builder. If the select statement does not include the schema name, then the command builder does not include the schema name when it builds commands. This can result in an SQL0204 if the select statement selects from a view whose based-on schema name is different from the view schema name. The command builder should always include the based-on schema name when it builds commands. APAR SE20479: CA400EXP-IDB2DATA Add security asserts and demands to .NET An application using the IBM.Data.DB2.iSeries .NET provider restricts permissions that are needed by the provider. When the provider performs a function that requires the permission, a SecurityException results. The .NET provider should Assert the permissions it needs to function. CIRCUMVENTION: Don't restrict permissions when using the .NET provider. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.8 and the equivalent of 5722JC1 SI17821 and SI18394. APAR SE19847: CA400EXP-2-UNPRED Mouse events blocked when PDML show help When using PDML and JavaHelp 2.0 all mouse events are being blocked when help is displayed. APAR SE20441: TOOLBOXJAVA-JT400-ACCESS-JDBC DESCRIPTOR INDEX INVALID If variable length field compression is used on one request and not on a subsequent request to the same result set, a descriptor index not valid exception may occur. If variable length field compression was used on a result set, the toolbox thought it was used on subsequent requests. A change was made to check the variable length field compression flag on subsequent requests. APAR SE20442: TOOLBOXJAVA-JT400-ACCESS-JDBC ALLOW ALIAS TABLES The toolbox does not allow for the retrieval of ALIAS table types by themselves on a call to DatabaseMetaData.getTables(). Support was added to allow the retrieval of ALIAS table types. Prior to the change, ALIASes were returned when the user asked for TABLES. ALIAS tables can be retrieved on a call to DatabaseMetaData.getTables() that request one of the following combinations for table type (due to database host server support): All types Aliases Tables and Aliases Views and Aliases Tables, Views, and Aliases Tables, System Tables, and Aliases Views, System Tables, and Aliases Tables, Views, System Tables and Aliases 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE19142: CA400EXP-DTRANSFER-INCORROUT PC5250 INITIATED DATA TRANSFER PC5250 initiated Data Transfer allows the user to save the transfer request to the default PC5250 Data Transfer request. At V5R3M0 iSeries Access the save appears to complete normally but launching Data Transfer from PC5250 tool bar brings up a blank transfer request instead of the saved request. APAR SE19423: CA400EXP-TERMEMUL-INCORROUT DUTCH MRI2923 STRPCCMD With iSeries Access for Windows Mri2923 (Dutch Netherlands), the STRPCCMD PAUSE(*YES) command fails with a message indicating a command, program, or batch file cannot be found with the name "Druk". The string 'Druk_op_een_toets_om_terug_te_gaan' (Press any key to return) must have underscores or the text will be misinterpreted as command input. This service pack PTF will fix the problem for the following NLV's in V5R3: -- 2923 (Dutch Netherlands) -- 2963 (Belgian Dutch Multinational) APAR SE19583: OSP-PAR ISERIES ACCESS FOR WINDOWS PC5250 MACROS WITH CERTAI PC5250 macros named with certain file names (long file name or something like .mac) will fail to run with a PCKBD410 error. This happens at V5R3 of iSeries Access for Windows. APAR SE19884: CA400EXP-TERMEMUL-INCORROUT EHLLAPI CONNECT PRESENTATION SPA Service pack 4 (SI17411 or SI17742) for the V5R3 iSeries Access for Windows product introduced a defect in the EHLLAPI connection presentation space function. At this service pack level, the connect presentation space (connect PS) function will return success regardless of whether it really worked or not. For example, attempting to connect to a session which is not started will result in a successful return code from the connect PS function but any subsequent function will fail because it is not really connected to an active session. APAR SE20385: CA400EXP-TERMEMUL PRINTER DEVICE ASSOCIATION SUPPORT Provide a way to associate a printer device on the iSeries server with a Pc5250 display device session, so that all output from the display session goes to a specified printer device. With this fix, the Workstation Profile (.ws file) can be edited to specify a printer device name on a V5R3 or beyond iSeries server. In iSeries Access for Windows releases after V5R3, a configuration panel interface will be provided to specify the printer device name. In the .ws file, add a "EnablePrinterAssociation" keyword in the "Telnet5250" section. Valid values for "EnablePrinterAssociation" are: "Y" which enables the feature "N" which disables the feature (Default) In addition, add the keyword "AssociatedPrinterDeviceName" in the "Telnet5250" section. Valid values for "AssociatedPrinterDeviceName" are: Any string that follows these rules: -- No imbedded blanks -- Cannot start with a number -- Contains letters A-Z, numbers 0-9, and symbols #, @. All other symbols are not valid. If the string fails validation, printer association will be disabled. Any string of more than 10 characters will be truncated to the 10 character maximum length. If the "EnablePrinterAssociation" keyword is specified, then "AssociatedPrinterDeviceName" keyword must also be specified. When the Pc5250 display session is started, the printer association will only work if the printer device name specified is present on the iSeries server. APAR SE20458: CA400EXP-INCORROUT DISABLE STRPCCMD COMMAND VIA WS KEYWORD iSeries Access for Windows PC5250 needs client-side control on commands issued via the STRPCO/STRPCCMD server commands. PC5250 will allow users to disable STRPCCMD through a new WS profile keyword, "Ignore_STRPCCMD". Users can edit a .ws file to add the following to the [5250] section of the .ws profile to enable/disable STRPCCMD. The keyword can have values 'Y' and 'N' with the default being 'N' to allow the STRPCCMD command. Users who want to block STRPCCMD will have to set the keyword to 'Y'. The keyword can be set as follows: [5250] Ignore_STRPCCMD=Y When the keyword is set to 'Y', PC5250 ignores the parameters associated with STRPCCMD and simply sends back to the server an Enter key to refresh the screen. CIRCUMVENTION: Control access to STRPCO and STRPCCMD commands via iSeries authority permissions. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI17742 Build date = March 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE18332: CA400EXP-2-UNPRED MEMORY LEAK IN CWBDATAQUEUETEXTBOX ACTIVE APAR SE18533: CA400EXP-OPNAV-INCORROUT NOT ALL COMPONENTS LISTED UNDER APAR SE18852: CA400EXP-SECURITY-MSGCWBSY1040 Cannot find Windows logon information APAR SE18899: CA400EXP-OPNAV-INCORROUT TIME MGMT UNAVAIL WITH SSL APAR SE19086: CA400EXP-OPNAV-INCORROUT ez prerequisites not passed APAR SE19141: CA400EXP-OPNAV-MSGCWBAD1003 ACCESS IS NOT RESTORED CORRECTLY OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE19438: CA400EXP-INRMTCMD-PERFM CWBRXD.EXE USES TOO MUCH CPU iSeries NAVIGATOR ----------------- APAR SE16931: CA400EXP-OPNAV-DBASE-LOOP LIST EXPLAINABLE STATEMENTS PERF APAR SE18365: CA400EXP-OPNAV-ONBACKUP MISSING WHERE PANEL ON PROPERTIES APAR SE18421: CA400EXP-CUSTCONTROLS-INCORROUT CONTEXT MENU HANDLERS APAR SE18471: CA400EXP-OPNAV-NETWORK DHCP incompatibility within versions APAR SE18661: CA400EXP-OPNAV-NETWORK UCW Rollback of IES changes in v5r1,v5r2,v5r3 APAR SE18790: CA400EXP-OPNAV-DBASE MSGSQL0444 INDEXES FAILS ON V5R2 SERVER APAR SE18804: CA400EXP-OPNAV-DBASE CHANGE COLUMN LENGTH DOES NOT WORK APAR SE18862: CA400EXP-OPNAV-NETWORK-INCORROUT IPv6 incompatibility APAR SE18977: CA400EXP-OPNAV-DBASE ALIAS DISPLAYED INCORRECTLY APAR SE19071: CA400EXP-OPNAV-INCORROUT IASP properties option not saved APAR SE19129: CA400EXP-OPNAV-DBASE GENERATE SQL DOES NOT APPEND TO PC FILE APAR SE19139: CA400EXP SNTP ok button not working inside Time Management APAR SE19140: CA400EXP-OPNAV-NETWORK-INCORROUT Poll interval not displayed APAR SE19149: CA400EXP-OPNAV-NETWORK UCW Remote Dial for Service Agent fails APAR SE19203: CA400EXP-OPNAV-NETWORK-INCORROUT DHCP denies valid address APAR SE19214: CA400EXP-OPNAV Add option to Run SQL Scripts window to allow deferring messages in the Run History pane Users of the Run SQL Scripts window in the iSeries Navigator database need the ability to defer messages from appearing in the output pane (the Run History) to improve the performance when executing large numbers of statements, and the ability to see messages immediately as statements are executed, so the user can know right away if a statement failed. The new option DEFER RUN HISTORY will be provided on the Options menu of the Run SQL Scripts window. It will be provided with English-only text, since translated text cannot be changed after a release has shipped. APAR SE19269: CA400EXP-OPNAV-DBASE-INCORROUT UPDATE STATISTICS APAR SE19369: CA400EXP-OPNAV-DBASE-INCORROUT SQL STATEMENT TRUNCATED APAR SE19420: CA400EXP DNS does not allow zone forwarders DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE18219: CA400EXP-DTRANSFER-INCORROUT RFROMPCB FAILS WITH /I SWITCH APAR SE18429: CA400EXP-DTRANSFER-MSGCWBTF0005 WHEN EXCEL FIELD CONTAINS $ APAR SE18555: CA400EXP-DTRANSFER-MSGCWBTF0009 DBCS DATA TRUNCATION APAR SE18657: CA400EXP-DTRANSFER-INCORROUT ASCII FILE PADDING ERROR APAR SE18994: CA400EXP-DTRANSFER-INCORROUT HTML DOWNLOAD INCOMPLETE APAR SE19191: CA400EXP-DTRANSFER-INCORROUT ZEROS UPLOADED INSTEAD OF MESSAGE APAR SE19249: CA400EXP-DTRANSFER-INCORROUT ADDIN SCANS CHAR FIELD AS DATE APAR SE19296: CA400EXP-DTRANSFER-INCORROUT COPY FROM DISPLAY TO EXCEL FAILS APAR SE19306: CA400EXP-DTRANSFER-INCORROUT WIZARD SETS TRANSLATION FROM ASCII APAR SE19307: CA400EXP-DTRANSFER-INCORROUT MISSING VALUE FOR HTML TEMPLATE APAR SE19416: CA400EXP-DTRANSFER-INCORROUT ISERIES LIBRARY BROWSE BEHAVIOR APAR SE19596: CA400EXP-DTRANSFER-INCORROUT UPLOAD OF ASCII FILE FAILS WITH CWBDB0052 and CWBTF0020 DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE18494: CA400EXP-ODBC-INCORROUT - Miscellaneous ODBC fixes APAR SE18606: CA400EXP-ODBC-INCORROUT - CONNECTION POOLING ISSUES APAR SE19073: CA400EXP-ODBC-MSGSQL0206 COLUMN SQL_DATE NOT IN SPECIFIED Lotus Approach is used with the iSeries Access for Windows ODBC driver to build and execute a query with a selection criteria specified on a date field. When the the SQL statement built by Approach is run it receives an error message, 'SQL0206-Column SQL_DATE not in specified tables.' The query built by Approach is invalid and this really is a defect in the Approach product. The same query used to work with the V4R5 version of the ODBC driver, though. Traces of the V4R5 client revealed that Approach never put any selection criteria on the SQL statement that was passed to the ODBC driver when using the V4R5 driver. The reason for the change in application behaviour appears to stem from the value they get from the ODBC driver when they query the driver's ability to provide conversions from one type to another. SQLGetInfo's SQL_CONVERT_TIMESTAMP option returns an incorrect value with the V4R5 driver. The newer driver is returning the correct value but that causes Approach to build an incorrect SQL statement that is overly complex: WHERE ({fn CONVERT("EBONY"."GLFILE"."GLPOSTP".GPD_ENTDAT,SQL_DATE)} = {fn CONVERT({d '2004-07-09'},SQL_DATE)}) This could have been as simple as: WHERE GPD_ENTDAT = '2004-07-09' In order to allow Lotus Approach to continue working with the latest versions of the iSeries Access ODBC driver, the ODBC driver was changed to optionally return the V4R5 values when using SQLGetInfo() with Infotype SQL_CONVERT_TIMESTAMP. To configure the ODBC driver to return this value, set the DEBUG keyword to 2048. Contact IBM Support if you need assistance setting this special flag. APAR SE19091: CA400EXP-ODBC SQLSETCONNECTATTR FAILED WITH CONNECTION POOL APAR SE19359: CA400EXP-ODBC-MSGSQL0104 USER() FUNCTION OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE18503: CA400EXP IDB2DATA INCORROUT .NET provider quotes names w/@#$ APAR SE18607: CA400EXP IDB2DATA InvalidOperationException after ExecuteScalar APAR SE18608: CA400EXP IDB2DATA Null Provider type fails on GetHashCode APAR SE18811: CA400EXP IDB2DATA MSGSQL0206 if CommandBuilder used on View APAR SE19150: CA400EXP IDB2DATA WAIT DELAY INITIALIZING NUMERIC VARIABLES APAR SE19262: CA400EXP IDB2DATA MSGIDB2COMMERROREXCEPTION - Add property to verify pooled connections on Open When iSeries server jobs get recycled (ENDPJ, ENDJOB, ENDSBS, or IPL), .NET connections receive a comm error the next time that connection is used: iDB2CommErrorException: A communication error occurred. When this happens, the normal recovery is for the application to close and then reopen the connection. In cases where ALL or MANY pooled connections are ended (for instance, during an IPL), the application could continue to get communication errors even after reopening the connection. New functionality is needed to give applications a better way to recover from this condition. This PTF gives applications a way to have the provider check pooled connections for validity before using them on a connection.Open request. To validity check pooled connections during Open, add the following to your ConnectionString: CheckConnectionOnOpen=true; This causes the provider to send a small flow to the host in order to see if the connection is still active. If the connection is no longer active, the provider reconnects to the host server before returning from the Open request. By default, the CheckConnectionOnOpen property is set to false, meaning pooled connections are not checked for validity during Open. APAR SE19266: CA400EXP IDB2DATA MSGPWS0006 Error reading CLOB and DBCLOB LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.7 (2/24/2005) and the equivalent of 5722JC1 SI17296 and SI17439. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE16441: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION PROBLEM AFTER APAR SE18210: CAEXP PC5250-BEHAVIOR OF IME IS INCORRECT WHEN CURSOR IS APAR SE18245: CA400EXP-PRINTEMUL-MSGPCSCM.EXE APPLICATION ERROR PCSCM.EXE APAR SE18385: OSP-MSGPCSERR100 PCSERR100 WITH PC5250 APAR SE18436: CA400EXP-TERMEMUL PCSBAT.EXE CAN'T RUN *.LNK FROM BCH FILE APAR SE18821: CA400EXP-TERMEMUL-INCORROUT NO SOUND ON PC AFTER UPGRADING APAR SE18841: CA400EXP-PRINTEMUL-INCORROUT GAIJI CHARACTER WRONG SIZE WITH APAR SE18842: CA400EXP-PRINTEMUL-INCORROUT DBCS DASH CHARACTER PRINTS APAR SE18848: CA400EXP-TERMEMUL HIGHER RESOLUTION DISPLAY SUPPORT PC5250 does not display its screen properly at high resolutions. PC5250 works best with lower resolutions like 1024x768. At higher resolutions, much of the emulator screen is blank and the text displayed is centered. PC5250 needs to use most of the available window space, and display the text as large as possible with good quality. A change from raster (bitmap) fonts to True Type Fonts will be made. True Type Fonts are scalable and display text well at higher resolutions. This new feature will be implemented only for English and West European languages (PC codepage 1252). No other languages will support these higher resolutions. New monospaced True Type Fonts containing all the characters from the current IBM3270 raster font will be installed in the PC5250 installation folder. -- Monotype Sans Duospace WT (mtsansdw.ttf) (for displaying text) -- IBM3270APL5 (pcommapl.ttf) (for displaying APL characters like box drawing, scrollbars, etc) IBM3270 will still be the default font. The new Monotype Sans Duospace WT font (mtsansdw.ttf) will need to be selected by the user via the Select Display Font dialog. Whenever the Monotype Sans Duospace WT font is selected, PC5250 will automatically select IBM3270APL5 (pcommapl.ttf) as the APL font. Note: Operator Information Area (OIA) fonts will not be changed. At higher resolutions, characters displayed in the OIA might appear smaller than the PC5250 window text. APAR SE19080: CA400EXP-PRINTEMUL-INCORROUT INCORRECT FONT SIZE WHEN ROTATI APAR SE19101: OSP-PAR PCSWS026 ERROR WHEN SAVING .WS PROFILES AFTER APAR SE19188: CA400EXP-TERMEMUL-INCORROUT COPY FAILS TO COPY NEW DATA TO PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE18498: CA400EXP-OPCON-INCORROUT autostart doesn't start PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI16496 Build date = December 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE17422: CA400EXP-OPNAV-INCORROUT FUNCTIONS UNAVAIL WITH SSL APAR SE17423: CA400EXP-ODBC-INCORROUT LARGE VARCHAR DOESNT SHOW DBCS DATA APAR SE17688: CA400EXP IDB2DATA INCORROUT LibList added in wrong order APAR SE17943: OSP-DB ODP NOT REUSED. APAR SE17955: CA400EXP - XDA Windows client enhancements APAR SE18001: CA400EXP-TERMEMUL-INCORROUT CWBLM0040 with multiple sessions APAR SE18197: CA400EXP-TERMEMUL-INCORROUT HMC connection timeouts APAR SE18389: CA400EXP IDB2DATA PWS0043 stored procedure with parameters OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE16054: CA400EXP-OPNAV-DBASE VE SHOW RELATED OPTION MISSING APAR SE16574: CA400EXP-OPNAV CAN'T REFLECT A COLUMN HEADING VALUE IN ADD N APAR SE16800: CA400EXP-OPNAV CWBUNNAV.EXE Error on browsing long directory APAR SE17023: CA400EXP-OPNAV-INCORROUT Server browse button in New Cluster wizard fails to refresh APAR SE17085: CA400EXP-OPNAV UNIVERSAL CONNECTION WIZARD RESOURCE ERROR APAR SE17092: QPWFSERVSO job hangs around after iSeries Navigator closes APAR SE17205: CA400EXP-OPNAV-INCORROUT- CPF9810 confusing message when Licensed Option 12 is not installed APAR SE17213: CA400EXP-OPNAV-DBASE-MSGSQL0109-MSGSQL0190 ALTERING COLUMNS APAR SE17322: CA400EXP-OPNAV-NETWORK-INCORROUT ISERIES NAVIGATOR TELNET APAR SE17396: CA400EXP-OPNAV-NETWORK-INCORROUT single quotes in RMTSYS APAR SE17398: CA400EXP-OPNAV-NETWORK-INCORROUT DNS SOA serial number APAR SE17405: CA400EXP-OPNAV-NETWORK-INCORROUT SOCKS Domain name server not saved APAR SE17503: CA400EXP-OPNAV Inav Parity option fails to mark all options in Availability when "CHECK ALL" box is checked APAR SE17521: CA400EXP-OPNAV-NETWORK-INCORROUT allow to configure zone TTL APAR SE17574: CA400EXP-OPNAV-MESSAGES SQL0107 when do Analyze Results on German SQL performance monitor APAR SE17654: CA400EXP-OPNAV-DBASE-INCORROUT IDENTITY COLUMN ORDER APAR SE17709: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DOUBLE $ORIGIN STRING APAR SE17769: CA400EXP-OPNAV-OUTPUT-MSG INVALID DATA INCLUDE CRITERIA APAR SE17793: CA400EXP-OPNAV INCORROUT Gui Graphics fails to show all dasd APAR SE17794: CA400EXP-OPNAV-NETWORK-INCORROUT CHILD ZONE CREATION APAR SE17854: CA400EXP-OPNAV Cannot change order of nodes in recovery domain of a CRG APAR SE17869: CA400EXP-OPNAV-NETWORK-INCORROUT Dbg Server not started APAR SE17880: CA400EXP-OPNAV-INCORROUT Standard Service Port set incorrectly for Java APAR SE17883: CA400EXP-OPNAV INCORROUT Images missing on Properties APAR SE17996: CA400EXP-OPNAV-DBASE INDEXES SUPPORT ON V5R2 APAR SE18006: CA400EXP-OPNAV-DBASE-INCORROUT TEMPORARY INDEXES APAR SE18049: CA400EXP-OPNAV-MSGCPF3342 DRAG AND DROP OF SPOOLED FILE APAR SE18070: CA400EXP-OPNAV-DBASE TABLE NAME LOST WHEN CREATING ALIAS APAR SE18109: CA400EXP-OPNAV-NETWORK UCW update to state list use APAR SE18110: CA400EXP-OPNAV-DBASE MULTIPLE INDEXES ADVISED PER TABLE APAR SE18216: CA400EXP-OPNAV-INCORROUT SSL Icon not displayed correctly. APAR SE18247: CA400EXP-OPNAV-NETWORK-INCORROUT iNav hangs, SMTP properties APAR SE18254: CA400EXP-OPNAV-INCORROUT Function Availability prompting incorrect name DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE16662: CA400EXP-DTRANSFER-INCORROUT EXCEL WITH MULTIPLE SHEETS FAILS APAR SE16753: CA400EXP-DTRANSFER-MSGCWBDB0014 WHEN DOING A DATA TRANSFER APAR SE17556: CA400EXP-DTRANSFER-MSGSQL5016 CONTAINING DOT IN FILE NAME APAR SE17875: CA400EXP-DTRANSFER-INCORROUT EXCEL EMPTY CELLS AS UNICODE DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE17733: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS APAR SE18215: CA400EXP-ODBC-UNPRED - VARIABLE LENGTH COMPRESSION ENHANCEMENT The driver's fetching of data from variable-length fields (VARCHAR, VARBINARY, VARGRAPHIC,... ) can be inefficient in some cases. An enhancement is being provided that will help with performance when using forward-only cursors. To take advantage of this enhancement, the application must be using the 'Block if fetch of 1 row' DSN option (or the BLOCKFETCH=1 keyword). That setting is enabled by default. Note, to get this enhancement to work a V5R3 iSeries server and some additional server PTFs are required. As the server PTFs become available they will be documented at: http://www-1.ibm.com/servers/eserver/iseries/access/servernotes.html APAR SE18251: CA400EXP-ODBC - IIS HANG DUE TO CLOSE CURSOR OLE DB PROVIDER --------------- APAR SE17223: CA400EXP-OLEDB-MSGCWBZZ5014 CWBZZ5014 WHEN USING IBMDA400 .NET DATA PROVIDER ------------------ APAR SE17385: CA400EXP IDB2DATA Incorrect result data on 2nd call to Execute APAR SE17432: CA400EXP IDB2DATA MSGSQL0519 after failed Execute APAR SE17639: CA400EXP IDB2DATA MSGSQL0518 Select statement parsed as a stored procedure APAR SE17960: CA400EXP IDB2DATA INCORROUT FAILURE W/RESTRICTED PERMISSIONS LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.6 (10/29/2004) and the equivalent of 5722JC1 SI16227. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE15390: CA400EXP-PRINTEMUL-INCORROUT PC5250 BESTFIT OPTION CANNOT BE APAR SE15842: CA400EXP-TERMEMUL-INCORROUT PC5250 CROSSHAIR FLICKER APAR SE15974: CA400EXP-TERMEMUL-INCORROUT MACRO RECORDING CAUSES INSTRUCTI APAR SE16377: CA400EXP-TERMEMUL-INCORROUT PCSWS ERROR ON WIN2003 PC APAR SE16461: CA400EXP-TERMEMUL-INCORROUT WS FILE STORED ON NETWORK DRIVE APAR SE16941: CA400EXP-TERMEMUL-MSGPCSWS PLAYBACK OF A MACRO CAUSES PCSWS APAR SE17146: CA400EXP-PRINTEMUL-INCORROUT INCORRECT OUTPUT WHEN USING APAR SE17386: CA400EXP-TERMEMUL-INCORROUT PC5250 DISPLAY MOSTLY BLANK FIEL APAR SE17656: CA400EXP-TERMEMUL-INCORROUT BATCH FILE PROCESSING APAR SE17658: OSP CAEXP-DSP-INCORROUT SHAPE OF YEN: AND DOLLAR:$. APAR SE17835: OSP-PAR PCSWS026 ERROR WHEN SAVING .WS FILES AFTER LOADING APAR SE17843: CA400EXP-TERMEMUL-INCORROUT HACL AUTOMATION OBJECT EVENTS NO APAR SE17965: CA400EXP-TERMEMUL-INCORROUT PC5250 PUSH BUTTON NOT RETURNING APAR SE18068: CA400EXP-TERMEMUL-WAIT EXIT HANGS WITH READ-ONLY .WS PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE17216: CA400EXP-OPCON-INCORROUT some signon failures not displayed APAR SE18139: CA400EXP-OPCON-INCORROUT RCP listed as not authorized APAR SE18189: CA400EXP-OPCON-MSG Virtual Control panel CWBOPAOC.EXE fault APAR SE18351: CA400EXP-OPCON-INCORROUT AFTER RCS TO LCS CONNECTION FAILURE PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI15176 Build date = September 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE15339: CA400EXP-DTRANSFER-MSGCWBDB0052 DATA TFR DOWNLOAD TO HTML APAR SE16157: CA400EXP-SSL-INCORROUT MANDATING SSL FAILS 5250, VERIFY APAR SE16446: CA400EXP-OPNAV-INCORROUT DISCOVERY OF ADMINISTRATION SYSTEM PROBLEM APAR SE16477: CA400EXP-OPCON-INCORROUT LAN CONSOLE NOT CONNECTING ANYMORE APAR SE16866: CA400EXP-OPNAV-MESSAGES-INCORROUT MULTIPLE SEND MESSAGE ITEMS APAR SE16920: CA400EXP - Multiple Platform XDA APAR SE17036: CA400EXP-2-MSGCWB4028 RMTCMD REJECTS RESTRICTED USERS The RMTCMD program in the V5R3 iSeries Access for Windows client behaves differently than previous versions did. If the user has limit capabilities set to *YES on their user profile, RMTCMD is now rejecting attempts to run commands with a message CWB4028. It makes no difference if the command is allowed by restricted users or not, it is rejecting all commands with this message. The change was made to the client without any notification in the Memo To Users for V5R3 and is causing existing customer programs to fail and if this function does not revert back to the old behavior, those programs will need to be rewritten. The RMTCMD program will be changed back to it's previous behavior of allowing iSeries profiles with limited capabilities to execute commands. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE14716: LIC OPS NAV WAIT CONDITION APAR SE15235: OSP-DB TIME LABEL INCORRECT ON TOTAL RUNTIME LABEL IN INAV APAR SE15469: CA400EXP-OPNAV-INCORROUT Sys Monitor crash when edit values APAR SE15492: CA400EXP-OPNAV-DBASE-INCORROUT Canceling insert of a row into table causes following row to be deleted APAR SE15899: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DELETE HOST DYNAMIC APAR SE15911: CA400EXP-OPNAV-DBASE-INCORROUT SORT EXPLAINABLE STMTS LIST APAR SE15929: CA400EXP-OPNAV-NETWORK-INCORROUT DNS needs to validate subnet field APAR SE15947: CA400EXP-OPNAV-DBASE-WAIT Run SQL Scripts Save changes dialog does not appear APAR SE15975: CA400EXP-OPNAV INCORROUT create of new ASP fails to display 2105 type ESS LUNS APAR SE15985: CA400EXP-OPNAV-DBASE-UNPRED CLICKING JOURNALING CAUSES ABEND APAR SE16000: CA400EXP-OPNAV-WAIT Two TaskActionEvents for a shared propertysheet causing a hang in iNav APAR SE16041: CA400EXP-OPNAV-DBASE-INCORROUT CANNOT CREATE RANGE PARTITION APAR SE16053: CA400EXP-OPNAV-DBASE VE INDEX ADVISOR COLUMNS INFO TRUNCATED APAR SE16055: CA400EXP-OPNAV-DBASE DBNAV SCHEMA IN PROPERTIES INCORRECT APAR SE16056: CA400EXP-OPNAV-DBASE F4 KEY DOES NOT LAUNCH SQL ASSIST APAR SE16075: CA400EXP-OPNAV HAT V5R3 GEO mirroring returns inappropriate message for error condition APAR SE16130: CA400EXP-OPNAV Send SNA panel hangs APAR SE16141: CA400EXP-OPNAV SQL7008 WHEN EDIT TABLE IN CHINESE APAR SE16167: OSP SI13587 CAUSED DATE/TIME FORMAT CHANGE IN OPSNAV APAR SE16458: CA400EXP-OPNAV-MSGJAVAX.SWING.JLABEL WHEN VIEWING PERMISSION APAR SE16475: CA400EXP-OPNAV-INCORROUT SMTP SERVER NAME GETS CHANGED TO APAR SE16486: CA400EXP-OPNAV-INCORROUT Preferred node status change - error for site name APAR SE16561: CA400EXP-OPNAV Inserting rows into table with default values for DATE field produces "Error in assignment" APAR SE16646: CA400EXP-OPNAV-NETWORK-INCORROUT Can't create 1GB ifc w/5700 APAR SE16647: CA400EXP-OPNAV-NETWORK-INCORROUT NAS Batch file NET USER password should not be random string APAR SE16661: CA400EXP-OPNAV-USRGRP-INCORROUT Add LCLPWDMGT parameter The Local password management (LCLPWDMGT) parameter is not available when using iSeries Navigator Users and Groups to create or change a user profile. A checkbox needs to be added to the Users and Groups Capabilities->Password tab display panel to allow IBM Integration for Windows Server users to decide if they want to "Manage this password locally". For more information regarding the changes to iSeries Navigator for managing your IBM Integration for Windows Server users go to http://www.ibm.com/servers/eserver/iseries/navigator/faqs.html#lclpwdmgt APAR SE16751: CA400EXP-OPNAV-NETWORK UCW support for backup VPN to Rochester SDC This Universal Connection Wizard update corresponds with host PTF 5722SS1 SI15166 to configure a backup VPN universal connection. This fix affects the output of the Universal Connection Wizard to support a backup service data center for downloading fixes. The wizard will create a second dial profile in the VPN scenario QTOCL2TP2. To complete creation of the second VPN connection there will be an additional VPN connection QIBMSERVICE52 and a corresponding IKE policy. The Universal Connection Manager on the iSeries will use the backup VPN connection should the primary be unavailable. APAR SE16752: CA400EXP-OPNAV-DBASE-INCORROUT CREATE ADVISED INDEX SCHEMA APAR SE16762: CA400EXP-OPNAV-INCORROUT System status field 'Shared processor pool usage' shows incorrect data APAR SE16838: CA400EXP-OPNAV-DBASE-INCORROUT COLUMN WITH NO DEFAULT APAR SE16926: CA400EXP-OPNAV CPFB957 Endpoint system not found APAR SE17022: CA400EXP-OPNAV CTL-C of spooled file Followed by Paste Fails APAR SE17045: CA400EXP-OPNAV-FILESYS-INCORROUT OSP COPY/PASTE FROM QTCPTMM IN OPS NAV PUTS FILES IN ROOT OF APAR SE17082: CA400EXP-OPNAV-MESSAGES String index out of range when execute blank statement in Run SQL Scripts DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE15149: CA400EXP-ODBC-UNPRED - ROW-WISE BINDING PROBLEM APAR SE15598: CA400EXP-ODBC-UNPRED SQLSETPOS RETURNS DRIVER NOT CAPABLE ER An application uses Microsoft RDO and iSeries Access for Windows ODBC to access lob fields. The application uses a block size of 100 rows on the fetch, then attempts to use SQLSetPos and SQLGetData to access the lob data. The ODBC driver returns SQLState S1C00 "Driver not capable" on the SQLGetData api. The error is caused because the odbc driver does not support positioning to a specific row in a block fetch when the requested block size is greater than 1. This restriction is described in the ODBC driver metadata via the SQLGetInfo SQL_GETDATA_EXTENSIONS API. The driver is adding support so that SQLSetPos can be called to position to the first row in a rowset. The driver will return the "driver not capable" error on a SQLSetPos call if an attempt is made using this API to position to a row beyond on the first in the rowset. APAR SE15814: CA400EXP-ODBC CATALOG_NAME NAMES ARE PADDED WITH SPACES APAR SE15895: CA400EXP-ODBC-MSGINTERNAL DRIVER ERROR INTERMITTENT FAULT IN APAR SE16131: CA400EXP-ODBC-UNPRED - PACKAGE PROBLEM WITH STATEMENT IN USE APAR SE16287: CA400EXP-ODBC-MSGSQL7008 AUTOCOMMIT OFF COMMIT MODE CHANGED APAR SE16834: CA400EXP-ODBC-INCORROUT INCORRECT DECIMAL PARAMETER VALUES APAR SE16919: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS OLE DB PROVIDER --------------- APAR SE15785: CA400EXP-OLEDB-INCORROUT ADO ActualSize wrong for LOBS. APAR SE15809: CA400EXP-OLEDB-MSGCPF9810 TABLE NAME LISTED AS THE LIBRARY APAR SE16302: CA400EXP-OLEDB-MSGCWBZZ5014 INSERT/UPDATE TABLE WITH LOB APAR SE16667: CA400EXP-OLEDB-INCORROUT SQLSTATE NOT SET FOR COMM ERROR .NET DATA PROVIDER ------------------ APAR SE15897: CA400EXP IDB2DATA Add iDB2ProviderSettings class A new class is needed to enable static, process-wide settings for the IBM.Data.DB2.iSeries .NET provider. The following new class will be created: Class name: iDB2ProviderSettings Description: Provides a way to set process-global provider settings. This class cannot be inherited. Property name: static string ProviderVersion (read-only) Description: Returns a string containing the IBM.Data.DB2.iSeries .NET provider's AssemblyFileVersion. Method name: static void CleanupPooledConnections() Description: Performs orderly cleanup of pooled connections. Calling this method just before your process terminates will ensure pooled iDB2Connections get cleaned up properly. Make this method the last call you make before your process terminates. This ptf adds the new iDB2ProviderSettings class. APAR SE16002: CA400EXP IDB2DATA CommandBuilder fails with WHERE clause APAR SE16003: CA400EXP IDB2DATA Exception with Decimal/Numeric result data APAR SE16036: CA400EXP IDB2DATA Fix incorrect parameter handling for Stored Procedures APAR SE16951: CA400EXP IDB2DATA Add support for LOBs and Library List Add support for LOBs and Library List to the .NET provider. The following new data types are added: iDB2Blob - represents a binary large object iDB2Clob - represents a character large object iDB2DbClob - represents a double byte character large object A new iDB2NamingConvention enum is created that allows the application to select SQL naming or System naming. The iDB2Connection class has the following new properties: Naming - to control the naming convention (SQL or System). Value is specified as either SQL or System. MaximumInlineLobSize - to control the threshold at which LOB data is transferred using LOB Locators, instead of as inline data. Value is an integer in the range 0-15360 which specifies the maximum size (in kilobytes) of a LOB which can be retrieved from the host server in a single operation. LibraryList - allows the application to set the user portion of the host server job's library list. If the application wants the DefaultCollection included in the library list, it must include it in the LibraryList property. LibraryList is a comma-delimited list of library names which may contain the special name *USRLIBL, which is a placeholder to indicate the host server job's current user portion of the library list. By placing other library names before or after *USRLIBL, the application can control where the libraries get added in relation to the job's current user library list. If *USRLIBL is not specified in the LibraryList, the specified libraries will replace the server job's current user library list, so applications that wish to add to the library list should be sure to specify *USRLIBL somewhere in the LibraryList. The iDB2DataReader class has the following new methods: GetiDB2Blob(int index) GetiDB2Clob(int index) GetiDB2DbClob(int index) This ptf adds LOB and Library List support to the .NET provider. APAR SE17162: CA400EXP IDB2DATA Decimal/Numeric digits truncated LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.5 (07/30/2004) and the equivalent of 5722JC1 SI14873. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE14730: CA400EXP-TERMEMUL-INCORROUT PC5250 NEGOTIATES WRONG KBDTYPE APAR SE15297: OSP PCSERR101 ERROR WHEN A COPY/PASTE FUNCTION IS PERFORMED. APAR SE15562: CA400EXP-TERMEMUL-MSGPCSERR999 MACRO LIMITED TO 64KBYTE APAR SE15735: CA400EXP-PRINTEMUL-UNPRED PRINTER SETUP WINDOW DOES NOT DISP APAR SE15931: CA400EXP-TERMEMUL-INCORROUT AFTER RETURNING TO CALLING PGM APAR SE16801: CA400EXP-TERMEMUL-INCORROUT GERMAN FUNCTION KEY ALT K IS NOT PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE13412: CA400EXP-OPCON-INCORROUT REMOTE CONTROL PANEL FAILS APAR SE16299: CA400EXP-OPCON-INCORROUT wizard hangs in WinNT APAR SE16534: CA400EXP-OPCON-INCORROUT fault RCS to LCS and firewall APAR SE16535: CA400EXP-OPCON-INCORROUT close may hang APAR SE16821: CA400EXP-OPCON-INCORROUT emulator may not start PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- Non-APAR fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI13587 Build date = May 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE12606: CA400EXP-2-MSGCWBCF0005-F/CWBBACK CWBBACK FAILS WHEN DBCS INVOLVED APAR SE13599: CA400EXP - Add 64 bit support to XDA Windows client APAR SE13926: CA400EXP-CONNECTIONS-UNPRED NO CWBCFG KERBEROS SETTING The cwbcfg utility provides a parameter for configuring the signon mode of the connection being defined: /uid . All signon modes may be set using this parameter except the use of Kerberos. The /uid parameter of cwbcfg now accepts the value *KERBEROS which configures the connection to use Kerberos for authentication. For example: cwbcfg /host server1 /uid *KERBEROS creates a connection to server "server1" and configures it for all users of the PC, and for the Default User, so that Kerberos is used for authentication. Previously, the only allowed values were *WINLOGON, *PROMPTALWAYS, and an actual iSeries user ID. IMPORTANT NOTE: Although you can now configure the new connection to use Kerberos, authenticating this way may not work. One possible reason is that the new or changed connection is configured only for accounts local to the PC on which cwbcfg is run. Successful use of Kerberos may require logging on to a domain, and local account configuration information is not typically used for domain logons. This is no different from the case in which a user logs on to the local PC, then uses iSeries Navigator to configure a connection to use Kerberos as the means of authentication. APAR SE14941: CA400EXP-DTRANSFER Help not displayed APAR SE15016: SSL - Update default key database A VeriSign Global Server Intermediate Root CA certificate has expired on January 7, 2004. This CA certificate was included in the default SSL key database shipped with the product. Updated SSL key database files (cwbssldf.kdb and cwbssldf.sth) will be provided by this service pack. The new files will only be installed if the previous files are deleted or do not exist in the Common Documents folder. APAR SE15205: CA400EXP - Incorrect data passed to database server from XDA Windows client APAR SE15507: CA400EXP-OPCON-INCORROUT CWBOPAUT.DLL ERROR APAR SE15715: CA400EXP-INCORROUT cwblmsrv background task not exiting OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE12438: CA400EXP-OPNAV-OUTPUT-INCORROUT CWBUN_GETPUBLICLISTOBJECT AP APAR SE12441: CA400EXP-OPNAV-NETWORK-MSGCPI0954 CREATE DISK TO MAX ASP USE APAR SE12774: CA400EXP-OPNAV-DBASE-INCORROUT CREATE NEW VIEW DIALOG MAY NO APAR SE12976: CA400EXP-OPNAV-DBASE-INCORROUT PROMPTING FOR PASSWORD APAR SE13504: CA400EXP-OPNAV-INCORROUT LPAR Create wizard doesn't use regional setting for shared procs APAR SE13614: CA400EXP-OPNAV-NETWORK Universal Connection Wizard modal to frame APAR SE13616: CA400EXP-OPNAV-NETWORK-INCORROUT Leased lines line profile cannot be updated APAR SE13629: CA400EXP-OPNAV-NETWORK Remote support authentication ids to allow connect APAR SE14019: CA400EXP-OPNAV-NETWORK-INCORROUT File extensions corrupted on add share APAR SE14236: CA400EXP-OPNAV ISERIES NAVIGATOR HANG LISTING PRINTER OUTPUT APAR SE14383: CA400EXP-OPNAV-NETWORK Routes not added when configuring an ATT dial connection APAR SE14408: CA400EXP-OPNAV-FILESYS-PERFM LONG DELAYS WHEN MOVING MULTIPL APAR SE14555: CA400EXP-OPNAV-NETWORK-INCORROUT DNS ENABLES ADD HOST APAR SE14558: CA400EXP-OPNAV-NETWORK-INCORROUT SMTP properties update fails APAR SE14569: CA400EXP-OPNAV-INCORROUT MC Task Status window does not always paint APAR SE14570: CA400EXP-OPNAV-NETWORK UCW Qtocl2txx line description wrong APAR SE14574: CA400EXP-OPNAV-INCORROUT Changing Max graph value on graph history takes two refreshes to take effect APAR SE14585: CA400EXP-OPNAV-NETWORK UCW phone5 call list to phone4 APAR SE14644: CA400EXP-OPNAV-NETWORK RAS PPP filter identifier list empty APAR SE14720: LIC-DISK-STG OPS NAV DISK POOLS DISPLAY PROBLEM APAR SE14734: CA400EXP-OPNAV-INCORROUT CURRENT ADMINISTRATION SYSTEM/USER CAN NOT BE REMOVED APAR SE14800: CA400EXP-OPNAV-NETWORK-INCORROUT Webfacing settings not saved APAR SE14802: CA400EXP-OPNAV-NETWORK-INCORROUT Netserver Single Signon failing due to uppercase keytab entries. APAR SE14914: CA400EXP-OPNAV-INCORROUT Capabilities->Auditing page must be hidden for non-administrators APAR SE14968: CA400EXP-OPNAV- PRINTER OUTPUT ACTION ERROR IN OUTQ SHORTCUT APAR SE14983: CA400EXP-OPNAV-NETWORK-INCORROUT QoS Configuration GUI ignores subnet mask input when creating a new Client object APAR SE15045: CA400EXP-OPNAV User registration is not working Service Agent user registration fails using iSeries Navigator. NOTE: In order for this fix works properly you need to install PTF SI13239 for the OS/400 operating system (5722SS1) or one that supersedes it in the iSeries server that is specified as Management Central system. APAR SE15048: CA400EXP-OPNAV ESA Verify connection to IBM is hung Verifying connection to IBM window is hung NOTE: In order for this fix works properly you need to install PTF SI13239 for the OS/400 operating system (5722SS1) or one that supersedes it in the iSeries server that is specified as Management Central system. APAR SE15049: CA400EXP-OPNAV ESA Subsystem jobs window APAR SE15050: CA400EXP-OPNAV ESA License not displayed for any release APAR SE15052: CA400EXP-OPNAV-AUTHLIST-INCORROUT Need to display description of Authority lists in iSeries Navigator Window APAR SE15081: CA400EXP-OPNAV-UNPRED Moving node up to be primary in Recov. Domain doesn't show entire line moving & "ineligible" node status APAR SE15105: CA400EXP-OPNAV-INCORROUT When adding a data port ip address fails, the address still shows up in the gui like it was successful APAR SE15106: CA400EXP-OPNAV-PERFM Occasional Hangs during make available APAR SE15122: CA400WINOPT-OPNAV Support new hardware for V5R3M0 on Graphical Views No graphical views for the new hardware. Graphical views added. Requires PTF 5722999 MF32576 as well. APAR SE15148: CA400EXP-OPNAV-INCORROUT Cannot Display Disk Pool Properties Of Mirrored IASP APAR SE15212: CA400EXP-OPNAV-DBASE-INCORROUT SCHEMA STARTS WITH @ # $ APAR SE15219: CA400EXP-OPNAV-OUTPUT-INCORROUT SPOOLED FILE LIST INCOMPLETE APAR SE15222: CA400EXP-OPNAV-INCORROUT Error removing user in Customize Access dialog APAR SE15282: CA400EXP-OPNAV-INCORROUT Consolidated Hardware File saved to incorrect path APAR SE15308: CA400EXP-OPNAV-INCORROUT Suspend Geographic Mirroring menu item occasionally in incorrect state APAR SE15367: CA400EXP-OPNAV-NETWORK-WAIT Directory Server Propertysheet hangs searching/updating the configuration APAR SE15388: CA400EXP-OPNAV-UNPRED APPLICATION DEVELOPMENT FOLDER MISSING APAR SE15395: CA400EXP-OPNAV-INCORROUT Adding a data port ip address failure still shows up as successful APAR SE15500: LIC-DISK-STG-UNPRED APAR SE15501: CA400EXP-OPNAV Drop down with wrong value on Edit Time Zone APAR SE15511: CA400EXP-OPNAV-INCORROUT Intelligent Agent panel hangs APAR SE15512: CA400EXP-OPNAV-NETWORK Unable to turn off LDAP filter cache support APAR SE15513: CA400EXP-OPNAV-INCORROUT Configuring a V5R2 server that is a replica to a master fails. APAR SE15514: CA400EXP-OPNAV-INCORROUT Directory Server publishing fields not enable/disabled correctly. APAR SE15526: CA400EXP-OPNAV-DBASE-WAIT CANNOT LAUNCH EXPRESSION BUILDER APAR SE15527: osp - Deleting a data port IP address fails APAR SE15528: CA400EXP-OPNAV-INCORROUT Removing a node in a recovery domain handled incorrectly APAR SE15545: CA400EXP-OPNAV Cannot Deconfigure Just A Secondary IASP APAR SE15546: CA400EXP-OPNAV-INCORROUT GUI is partially untranslated APAR SE15748: CA400EXP-OPNAV Site name & membership status incorrect in recovery domain when moving nodes DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE15025: CA400EXP-DTRANSFER - UTF-8 ALWAYS TRUNCATES SPACES APAR SE15133: CA400EXP - DTRANSFER - trap opening TTO file APAR SE15135: CA400EXP-DTRANSFER UNICODE AND UTF8 PROBLEMS APAR SE15716: CA400EXP-DTRANSFER trailing blanks cause CWBLM0040 APAR SE15767: CA400EXP-DTRANSFER THE BROWSE FILES AND MEMBERS WINDOW FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE15356: CA400EXP-DTRANSFER-INCORROUT FDF DATE/TIME SETTINGS RESET WHEN USING USING EXCEL WIZARD ODBC ---- APAR SE13347: CA400EXP-ODBC-UNPRED SQLCOLATTRIBUTES SQL_COLUMN_SEARCHABLE APAR SE14242: CA400EXP-ODBC-MSGCPF5035 OVERLAY OF PARAMETER DATA ON SECON APAR SE14415: CA400EXP-ODBC-INCORROUT - RETURN TIME, DATE, TIMESTAMP AS SQL_CHAR APAR SE14963: CA400EXP SQLEXTENDEDFETCH RETURNS PWS0001 RETURNING DATA FRO APAR SE15056: CA400EXP-ODBC-INCORROUT - OVERRIDE PASSWORD ENHANCEMENT When connecting with ODBC and your password is expired on the server, an error or a dialog asking the user to change the password is returned to the application. To avoid the error and possible dialog, an enhancement is being provided to allow an application to programmatically change the user's password. An example scenario on how this might be used is listed below: The application calls SQLDriverConnect with the SQL_DRIVER_NOPROMPT DriverCompletion option and the userid (UID keyword) and password (PWD keyword) specified in the connection string. Since the userid and password combination is expired, an error (SQL_ERROR) is returned to the application. No prompts are returned because of the SQL_DRIVER_NOPROMPT option. The application calls SQLError (or SQLGetDiagRec) to get back the NativeError. If the native error is 8003 then this is the case where the userid/password combination was expired. The application calls SQLDriverConnect with the userid (UID keyword), current password (PWD keyword), and the new password (NEWPWD keyword) specified in the connection string. The driver will change the password for that user profile to the new password if the current password is valid. APAR SE15502: CA400EXP-ODBC-INCORROUT - FIX SQLPROCEDURECOLUMNS ISSUES THAT COULD CAUSE FAULTS OLE DB PROVIDER --------------- APAR SE14470: CA400EXP-OLEDB-INCORROUT ZERO LENGTH PARAMETER DATA INCORREC APAR SE15283: CA400EXP-OLEDB-UNPRED RLA RANDOM TRACE APAR SE15503: CA400EXP-OLEDB-INCORROUT BLANK STRINGS RETURN INCORRECT DATA .NET DATA PROVIDER ------------------ APAR SE13984: CA400EXP IDB2DATA MSGSQL0501 Cursor not open error APAR SE13985: CA400EXP IDB2DATA INCORROUT iDB2CommandBuilder fails with table created using DDS APAR SE13986: CA400EXP IDB2DATA INCORROUT DeriveParameters not setting Size and IsNullable APAR SE14008: CA400EXP IDB2DATA INCORROUT DeriveParameters not setting ParameterName APAR SE15169: CA400EXP IDB2DATA .NET traces and logs sometimes do not work APAR SE15170: CA400EXP IDB2DATA Fix several problems with .NET provider A new method is added: iDB2DataReader.HasRows(). This method can be called to determine if the iDB2DataReader returned any rows. A final change is made to remove the public constructor for the iDB2ParameterCollection class. The parameter collection is always associated with an iDB2Command and should not be created by an application. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- Non-APAR fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.3 (04/02/2004) and the equivalent of 5722JC1 SI13437. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE12161: CA400EXP-TERMEMUL-INCORROUT IBM3270-1250 FONTS ARE NOT APAR SE12423: CA400EXP-TERMEMUL-INCORROUT CHARACTERS NOT CHANGED TO UPPERC APAR SE12821: CA400EXP-TERMEMUL-UNPRED PC5250 SESSION DROPPING WHEN USING APAR SE13349: CA400EXP-TERMEMUL-DBCS U/3010(EBCDIC:X/4466) CANNOT DISPLAY APAR SE13430: CA400EXP - TERMEMUL - Add support for LotusScript Extension APAR SE13431: TERMEMUL Signed Numeric won't paste to protected fields Currently if you copy and paste numeric fields they will paste into unprotected and protected fields. But if you copy and paste signed numeric fields, they will not paste into protected fields. This fix is enabled when the existing option, "Force Leading +/-", is ON. APAR SE13658: CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE ISSUE ON JAPANESE APAR SE13859: OSP-PAR RUNTIME ERROR. ABNORMAL PROGRAM TERMINATION. APAR SE13964: CA400EXP-TERMEMUL-INCORROUT DATA IN BLINKING FIELDS DOES NOT APAR SE13971: OSP-PAR USING VBSCRIPT MACROS MULTIPLE TIMES IN PC5250 HANGS APAR SE13991: CA400EXP-TERMEMUL-UNPRED FUNCTION AND ENTER KEYS INTERMITTEN APAR SE15134: CA400EXP-TERMEMUL PrintScreen doesn't work PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE14819: CA400EXP-OPCON-INCORROUT GUI can hang when CPU is busy APAR SE15504: CA400EXP-OPCON-INCORROUT cwbopcon fault during disconnect APAR SE15505: CA400EXP-OPCON-INCORROUT 5250 emulator doesn't connect APAR SE15506: CA400EXP-OPCON-INCORROUT status 'connected' but system down PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE15136: CA400EXP-INCORROUT cwbCO_GetPasswordExpireDate The API cwbCO_GetPasswordExpireDate returns CWB_INV_BEFORE_VALIDATE when user profile set to *NOMAX. The documentation for API cwbCO_GetPasswordExpireDate will be updated as follows: CWB_INV_BEFORE_VALIDATE The user ID and password that were set in the specified system object have not been validated (so the password expire date is not available), or validation has occurred and the user profile password expiration interval is set to *NOMAX. Usage You must successfully call cwbCO_VerifyUserIDPassword, cwbCO_Signon, or cwbCO_Connect before calling cwbCO_GetPasswordExpireDate. (Note: CWB_INV_BEFORE_VALIDATE can represent a successful call, if the user profile password is set to never expire (*NOMAX) ) If you want to ensure that the value that is returned is recent, you either must call cwbCO_VerifyUserIDPassword explicitly, or set the Validate Mode to CWBCO_VALIDATE_ALWAYS before you call cwbCO_Signon or cwbCO_Connect. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. 4.0 INSTALL/UNINSTALL CONSIDERATIONS ------------------------------------- The following sections describe additional support and known problems that you may notice while using the Install/Uninstall function. 4.1 REMOVING THE SERVICE PACK ------------------------------ To remove this service pack from your PC (if the service pack was originally installed with the Enable Service Pack Uninstall option): 1. Click the Windows Start button, click on Settings, and then click on Control Panel. 2. Double-click on the Add/Remove Programs icon. 3. Click on the Change or Remove Programs button (if necessary), then find and click on the IBM iSeries Access for Windows SI18651 item, and then click on the Change/Remove button. 4. Follow the instructions on the screen. 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- InstallShield is the tool used to provide the install support for iSeries Access for Windows. The same tool is used for installing service packs. Setup.exe has a 2 minute timeout to initialize to the first wizard panel, which could expire when installing service packs over very slow communication lines. If installing from a CD or a faster connection is not possible, then the service pack could be installed in this manner: 1) A setting exists on the iSeries Access for Windows Properties Service tab that will copy the service pack image to the PC's temporary directory, install the service pack, then remove the copied files. To use this support you will need to specify this setting ("Copy install image to PC before installing"). 2) Run Check Service Level (either from the IBM iSeries Access for Windows Service folder shortcut or when Check Service Level runs at system boot on its defined schedule) STATUS: No status information is displayed while the files are copied. To determine if the transfers are progressing, look in the 'CA400CKV' temporary directory (beneath the PC temporary directory, for example C:\Documents and Settings\username\Local Settings\Temp). You should see new files appear periodically. 3) Proceed through the Service Pack install wizard to complete the install. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator can use the SP.TXT file. If the administrator places a file named SP.TXT (with a 'N' in the first position of the first line) in the service pack installation image directory, the service pack will not be installed. 5.0 DATA TRANSFER CONSIDERATIONS --------------------------------- The following sections describe additional support or known problems that you may notice while using the Data Transfer function. 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 ----------------------------------------------------------- WHY DOES MY DATA LOOK LIKE GARBAGE WHEN I PERFORMED A DOWNLOAD? By default, the Data Transfer function will not convert data between EBCDIC and ASCII if the data is tagged with a CCSID of 65535. In older versions of the Win 95/NT Client Access product, the 65535 conversion was controlled by the CWBTFR.INI file. This process has been changed, and the conversion is now controlled by the Data Transfer user interface. Once the setting has been made in the user interface, it is then stored in the transfer request. This is only true for .TTO and .TFR files. .RTO and .DT files are still controlled by the CWBTFR.INI file. The conversion setting for .RTO and .DT files can be modified in the Data Transfer user interface, but the setting will not be saved. The setting to control the conversion is found in the File, Properties information. WARNING: This feature is designed as a workaround for people that can not change the CCSID of their files. In order for this translation to work properly, you must be confident the data in the file matches the CCSID of your user profile. The design of the iSeries is that data with a 65535 CCSID are not to be converted. This feature will attempt to do a conversion of the data from the job CCSID to the PC CCSID. This conversion may not work if the data in the file does not match the user profile/job CCSID. The correct solution to this problem is to appropriately tag the data with the correct CCSID. One way of doing this is by using CHGPF. For more information on the 65535 CCSID, please reference the iSeries National Language Support Manual.