============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R2M0 Cumulative Service Pack Level ------------- SI06631 ------------- (c) Copyright IBM Corporation 2002. All rights reserved. ======================================================================== 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 RESTRICTIONS 2.1 iSeries NAVIGATOR 2.2 iSeries OPERATIONS CONSOLE 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI06631 (November 2002) 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. 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. 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 tailor the Client Access Express 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 clean temporary directory. 2. Run PTFFORM.EXE to expand the service pack files. 3. Delete PTFFORM.EXE after expansion. 4. Copy the contents of this temporary directory into a iSeries Access for Windows installation image directory, selecting the option to replace any existing file. 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 4-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. Tailoring from a full image after combining PTFFORM.EXE takes more time, but results in a more efficient resulting image from a disk space standpoint. 2.0 RESTRICTIONS ----------------- 2.1 iSeries NAVIGATOR ---------------------- 1) Due to technology incompatibilities, occasionally a window can be displayed behind other windows when running the iSeries Navigator. If the iSeries Navigator looks like it has stopped working, it is possible that the window you are waiting for is being displayed behind another window on your desktop. Press the Alt key and then the Tab key to see a list of all the windows on your system and select window behind the iSeries Navigator window, or another window on your desktop. 2.2 iSeries OPERATIONS CONSOLE -------------------------------- 1) It is recommended that you restrict LAN topologies for LCS attachment to a single, physical ring/hub/switch fabric. In the event that the LCS is used in a larger network topology, broadcast (DHCP) packet filtering is always recommended. 2) The maximum number of concurrent active sessions via the PCOM 5250 emulator is 26. 3) If an automatic session re-connect to an OS/400 image on an iSeries or iSeries server on iSeries Operations Console start-up fails, simply use the manual re-connect process by right-clicking the connection profile that failed to re-connect and selecting 'Connect'. 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 = SI06631 Build date = November 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE07361 CA400EXP-DTRANSFER-INCORROUT TRANSFERRING TO CCSID 13488 Data Transfer To AS/400 fails with messages "CWBDB0036 - The Database Access server returned a SQL error." and "SQL0189 - CCSID 850 is not valid." when transferring data to AS/400 files that contain Unicode fields (GRAPHIC CCSID 13488). This problem also occurs on PC's with client CCSIDs other than 850. APAR = SE07669 OSP-PAR CLIENT ACCESS LICENSE NOT ALWAYS RELEASING AFTER SET In the Other tab of the Client Access Properties, there is a setting for Client Access Express license releasing. The license is not always released after this set time due to a timing bug. This could cause CWBLM0011 to be intermittently generated when trying to connect with Client Access Express licensed functions. APAR = SE07950 CA400EXP-TERMEMUL-MSGCWBLM0011 CWBLM0011 ERROR WITH CLIENT Client Access Express PC5250 fails with CWBLM0011. The error seems to also affect Windows administrator accounts. APAR = SE08029 CA400EXP-DTRANSFER-WAIT CWBLMSRV.EXE INHERITING THE FILE Customer runs RTOPCB.EXE in a PC batch file outputting STDOUT into a log file for later analysis. After upgrading from CA R450 to CA R510, the write to the log file fails after the first run in the batch with "access denied" type messages. Customer has discovered that after running RTOPCB.EXE once, RTOPCB appears to hold a lock on the log file for 30 seconds to several minutes after the run completes. APAR = SE08320 CA400EXP-CONNECTIONS-INCORROUT cwbcfg configs not changed; add /ipaddr modes When cwbcfg is run, even when /r is specified, not all existing user profiles are updated with the specified configuration information.  Users created after cwbcfg is run do get the configuration information, as desired. Also, the only IP Address setting possible using cwbcfg is to specify the IP Address explicitly, which implicitly sets the IP Address Lookup Frequency to Never. The other lookup frequencies cannot be set. This PTF fixes the reported problems. The /ipaddr parameter now can be used with any of the following: n.n.n.n If the actual IP address is specified in the format n.n.n.n, it will be set, and will never be looked-up. *ALWAYS The IP address will be looked-up every time a connection is attempted. *HOURLY The IP address will be looked-up only if an hour has passed since the last lookup. *DAILY The IP address will be looked-up only if a day has passed since the last lookup. *WEEKLY The IP address will be looked-up only if a week has passed since the last lookup. *STARTUP The IP address will be looked-up only if Windows has been shutdown and re-started since the last lookup. For example, the following command will not only set the default user ID of system MySys to Frank, it will also set the IP Address Lookup Frequency so the address is looked-up only if at least a day has passed since the last lookup. Because /r is used, it will modify even existing MySys configurations. cwbcfg /host MySys /ipaddr *DAILY /uid Frank /r APAR = SE08343 CA400EXP-2-LOOP ByteStream type 1 directories with large number of entries will hang iNav IFS Requests to a type 1 IFS directory with more than 120 entries will fail resulting in a loop adding the same files repetitively in the iSeries Navigator directory list. OPTIONAL COMPONENTS ------------------- DIRECTORY UPDATE ---------------- No fixes. INCOMING REMOTE COMMAND ----------------------- No fixes. USER'S GUIDE ------------ No fixes. iSeries NAVIGATOR ----------------- APAR = SE06986 OSP-AFP-PRT UNABLE TO USE IMPORT OVERLAY FUNCTION OF AFP MAN Unable to use Import overlay function of AFP Manager if user does not have a current library assigned and user attempts to import to the current library. Circumvention for APAR SE06986: ------------------------------- Assign a current library in the user's profile. APAR = SE07200 TCPIP-SMTP OP NAV FAILURE ATTEMPTING TO CHANGE/DISPLAY SMTP If the pop attribute for refresh interval is set to *none attempting to change or even display the smtp attributes with operations navigator will fail. The error message indicates 0 is an invalid value for ADRBOOK. Java SMTP properties did not handle 0 case for Refresh Interval, which is equivalent to *NONE. APAR = SE07618 OSP-MSGCPD0104-PAR-CA400EXP-OPNAV CANNOT ENROLL TO DOMAIN If the Windows Domain name contains a hyphen (-), then enrolling users to the Windows Domain using Operations Navigator will fail, issuing the following message: CPD0104 Expression not allowed for parameter WNTDMNLST. The CHGNWSUSRA command string was incorrectly built, which caused the command syntax to be incorrect. This problem has been fixed. APAR = SE07701 CA400EXP-OPNAV-INCORROUT ISERIES NAVIGATOR GETS AN INVALID P When using iSeries Navigator V5R2M0 with PTF SI04684, an access violation occurs in module cwbuncmn.dll at instruction 0x64c0f353. This occurs when trying to add the Databases Tasks node to My Tasks. The root node Databases Tasks should not be allowed to be added to the user defined tasks. The problem can be reproduced very easily as follows: - Open iSeries Navigator. - Expand your iSeries connection in the tree. - Select the Databases node in the tree. - Right click on the My Tasks pane and choose Customize Taskpad. - Select Databases Tasks and click on Add After. APAR = SE07991 OSP-DB VISUAL EXPLAIN HANGS WITHOUT DISPLAYING RESULTS When running a SELECT statement from "Run SQL Scripts" in iSeries Navigator, the results are correctly displayed. When Visual Explain is selected for the same query, Visual Explain appears to hang and does not generate output. This is known to only happen on OS/400 with one of the following languages: 2962, 2938, and 2950. APAR = SE08031 CA400EXP-OPNAV-NETWORK-INCORROUT UNIVERSAL CONNECTION WIZARD Universal Connection Wizard fails to configure multiple systems one after another. Once you've used the wizard to configure one system, when you start it again on another server/partition, it fails at the line description window. It does not allow the default line description name QESPPLIN although there is no such line yet configured on this second server/partition. Steps to reproduce : - step 1. Delete the QESDIAL profile on both systems/partitions you want to configure. - step 2. Delete line description QESPPLIN on both systems/partitions you want to configure. - step 3. Start the wizard for the first system/partition (you will get a prompt for the line description, leave it to the default). - step 4. Start the wizard for the second system/partition. - step 5. An error will pop-up when you get to the window with the name for the line description (QESPPLIN) stating that this line is already configured. Circumvention for APAR SE08031: ------------------------------- Close and restart Operations Navigator. APAR = SE08075 CA400EXP-OPNAV-DBASE-MSGSQL0615 VISULAEXPLAIN GOT SQL EXCEPT OS/400 v5r1 c2134 sf99501-9 applied. ca/400exp si05361 applied. When I run Visual Explain with a statement that has a literal value following the SELECT keyword, for example SELECT 'X' FROM...., I got an error 'SQL Exception'. The first error window said, 'No statistics found for this query'. Then, click OK button. then the next window said 'SQL Exception' and detailed message was , 'SQL satate : 38501 Vendor code : -443 . message : SQL0615 .... Circumvention for APAR SE08075: ------------------------------- Don't put a literal value following the SELECT keyword. APAR = SE08101 CA400EXP-OPNAV-DBASE-INCORROUT OPERATIONS NAVIGATOR "RUN SQL R520 iSeries Navigator "Run SQL Scripts" corrupts parameters that exceed a certain numeric value when being sent to a stored procedure. APAR = SE08145 CA400EXP-OPNAV-DBASE-INCORROUT SQL SCRIPT SAVE AS SHOWS AN When the option SAVE AS of an SQL SCRIPT is chosen an unexpected pane named NUOVA CARTELLA is shown. This happens only if LOCALE PC setting is ITALIAN. APAR = SE08162 CA400EXP-ODBC FAILURE. ERROR "DESCRIPTOR INDEX NOT VALID" IS Using the Operations Navigator to run procedures on AS/400, if the same procedure is called two consecutively times, the first time the data returned are OK and the second time the error msg "Descriptor index not valid" is sent back. To reproduce the problem follow these steps: Open Operations Navigator and right click SYSTEM/DATABASE/SYSTEM choose "Run SQL Script" and insert this command to create an example procedure: CREATE PROCEDURE SMIC(OUT RETCODE DECIMAL(3,0), OUT MESSAGGIO CHAR(50) ) RESULT SETS 0 LANGUAGE SQL BEGIN DECLARE NUM INTEGER; SET RETCODE = 0; SET MESSAGGIO = 'CIAO'; END; To generate the error message, execute these two statements clicking on "Run All" pushbutton on taskbar: CALL SMIC(A,MSG); CALL SMIC(A,MSG); The first execution of procedure will run fine, and the second one will give back the error message " "Descriptor index not valid". No error messages will be logged on joblog. APAR = SE08220 OSP-DB CA400EXP-OPNAV SQL EXCEPTION DURING CREATE LIBRARY CA400EXP-OPNAV FAILURE DURING CREATE LIB IN OPERATIONS NAVIGATOR APAR = SE08329 CA400EXP-OPNAV-INCORROUT Numeric at start domain name User is unable to enter a domain name that starts with a numeric character. APAR = SE08346 CA400EXP-OPNAV-NETWORK-UNPRED Add new 2793 modem for UCW Universal Connection Wizard is not displaying 2793 modems. APAR = SE08403 CA400EXP-OPNAV-INCORROUT RESOURCEBUNDLEERROR RECEIVED IN OPN When a Dutch version of Client Access is installed on a PC having LOCALE set to US, after few clicks among OpNav options, the RESOURCEBUNDLE ERROR is received. The problem described in this APAR has been fixed. English messages will now be displayed where RESOURCEBUNDLE errors were previously seen. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE07804 CA400EXP-DTRANSFER NATIVE SQL STATEMENT FAILS ON WINDOWS 98 Using Native SQL syntax with Data Transfer From AS/400 on a Windows 98 PC may result in the message 'CWBDB0017 - Call requires SELECT statement' being displayed. The Native SQL statement is not being stored when switching from the Native SQL panel to the Data Transfer From AS/400 panel. A side-effect is that the Native SQL statement is also not being written to the transfer request file. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE07497 CA400EXP-ODBC-INCORROUT STORED PROCEDURE EXPECTED TO RETURN On an ODBC connection, a stored procedure with output parameters which is expected to return 1 result set with 0 records instead returns no result set. A second issue which may occur involves a memory overwrite which can result in corrupted output parameters or program faults. This happens when a CHAR parameter is bound as a VARCHAR, and the value is incorrectly parsed. APAR = SE07922 CA400EXP-ODBC-INCORROUT UNABLE TO LINK TO SPECIFIC LIBRARY Since applying the V5R1 service pack, SI05361, customer cannot link to the specific library which has ASCII Yen X'5C' at the head of library name like 'YenJDASC2'. In the QZDASOINIT joblog, MSGSQL0204 F/QSQRUN1 T/QSQRUN1 is issued. APAR = SE07999 CA400EXP-ODBC-INCORROUT MS EXCEL 2000 GIVES ERROR IN ASSIGNM "Error in assignment" error message is issued on MS Excel 2000 when attempting to get external data from XE1 ODBC DSN. Problem can be easily reproduced by doing the following: - Create an XE1 User DSN (or choose any existing one, i.e QDSN_sysname that is automatically created when accessing OPNAV, Database). - From MS Excel perform the following: Select Data, Get External Data, New Database Query - Choose the above DSN and press OK. - When prompted for userid and pwd, enter the login information and press OK. After few seconds "Error in assignment" error message will be issued causing MS Query to abend. APAR = SE08021 CA400EXP-ODBC-INCORROUT MS ACCESS 2000 LINK EXTERNAL TABLE Since XE1 R520 installation, MS Query 2000 is failing. When linking to an external table that is a PF created with a unique key, the user is always prompted to select field(s) to make a unique key. Problem can be easily recreated by doing the following: - Create a PF with DDS and specify a Unique primary key. - Create an ODBC DSN (or use the DSN that is automatically   created by OPNAV when accessing Database functions). - From MS access 2000 create a new database, then use File,   Get External data, link tables. - Select files of type: ODBC Database and specify the above   ODBC DSN. - When prompted for userid and pwd, Login to AS400 and select   the above PF. After pressing OK you'll be incorrectly prompted   for "select unique record identifier" panel. Traces reveal that the SQLStatistics function is only returning indices with V5R2 whereas all older versions of the driver returned indices and unique constraints. APAR = SE08207 CA400EXP-ODBC-INCORROUT - ODBC Driver uses too much memory The ODBC driver holds onto more memory than needed at a given time. This limits the scalability of applications built on top of the driver. The driver needs to lower its memory usage to a smaller size to more closely match the memory footprint of previous Client Access ODBC drivers. OLE DB PROVIDER --------------- APAR = SE08268 CA400EXP-OLEDB-INCORROUT SEEK FUNCTION USED WITH IBMDA400 OL Use of the integrated seek function of IBMDA400 Record Level Access is failing when using a multiple field key. For example, using a logical file that contains a key of (CHAR(36), Packed(6,0)) and using the seek method with a comparison operator of adSeekFirstEQ results in being positioned to the first record in the file. This happens if the key has a match in the file. The recordset should be positioned to the matching record. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR = SE08202 CA400EXP-AFPVIEWER ERROR OCCURS USING *VIEW FROM AFPU An error occurs when using AFPU to create or change an overlay. The error occurs when you put *VIEW in the Control field of the Design Overlay screen and press enter. The AFP Workbench Viewer, is invoked and error "1314: Unable to open file" is displayed. TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI05645. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE06873 OSP-PAR PCSWS IPF IN MODULE UNKNOWN WHEN STARTING RUNNING VB PCSWS.exe Invalid Page Fault in module unknown. When starting or running VB script macro. APAR = SE07574 CA400EXP-TERMEMUL-INCORROUT BACKSPACE IN A WORD WRAPPABLE FI When using V5R2 of Client Access Express with service pack SI04684 applied, and editing text in a word wrappable field. If the use attempts to use the backspace key when insert is turned on, characters to the right of cursor are not deleted, and spaces are placed between characters. APAR = SE07671 CA400EXP-TERMEMUL-INCORROUT UNABLE TO USE SYSREQ ON PC5250 Unable to use Sysreq on PC5250 session running an interactive looping java program. Recreation Steps : Run the following java class: ************** Datenanfang **************** import java.io.*; public class loop public static void main(String args ) throws Exception int i; for (i=1;i<16777216;i++) System.out.print(i); System.out.println(": I'm still running"); When the program is running, try to use the sysreq function : PC5250 session will hang. APAR = SE07743 CA400EXP-TERMEMUL-INCORROUT PC5250 HANGS WHEN USING SYSREQ PC5250 hangs when using Sysreq Opt.2 on an interactive java looping program. Recreation Steps : Run the following java class: ************** Datenanfang **************** import java.io.*; public class loop public static void main(String args ) throws Exception int i; for (i=1;i<16777216;i++) System.out.print(i); System.out.println(": I'm still running"); When the program is running, get the sysreq line and hit 2 (end the job). PC5250 session will hang. APAR = SE07771 CA400EXP-PRINTEMUL-MSGPCSWS.EXE ERROR INTEGER DIVISION BY 0 Configuring a printer session with the best fit option checked, and then checking the use PDT option under printer setup, causes a PCSWS.exe error that states the exception is "Integer division by zero". APAR = SE07847 CA400EXP-TERMEMUL-INCORROUT NO ALARM ON ICF CLIENTS WHEN When using PC5250 in a Terminal Services environment, ICF or RDP clients do not produce audio alarms when receiving break messages or when displaying a DSPF with the ALARM keyword. This problem started after installing service pack SI05361. APAR = SE08022 CA400EXP-TERMEMUL-INCORROUT CURSOR DOES NOT POSITION PROPERL With certain fields in PC5250, after hitting Enter, the cursor should return to the beginning of the field. After applying SI05361, the cursor remains at its last position. APAR = SE08139 CA400EXP-PRINTEMUL-MSGPCSWS PAGE FAULT WINDOWS 2K DESKJET WINDOWS 2000 DESKJET PRINTER DRIVERS CAUSE PC5250 PRINTER SESSIONS TO RETURN PCSWS_EXE PAGE FAULT ERROR When using new Deskjet printer drivers. PC5250 print sessions fail with PCSWS.EXE page fault errors. APAR = SE08188 CA400EXP-PC5250 FILE TRANSFER FAILS WITH 'APPLICATION ERROR' The PC5250 "Receive files from host" option will fail with a pcscm.exe application error when the Data Transfer setting is "No" on the General tab under Edit -> Preferences -> Transfer. A setting of "No" means that the Data Transfer function that ships with iSeries Access for Windows is not used. The transfer program that is included with PC5250 will be launched instead. APAR = SE08283 OSP-PAR V5R2M0 C2260 5722XE1 WITH PTF SI05853 ON MS WINDOWS Protection Fault exception code 0xc0000005 occurs when you access the display session printer setup, driver setup. APAR = SE08322 CA400EXP INCORECT FONTS FOR VIETNAMESE CAPS 5250 DISP EMU Vietnamese Capital fonts not correct : combination of keyed 1,2,3,4 with 8 will display as combination of key 1,2,3,4 with 5 in some font sizes. (ex 11x20) related PMR is 00070, B000, C852 APAR = SE08323 CA400EXP-PRINTEMUL-UNPRED PC5250 IS RESTORING DEFAULT PAGE After saving settings under file and page setup, PC5250 does not print the same the next time the PC5250 printer session is opened. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR 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 = SI05853 Build date = September 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE06839 CA400EXP-OLEDB-MSGCWBDB0052 OLEDB APP CANNOT FIND CONVERSION TBL APAR = SE07116 OSP-PAR CWBCO1004 MESSAGE RETURNED FOR LOCAL PORT LOOKUP OPTIONAL COMPONENTS ------------------- DIRECTORY UPDATE ---------------- No fixes. INCOMING REMOTE COMMAND ----------------------- No fixes. USER'S GUIDE ------------ No fixes. iSeries NAVIGATOR ----------------- APAR = SE05818 OSP-DB DATABASE NAVIGATOR 'ADD TO MAP' FUNCTION FAILS IF APAR = SE06093 OSP-AFP-PRT IMPORT OF OVERLAY ONLY WORKS FOR ENGLISH CA APAR = SE06804 CA400EXP-OPNAV-SECPOL-UNPRED ADD BUTTON DOES NOT SHOW UP APAR = SE06921 CA400EXP-BOOTP OPERATIONS NAVIGATOR LIMITS RANGE OF MAC ADDR APAR = SE07405 OSP PROBLEM WITH LOADING OF USER LIST WHEN WORKING WITH THE DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE06350 CA400EXP-DTRANSFER-INCORROUT ASCII TEXT WITH ZERO PAD DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE06149 CA400EXP-ODBC-INCORROUT INVALID LENGTH REPORTED ON CATALOG APAR = SE06414 CA400EXP-ODBC-MSGSQL0181 AND MSGCPF5035 RC18 ON ODBC TIMESTA APAR = SE06447 CA400EXP-ODBC-INCORROUT - ODBC FAILS TO RETURN FULL STORED PROCEDURE RESULT SET APAR = SE06802 CA400EXP-ODBC-INCORROUT RIGHT TRUNCATION ON CHAR DATA APAR = SE07095 CA400EXP-ODBC-INCORROUT PROBLEM IS RELATED TO EMBEDDED NULLS APAR = SE07172 CA400EXP-ODBC-INCORROUT NULL OUTPUT PARAMETERS RETURNING APAR = SE07583 CA400EXP-ODBC-INCORROUT - SQLProcedureColumns results incorrect OLE DB PROVIDER --------------- APAR = SE06106 CA400EXP-OLEDB-INCORROUT SINGLE PRECISION DEC INCORRECTLY INSERTED APAR = SE06588 CA400EXP-OLEDB-UNPRED EXECUTING A PREPARED CALL STATEMENT APAR = SE07584 CA400EXP-OLEDB-INCORROUT Better support for LOB bindings and SQL Server LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR = SE07260 CA400EXP-OPNAV Viewer Process Fails to end when error occurs TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR = SE03962 CA400EXP-DBCS PRINTED AS GARBAGE BY PRINTER SESSION APAR = SE04192 CA400EXP-SECURITY-MSG656 UNABLE TO CONNECT PC5250 WHEN PASSW APAR = SE05180 CA400EXP-TERMEMUL PCSCM.EXE-APPLICATION ERROR. THE INSTRUCTI APAR = SE06164 CA400EXP-TERMEMUL-MSGMCH0601 CSRINPONLY SPECIFIED IN DSPF APAR = SE06296 OSP-PAR PC5250 PROCESSING OF FIELD WITH WORD WRAP AFTER SI02 APAR = SE06586 CA400EXP-TERMEMUL-LOOP WHEN USING IWMP2000 TO SCAN DOCUMENTS APAR = SE06719 CA400EXP-PC5250-INCORROUT VIETNAMESE 5250 DISPLAY EMULN APAR = SE06869 CA400EXP-TERMEMUL-INCORROUT SESSION HANGS ON EXIT IF CHANGES APAR = SE06871 CA400EXP-TERMEMUL-INCORROUT UNABLE TO SPECIFY A SECURE WEBSI PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE04218 CA400EXP-TERMEMUL-INCORROUT CLIENT ACCESS EXPRESS V5R1M0 PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- Non-APAR fixes. --------------------------------- Service Pack Level = SI04684 Build date = June 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE03830 CA400WINOPT IBMDA400 PARAMETER BIDI TRANSFORM IGNORED APAR = SE03863 CA400WINOPT - ARABIC TRANSLATION LAM-ALEF CHARACTER NOT GET APAR = SE05333 OSP-INCORROUT UNABLE TO USE DBCS SPECIFIC CHARACTER ON MS AC APAR = SE06009 CA400EXP-OLEDB-INCORROUT IBMDA400 MIXES DATA IN BIDI APAR = SE06195 INCORROUT UNABLE TO USE THREE THAI CHARACTERS WITH MS ACCESS OPTIONAL COMPONENTS ------------------- DIRECTORY UPDATE ---------------- No fixes. INCOMING REMOTE COMMAND ----------------------- No fixes. USER'S GUIDE ------------ No fixes. iSeries NAVIGATOR ----------------- APAR = SE06470 OSP-PAR CLIENT ACCESS V450 OPERATIONS NAVIGATOR FATAL EXCEPT DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE04511 CA400EXP-DTRANSFER-UNPRED UPLOADING BIFF8 FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE06297 CA400EXP-ODBC-PERFM PARAMETER MARKER DESCRIPTION APAR = SE06298 CA400EXP-ODBC-INCORROUT - Miscellaneous ODBC problems APAR = SE06344 CA400EXP-ODBC-INCORROUT - Tool to update DSN information APAR = SE06546 CA400EXP-ODBC-MSGCWB0111 CHARACTER DATA RIGHT TRUNCATION WIT OLE DB PROVIDER --------------- APAR = SE06083 CA400EXP-OLEDB-INCORROUT NUMBER OF ROWS AFFECTED IS INCORRECT APAR = SE06468 CA400EXP-OLEDB-UNPRED Adjust block factor to 1 for LOBs APAR = SE06469 CA400EXP-OLEDB-INCORROUT IBMDA400 RETURNS EMPTY RESULT SET F LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- Non-APAR 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: 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 Install/Uninstall tab, click on IBM iSeries Access for Windows SI04484 item, and then click on the Add/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 which could expire when installing service packs over slower communication lines. The suggested way of installing the service pack in this case is to take one of the options below: 1) A setting has been added to 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"). STATUS: No status information is displayed while the files are copied. To determine if the transfers are progressing, look in the 'CA400CKV' temporary directory (For example C:\Windows\Temp\CA400CKV). You should see new files appear periodically. NOTES: "Copy install image to PC before installing" also works for upgrades to a new release, to avoid the time out over slower communication lines. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator can set the Install Service Pack policy restriction, or 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.