======================================================================== Readme File for AS/400 Client Access Express for Windows Service Packs 5722-XE1 V5R1M0 Cumulative Service Pack Level ------------- SI02795 ------------- (c) Copyright IBM Corporation 2000. All rights reserved. ======================================================================== IMPORTANT: If you are a Management Central user, it is very important that you review the information in APAR SE02365 if you have not previously installed service pack SI01907. There are PTFs for the 5722SS1 product that must be applied to your Central System and all endpoints in order to connect to V5R1M0 Management Central servers. If you already addressed this during the installation of SI01907, this action is not required for the installation of this service pack. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN AS/400 SYSTEM 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE 1.3 COMBINING THE SERVICE PACK WITH A CLIENT ACCESS EXPRESS INSTALLATION IMAGE 2.0 RESTRICTIONS 2.1 OPERATIONS NAVIGATOR 2.2 OPERATIONS CONSOLE 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI02795 (February 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 AS/400 SYSTEM --------------------------------------------- The following method would be used if you have received the Client Access Express service pack through the AS/400 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 AS/400 system with the LODPTF and APYPTF AS/400 commands, it can be installed on individual PC's with the "Check Service Level" or "Install Service Pack" shortcuts in the Client Access Express Service folder. Check Service Level, controlled by the Client Access 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 Express install image directory (\QIBM\ProdData\CA400\Express\Install\Image) on the AS/400. Any client that installs V5R1 Express (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 AS/400 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 Client Access Express 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 Client Access 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 Client Access Express 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 A CLIENT ACCESS EXPRESS INSTALLATION IMAGE ------------------------------------------------------------------------------- The following method could be used if you downloaded the service pack image from the iSeries Client Access web page location: http://www-1.ibm.com/servers/eserver/iseries/clientaccess/casp.htm With V5R1M0, the Client Access Express service pack PTFs are combined with the original Client Access Express installation image in QIBM\ProdData\Ca400\Express\Install\Image This means that a user can install (or upgrade) Client Access Express 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 copy the Client Access Express install image to another directory (for instance, on another server), you can use the PTFFORM.EXE download in the FTP directory to duplicate the function of the AS/400 PTF by following these steps: 1. Download PTFFORM.EXE 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 over a Client Access Express installation image, selecting the option to replace any existing file. Now you have combined this service pack level with the Client Access Express installation image, so that users can install Client Access Express 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. 2.0 RESTRICTIONS ----------------- 2.1 OPERATIONS NAVIGATOR ------------------------- 1) Due to technology incompatibilities, occasionally a window can be displayed behind other windows when running the Operations Navigator. If the Operations 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 Operations Navigator window, or another window on your desktop. 2) When using Operations Navigator on a Windows 95 PC: For Windows 95, at least the 'a' level service pack must be installed. To determine if you are running Windows 95 A or later, click Start, point to Settings, click Control Panel, then double-click System. If the version number reported is 4.00.950 A or later, no action is required. Your system already contains the appropriate fix. If you do need to install the update, it is available at http://www.microsoft.com/windows95/downloads/contents/ WURecommended/S_WUServicePacks/W95SvcPack1/Default.asp Windows/95 PCs with back level versions of winsock may experience the following runtime errors in Operations Navigator when using Visual Explain (under Database), Windows Administration (under Network), or Disk units (under Hardware Inventory in Configuration and Service): ExceptionInInitializerError NoClassDefFoundError If you experience the above errors, the solution is to update the winsock.dll to version 4.10.1656. This update can be found on the Microsoft download website at: http://www.microsoft.com/windows95/downloads/ Then take the link for "Windows Socket 2 Update" 2.2 OPERATIONS CONSOLE ----------------------- 1) Use of Windows/95 as an operating system for the Local Controlling System is NOT recommended. 2) 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. 3) The maximum number of concurrent active sessions via the PCOM 5250 emulator is 26. 4) If an automatic session re-connect to an OS/400 image on an iSeries or AS/400 server on 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 = SI02795 Build date = February 2002 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SE03045 OSP-PAR CLIENT ACCESS WITH V5R1 AND SI01907 HAS SHUTDOWN When shutting down Windows after installing V5R1 of Client Access with SI01907 users may get errors stating that CWBLMSRV needs to be ended before Windows can shut down. APAR = SE03411 OSP-PAR CWBLM0011 ERROR GIVEN ON FIRST LICENSE USAGE AFTER After starting the PC, the first time a licensed function is used the user gets a CWBLM0011 error. They can click cancel to the error message and then the function will work successfully. This error is found when using V5R1M0 of Client Access and SI01907. APAR = SE03520 CA400EXP-SECURITY-MSGCWBSY0011 PASSWORDS STARTING WITH A Within Operations Navigator, when connecting to the AS/400 with a USERID which has a password starting with a numeric character, unpredictable results can occur including the user profile becoming disabled. Initial connection usually succeeds when entering the numeric password but subsequent tasks may fail. Correction for APAR SE03520: ---------------------------- The all numeric user profile name can now be entered when signing on to a V5R1 system at password level 2. Circumvention for APAR SE03520: ------------------------------- Enter the full user profile name including the starting "Q". APAR = SE03552 OSP-MSGCWB0111 BINDING A ZERO LENGTH STRING AS A SQL_C_WCHAR Using MS Access 2000 and trying to update a zero length string generates the following error message. CWB0111 - A buffer passed to a system call is too small to hold return data (30200) Character data right truncation. (30125) APAR = SE03810 CA400EXP-OPNAV-INCORROUT WRONG HEBREW TRANSLATION IN IFS Hebrew text is incorrectly translated when using Operations Navigator to display an AS/400 data base file using IFS. The OEM CCSID of the PC was being used as the default client CCSID. On modern Windows PC's, ANSI should be used rather than OEM. A registry entry is being provided within NLS portion of the Client Access registry that will allow users to switch from OEM to ANSI as the default CCSID. It is important to note that existing files on the host that were created in OEM will remain in the OEM CCSID. Only newly created file will be affected by setting ANSI as the default. The default CCSID will remain OEM unless the following registry entry is created. For ease of turning the fix on/off, a .reg file containing the appropriate entry is recommended. The following is an example for "BSANSIDFLT.REG" to make ANSI the default CCSID, but you could also manipulate the registry by hand: [HKEY_LOCAL_MACHINE\SOFTWARE\IBM\Client Access\CurrentVersion\ File Systems] "BS Default Codepage"=dword:00000001 To revert to the OEM codepage, make a similar .reg file with a dword value of 00000000. APAR = SE03811 CA400EXP-CONNECTIONS-INCORROUT CWBCFG FAILS, MUST BE ADMIN Running cwbcfg.exe on a Windows NT/2000 PC fails, and the message "You must be a Windows NT administrator to run CWBCFG" is displayed. This occurs even when the user is an administrator on the PC. It also occurs if the user is an administrator within the domain, and the PC's Administrators group includes domain administration accounts. APAR = SE03812 CA400EXP-CONNECTIONS-INCORROUT CWBCFG SET IP ADDRESS LOOKUP When cwbcfg is run, it always sets the IP Address Lookup Frequency to Never. When an IP address is supplied by the user using the /ipaddr parameter, this is acceptable, and matches the behavior when the IP address is set from the connection properties within Operations Navigator. However, when no IP address is specified, setting this to Never is inappropriate, since the customer likely has a Domain Name Server or HOSTS file in place to perform the lookup of the IP address automatically. This PTF fixes the reported problem. When cwbcfg is run and an IP address is specified using the /ipaddr parameter, the IP Address Lookup Frequency will be set to Never. When no IP address is specified, the IP Address Lookup Frequency will be left unchanged if the connection already exists, and will be set to the default value if the connection is new. At the time this fix is released, the default value is Always. APAR = SE03830 CA400WINOPT IBMDA400 PARAMETER BIDI TRANSFORM IGNORED R510 OLE DB provider IBMDA400 ignores BIDI Transform parameter. APAR = SE03863 CA400WINOPT - ARABIC TRANSLATION LAM-ALEF CHARACTER NOT GET Lam Alef characters are not handled as expected. In testing we have found the following results: Client Access Express configured as follows: No Translation DLL. Do not translate CCSID 65535. Bidi On: - Database stores okay. - Lam Alef stored okay. - In application Lam Alef becomes Dhad. Bidi Off: - Letters are flipped in the database. - Lam Alef appears as characters not joined. - Letters in application ok and the Lam Alef is ok. Client Access Express configured as follows: No Translation DLL. Translate CCSID 65535. Bidi On: - Database stores okay. - Lam Alef stored okay. - In application Lam Alef becomes Dhad. Bidi Off: - Database stores okay, and Lam Alef stored okay. - Letters are flipped in the database. - Lam Alef appears as characters not joined. Client Access Express configured as follows: Translation DLL. Translate CCSID 65535. Bidi On: - In the database Lam Alef becomes a "box". - The rest of the characters are flipped. - In the application Lam Alef becomes Dhad. Bidi Off: - Database stores okay, and Lam Alef stored okay. - Letters in application okay, and the Lam Alef is okay. Client Access configured as follows: No Translation DLL. Do not translate CCSID 65535. Bidi On: - Letters are flipped in the database. - Lam Alef appears as characters not joined. - Letters in application ok, and the Lam Alef is ok. Bidi Off: - Same as above. Client Access configured as follows: Translation DLL. Translate CCSID 65535. Bidi On: - Lam Alef converts to Dhad in the application. - Letters are flipped in the database. - Lam Alef appears as characters not joined. Bidi Off: - Same as above. Client Access configured as follows: No Translation DLL. Do not translate CCSID 65535. Bidi On: - Lam Alef saved in application correctly. - Letters are flipped in the database. - Lam Alef appears as two characters not joined. Bidi Off: - Same as above. EXPRESS OPTIONAL COMPONENTS --------------------------- DIRECTORY UPDATE ---------------- No fixes. INCOMING REMOTE COMMAND ----------------------- APAR = SE02529 CA400EXP-INRMTCMD-INCORROUT RUNRMTCMD BAD SPECIAL CHARACTERS When RUNRMTCMD is run and output from the command should contain special characters, such as letters with accents, the special characters are not displayed correctly in the spool file. The spots these characters should appear contain either blanks or incorrect characters. For example, when a directory such as c:\ contains files named using special characters, and the following is run on the iSeries server: RUNRMTCMD CMD('dir c:\') ...(other parameters) the directory listing will be complete but the filenames containing special characters will be incorrect. Another example is the following: 1) Create a batch file on the PC called echome.bat, containing the following lines: @echo off echo This is a test, here is your input: echo %1 2) Execute the batch file using RUNRMTCMD, as follows: RUNRMTCMD CMD('echome special-input') ... where special-input is text containing one or more special characters. In this case, the echoed input as stored in the spool file on the iSeries server will contain incorrect characters where the special characters should be. MAPI ---- No fixes. EXPRESS ONLINE USER'S GUIDE --------------------------- No fixes. AS/400 OPERATIONS NAVIGATOR --------------------------- The B2B Activity Monitor is a new function that will be added to Operations Navigator when this service pack is installed. This function is a companion with Connect for iSeries version 1.1. If you have that product installed, you will be able to use Operations Navigator to monitor the B2B activity for your iSeries systems. Further details are available in the Connect documentation at http://www.ibm.com/eserver/iseries/sftsol/b2b.htm and the Management Central documentation at http://www.ibm.com/eserver/iseries/sftsol/mgmtcentral.htm IMPORTANT: For Management Central users, there are two required PTFs that must be installed on an iSeries V5R1M0 server: 5722SS1 SI00721 5722SS1 SI00722 It is required that a Client Access Express user apply this service pack (SI02795) before trying to connect to the Management Central server on an iSeries on which the above mentioned PTFs are applied. If there is a mismatch, errors will occur. Additional requirements for your iSeries V5R1M0 server relating to Management Central are outlined in APAR SE02365 as well. If you already addressed this during the installation of SI01907, this action is not required for the installation of this service pack. OPERATIONS NAVIGATOR BASE SUPPORT --------------------------------- APAR = SE02365 CA400EXP-OPNAV MGMT CENTRAL JAVA PORT REDUCTION/SSL This enhancement will allow you to turn on Secure Sockets Layer (SSL) for Management Central Job Monitors, Message Monitors, and System Values functions in V5R1M0. Prior to this service pack, these functions are disabled if you have the Management Central Properties set to use SSL. If you have installed this service pack and are intending to use Management Central, you will need to apply 5 co-requisite PTFs to your Central System and all endpoints. You must also install the service pack on any PCs you want to use Management Central from. If you don't apply these PTFs, you will not be able to connect to any V5R1M0 Management Central servers. (Connections to V4R5M0 or earlier will not be affected). The 5 PTFs are for the 5722SS1 product and their numbers are: SI01375 SI01376 SI01377 SI01378 SI01838 Additionally, if you would like to use SSL with Management Central, you must do some configuration with Application Administration. In Operations Navigator, under your local connections, run Application Administration for a system you are going to use SSL on. On the Host Applications tab, expand Digital Certificate Manager (DCM), then highlight System Certificate Store. Click on the Customize button. On the Customize Access window, expand All Users under the Users and Groups section. Select user QYPSJSVR, then add it to the Access Allowed section. Click OK on the Customize window, then click OK on the Application Administration window. Repeat this for every system you are going to use with SSL for Management Central, central system and endpoints. APAR = SE02797 CA400EXP-OPNAV-PERFM CLICKING ON BY LOCATION UNDER HARDWARE Clicking on BY LOCATION under the following path appears to hang Operations Navigator: Configuration and Service, then Hardware Inventory, then Disk Units. Sometimes the screen does come back after an hour or two. This occurs only on systems with a lot of disk units. The more disk units, the slower the response. APAR = SE03288 CA400EXP-OPNAV-FILESYS-INCORROUT NOT ABLE TO EXPAND A When an IFS folder is named "Root", Operations Navigator treats the folder as the system root. This means that when it is expanded, it will fail to show its true contents and will keep expanding indefinitely. Deleting it will cause an attempt to delete the system root. Sharing it will share the system root. APAR = SE03836 OSP-MSGCPD0020 MSGCPD0014 SETTING PERMISSIONS VIA OPNAV Users may receive message CPD0020 and CPD0014 when changing permissions using Operations Navigator. This happens when the file name includes a single apostrophe character (') within in Root or IFS file system. To reproduce the problem, create a text file (abc'def.txt) and copy it to Root (or subdirectory inside Root) IFS. Then, using Operations Navigator, right click this file and choose "Permissions", attempt to change "(Public) authority and then click "Apply". Circumvention for APAR SE03836: ------------------------------- A circumvention to the problem is using the CHGAUT command via 5250 emulation. So to give the user profile Fred read data authority to /home/test/bed'rock, the following command can be used. CHGAUT OBJ('"/home/test/bed''rock"') USER(fred) DTAAUT(*R) APAR = SE04017 CA400EXP-OPNAV FIX MC REGISTRY WRAPPER CLASS ON WIN XP On Windows XP, some Management Central functions which use the registry to retrieve previously stored information about a user's settings or previous actions are broken. This results in windows not remembering how the user last interacted with them, or settings reverting back to their defaults. BASIC OPERATIONS ---------------- No fixes. WORK MANAGEMENT -------------- No fixes. CONFIGURATION AND SERVICE ------------------------- Non-APAR fixes. NETWORK ------- APAR = SE04016 CA400EXP-OPNAV PACKET RULES DON'T LOAD ON CORRECT LINENAME When loading Packet Rules in Operations Navigator, if 2 lines exist with names where one name is a subset of the other (i.e. TRNLINE, TRNLINE2), it is possible that the following may occur: If TRNLINE2 is selected to load rule on, it is possible that the rules will actually be loaded on TRNLINE. APAR = SE04018 CA400EXP-OPNAV SMTP PROPERTY PAGE FIXES Fixes the following SMTP Operations Navigator problems: 1) In the Italian version of Operations Navigator a problem exists when Properties of the SMTP TCP/IP server are displayed, the OK button does not function therefore you cannot save any property changes. 2) In all versions of Operations Navigator on the Relay Restrictions page of SMTP Properties if an address which has 4 complete octets, eg. 123.123.123.123 is added to the "Addresses allowed to relay" table and saved, subsequent displays of this property page show this address as having one less integer, eg. 123.123.123.12 This address is displayed incorrectly however it was saved correctly on the server. APAR = SE04019 CA400EXP-OPNAV PPP VALIDATION LIST 99 ENTRY LIMIT In Operations Navigator under Remote Access Services, a validation list can be created with more than 99 entries. Upon subsequent display of the validation list, only the first 99 entries will be shown and only these first 99 entries can be edited. Changing any entries beyond 99 is not possible. SECURITY -------- No fixes. USERS AND GROUPS ---------------- No fixes. DATABASE -------- Non-APAR fixes. FILE SYSTEMS ------------ No fixes. BACKUP ------ No fixes. APPLICATION DEVELOPMENT ----------------------- No fixes. COMMANDS -------- No fixes. PACKAGES AND PRODUCTS --------------------- No fixes. MONITORS -------- No fixes. LOGICAL SYSTEMS --------------- No fixes. AFP MANAGER ----------- No fixes. APPLICATION ADMINISTRATION -------------------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE02766 CA400EXP-DTRANSFER-MSGSQL0010 DATA TRANSFER WHERE CLAUSE Using Data Transfer From AS/400 with a WHERE clause of more than 1 Kb in length and a JOIN condition specified may produce unpredictable results. The likely outcome will be a SQL00010 message from the AS/400 server indicating the syntax of the SQL statement to process is incorrect. APAR = SE02833 CA400EXP-DTRANSFER-INCORROUT DATA TRANSFER UPLOAD WITH ASCII When using Client Access Express Data Transfer to upload an ASCII file containing two carriage returns and one line feed (CRCRLF) at the end of each record, the file is uploaded incorrectly. The resulting AS/400 file contains a line feed character on the beginning of each record after the first. Data Transfer should be including the first carriage return in the record data and treating the preceding CRLF as the end of record. APAR = SE03076 CA400EXP-DTRANSFER-MSGCWBTF0008 CREATE WIZARD LOSES EXPONENT The file creation wizard in the Express client does not correctly interpret numeric values which are stored in an exponential format (for example 1.23E+10 or 1.2E+5). The error only occurs for numbers which would not have a decimal portion if expanded such as the examples above. (A value such as 1.234E+2 when expanded would be 123.4 and would not fail.) The typical message a user would receive when trying to perform a transfer to the file created incorrectly by the file creation wizard would be a CWBTF0008. APAR = SE03267 CA400EXP-DTRANSFER-INCORROUT LEADING ZEROS ARE NOT HANDLED Client Access Express Data Transfer From AS/400, release V5R1, is incorrectly handling leading zeros when 'Pad numeric fields with leading zeros' is selected for ASCII text output. A zero is being placed in the sign field and when downloading a negative number, zeros may be placed in front of the negative sign. APAR = SE03580 CA400EXP-DTRANSFER-INCORROUT DBCS CELLS INCORRECT IN BIFF8 When transferring graphic DBCS data to a BIFF8 file with Data Transfer from AS/400 the Excel file may contain extra characters at the end of each cell. These characters should not be included in the cell data. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR = SE02898 CA400EXP CWBTF0084 EXCEL 97 ADD-IN FAILS AFTER SI01907 After applying Client Access Express R510 service pack SI01907 to a PC running with MS Excel 97 (includes SR1 and SR2 releases of Excel 97) installed, the Data Transfer Add-In function stops working. Attempts to use the Data Transfer To AS/400 Add-in within MS Excel 97 fail with message CWBTF0084 - "This version of Excel is not supported." APAR = SE03439 CA400EXP-DTRANSFER-INCORROUT EXCEL XP DATAXFER ADD-IN STOPS The Client Access Express (version V5R1) Data Transfer add-in for Excel, running on Excel XP, stops at 16,385 records. With the XP version of Excel it should be able to download 65,536 records. APAR = SE03567 CA400EXP-DTRANSFER-INCORROUT ADDIN FAILS TO UPLOAD JAPANESE The Transfer Data to AS/400 Add-in for Excel does not transfer some Japanese characters correctly to the AS/400. These characters are transferred as a substitution character "?" instead of the correct character. APAR = SE03595 CA400EXP-DTRANSFER-INCORROUT 5722XE1 DATA TRANSFER EXCEL ADD A problem was encountered when scanning a file using the V5R1M0 data transfer Microsoft Excel add-in upload function. A record in the file with a currency field did not contain any data, but contained a '-'. When the add-in scan reached the '-' in this field, it failed with message: This program has performed an illegal operation and will be shut down. EXCEL caused an invalid page fault in module MSVCRT.DLL at 015f:78001648. The data transfer upload wizard in the 'Data Transfer to AS/400' GUI handles the data with the '-' and uploads the field as zeros. ODBC ---- APAR = SE02678 CA400EXP-ODBC-MSGSQL0180 TIMESTAMP ESCAPE SEQUENCE CONVERTED An application is using the ODBC timestamp escape sequence to insert a value into a TIMESTAMP field on the OS/400. INSERT INTO F1 (TS1) VALUES ( {ts '2001-01-01 12:00:00.000000'}) On previous releases, this worked. However, this is now failing. It appears that the timestamp literal value, which is correct according to ODBC specification, is not converted to a timestamp value of correct format. The resulting error message is SQL0180 - Syntax of Date, Time, or Timestamp value is incorrect. APAR = SE02794 CA400EXP-ODBC-INCORROUT CREATE DSN USING LOWER LETTER FOR When creating a DSN (e.g. System DSN) there is an option to specify a default library name on the Server tab. Specifying a name in lowercase characters causes later problems in the GUI. If the DSN is later configured again, the default library name shows up as garbage characters. Also, the driver doesn't handle # in the default library name correctly. Circumvention for APAR SE02794: ------------------------------- Specify an uppercase name on the GUI. APAR = SE02802 CA400EXP-ODBC-UNPRED FAILOVER FAILURE WITH CA EXPRESS V5R1 Using CA Express V5R1 with the first Service Pack SI01037, we are testing fail over support with Vision Solutions HA software. We are experiencing a similar issue to that reported when doing fail over testing with SA90927 on CA Express V4R4. The problem is that the driver does not report communication link failures correctly during the SQLExecute call. The driver should immediately report communication link failures as the point it identifies them. APAR = SE02837 CA400EXP-ODBC-MSG3265 SQLPROCEDURECOLUMNS, DRDA, OTHER FIXES Multiple problems need to be fixed: 1: SQLProcedureColumns is used by many applications to determine the direction of stored procedure parameters. The ODBC driver is returning an ordinal of 1 for all the parameters. This causes problems with applications that use this information. For example a stored procedure call using Microsoft ActiveX Data Objects (ADO) and the adCmdStoredProc syntax will return one of the following error messages: 3265 Item cannot be found in the collection corresponding to the requested name or ordinal. 3001 Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. SQLProcedureColumns is also returning a "BUFFER_LENGTH" value for numeric data types that is 1 byte too large. The default C data type is character so this value should be display size -without an extra byte for null. 2. DRDA connections do not work correctly after the CONNECT statement has been issued. Errors about parameter not being valid are reported. 3. Setting SQL_DEFAULT_PARAM should result in an error on the execute call because default parameters are not supported. 4. The PKG keyword is not being honored when specified in the SQLDriverConnect connection string when User or System DSNs are being used. 5. Backwards fetches that result in cursors before the first row sometimes return a rowset of data starting from the first row. According to the specification the driver should instead return a return code of SQL_NO_DATA. 6. The DSN option for lazy close can cause locking problems when the isolation level is repeatable read or serializable. Also, whenever a cursor is opened for update the driver should not lazy close the cursor. 7. Specifying SQL_C_DEFAULT when binding a binary column for a fetch should always lead to a default type of SQL_C_BINARY. The driver incorrectly returned SQL_C_CHAR which led to a different conversion than was expected. 8. The driver mishandles NULL data in block inserts. APAR = SE03121 CA400EXP-ODBC-INCORROUT TRANSACTION ISOLATION LEVEL SET The isolation level required by OS/400 V5R1 host to support an MTS (Microsoft Transaction Server) transaction can be anything but *NONE. An MTS transaction is set up with any isolation level other than none. However the jobs behave as though they are set to *NONE. Uncommitted data can be read, leading to possible corruption of data. This also leads to failure to rollback data (as it has already been committed), but the application receives no errors on the rollback. The rollback has no effect and all work is committed. There are no errors reported. APAR = SE03217 CA400EXP-ODBC-LOOP LOOP APPENDING ROWS USING ODBC Calling SQLGetData a second time on a fixed-length data type the driver incorrectly returns the data a 2nd time. The driver should return SQL_NO_DATA to indicate that there is no more data left to be fetched for that particular row and column. In this case, this bug caused the application to spin in an infinite loop because it never saw the SQL_NO_DATA return code. APAR = SE03270 CA400EXP-ODBC-INCORROUT GRAPHIC TYPE DATA IS NOT HANDLED ENV : OS/400 R510 C1254510---CA/400 R510 SI01907 The CA ODBC driver does not work correctly with VB applications using RDO and accessing graphic (DBCS) fields. The problem has to do with a bug in how RDO figures out the length of SQL_CHAR fields. RDO calls SQLColAttribute with the SQL_COLUMN_LENGTH option to get the length of the field. If the driver returns the character count RDO does not allocate a big enough buffer to hold the data. To allow RDO applications to access graphic data, the driver changed the behavior of the GRAPHIC keyword to also return the byte length with the SQL_COLUMN_LENGTH option when GRAPHIC is 2 or 3. APAR = SE03278 CA400EXP-ODBC STORE PROCEDURE CALLED VIA ODBC IS NOT RETURNI After upgrading to R510 ODBC, the application is not receiving information about stored procedure columns. An ODBC trace shows that the Client Access ODBC driver returns SQL_ERROR to a SQLProcedureColumns call. The error text is DIAG [S1009] [IBM][ Client Access Express ODBC Driver (32-bit)] Invalid argument value. (30031) The application ignored the error and assumed all parameters were INPUT. R510 ODBC is not allowing a NULL POINTER for column name unless "Enable search patterns" is checked. For ODBC version 3.x applications the driver is treating disable search patterns as if the statement attribute for SQL_ATTR_METADATA_ID was set to SQL_TRUE. This is more restrictive then in earlier ODBC drivers where the driver would only ignore search pattern characters such as underscore (_) and percent (%). Note, this problem exists for other catalog APIs other than SQLProcedureColumns. SQLTables, SQLColumns, ... also may experience this problem if SearchPattern is unchecked (or set to 0). Correction for APAR SE03278: ---------------------------- With this change, the SearchPattern keyword's functionality is changed to just affect how the driver handles the _ and % wildcards. The statement attribute for SQL_ATTR_METADATA_ID will be left unchanged by the driver. If the SearchPattern option is checked (or set to 1) the driver will treat wildcards in the input strings as wildcards. If unchecked (or set to 0) the driver will treat _ and % in the name as actual characters. Circumvention for APAR SE03278: ------------------------------- In some cases, setting the SearchPattern to 1 (or checking it on the ODBC DSN setup GUI) will give the desired behavior. This may not work in all cases, though, as this will lead to all _ and % 's being treated as wildcards. APAR = SE03352 CA400EXP-ODBC-INCORROUT SQLCOLATTRIBUTES FOR SQL_DESC_COUNT Calling the SQLColAttribute API and specifying the option SQL_DESC_COUNT should retrieve the number of columns found in the result set of statement. The number returned is a large negative number. This also fails when using the deprecated API SQLColAttributes API with the SQL_COLUMN_COUNT option. APAR = SE03389 CA400EXP-ODBC-INCORROUT SQLEXTENDEDFETCH AND SQLFETCHSCROLL When scrolling in the client side rowset buffer SQLExtendedFetch and SQLFetchScroll will run with SQL_FETCH_NEXT unless SQL_FETCH_ABSOLUTE or SQL_FETCH_RELATIVE are used. APAR = SE03417 CA400EXP-ODBC-INCORROUT COLUMNWISE BINDING USED IN CONJUNCTI Applications using a columnwise binding with the SQLExtendedFetch API, such as Powerbuilder, may incorrectly provide a BufferLength size too large for integers (always 4 bytes). This leads to incorrect data being returned to the application. Circumvention for APAR SE03417: ------------------------------- To avoid this problem the data can be binded so that the BufferLength argument is set to the size of the fixed length data type. APAR = SE03561 CA400EXP-ODBC-UNPRED MS VB RDO APP. REPORTS DIAG³S1003Û MS VB RDO app. reports DIAG[S1003]"Client Access Express ODBC Driver (32-Bit)program argument out of range" when selecting DATE fields. V4R5 and earlier versions of Express work fine with this same app. V5R1 Express ODBC fails with the above. SQLBindParameter, SQLGetData and SQLBindCol may fail with SQL_ERROR when the C data type is SQL_C_DATE (=9), SQL_C_TIME (=10) or SQL_C_TIMESTAMP (=11). The error message is: DIAG [S1003] [IBM][Client Access Express ODBC Driver (32-bit)]Program type argument out of range. These data types are not valid for ODBC 3.x drivers such as R510 and later of Client Access Express ODBC. The Microsoft-supplied ODBC driver manager should map these types to their ODBC 3.x equivalent. The problem is caused by the Microsoft ODBC cursor library. The ODBC cursor library is calling directly to the CAE ODBC driver with the 2.0 data types. The ODBC cursor library is used by components such as RDO when the application requests a client side static or keyset cursor. Note that ADO does not use the ODBC cursor library and is not affected. The driver now recognizes and does the mapping of the old date, time, and timestamp defines to the new defined values. The SQLBindParameter and SQLBindCol APIs were fixed to handle this. APAR = SE03704 CA400EXP-ODBC-INCORROUT THE ODBC DRIVER IS ALWAYS REPORTING The ODBC driver is always reporting a row count of 0 rows for stored procedure result sets. Stored procedure result sets are always forward only cursors so the value should be -1 (number of rows not available). Some applications will not attempt to fetch any data from stored procedure result sets when the row count is zero. APAR = SA93212 CA400EXP-ODBC-INCORROUT SQL_MAX_LENGTH SQLSETSTMTOPTION When the SQLSetStmtOption option for SQL_MAX_LENGTH is set, the driver mishandles returning character data. Several different problems were discovered depending on the value set and the size of the data returned. For example, if the maximum value is used, 2147483647, we were only able to retrieve 200 valid characters out of 453 from a VARCHAR field; however, the size returned was the correct size for the actual amount of data (453 characters). If the amount of data is greater than the value set by SQL_MAX_LENGTH, then the data was truncated but it wasn't null terminated; however, the length returned on SQLGetData was correct and the return code was set correctly to indicate that null termination wasn't performed. When setting the maximum length to a value less than the maximum value allowed but greater than the amount of actual data the results of an SQLGetData were incorrect. All of the data was returned but the value indicating the size of the returned data was incorrect. Instead of getting the size of the returned data, we got the size of the SQL_MAX_LENGTH. APAR = SE03813 CA400EXP-ODBC-INCORROUT GRAPHIC TYPE DATA IS TRUNCATED WHEN When using the CA ODBC driver with ADO and MSDASQL OLEDB provider for VB SQL applications, Graphic type data is not handled as expected. The last half of data in the field is truncated. For example, for the DBCS Graphic data which was defined as 20G (40bytes) on AS/400, the first 10 DBCS characters (20bytes) only is displayed on the application. A new connection string keyword has been created to handle this problem. The keyword is GRAPHIC. For users that don't have control of the application's connection string the GRAPHIC keyword needs to manually entered into the data source that is in use. The GRAPHIC keyword affects how information about Double-Byte Character Set (DBCS) graphic data types are reported by the driver. The DB2 UDB graphic data types that are affected by this keyword are GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC, and DBCLOB. Note, graphic fields tagged with a CCSID of 13488 (Unicode) are not affected by this. Setting this keyword affects two things: - whether graphic fields have their lengths reported as a character count or byte count through the SQLDescribeCol API. - whether graphic fields are reported as supported data types in the SQLGetTypeInfo result set. Notes: The V4R5 fix for this problem only supports the reporting of the lengths. It does not affect how the graphic data types are returned through the SQLGetTypeInfo API. Possible values for the GRAPHIC keyword are: 0 = report character count, report as not supported (default) 1 = report character count, report as supported 2 = report byte count, report as not supported 3 = report byte count, report as supported Note: For the problem reported in this APAR with ADO the recommended setting is 2. For User and System data sources: Go to the Start menu on your PC and choose the 'Run...' option. Type in regedit and click OK. Navigate in the left panel to either HKEY_CURRENT_USER\Software\ODBC\ODBC.INI or HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI depending on if your data sources is a User or System data source. Find your data source listed in the list and click on it. In the right panel add a new String Value for GRAPHIC. Enter in the value listed above that you want to be used. For File data sources: Open the file that contains the data source information using a word editor. Add a new row that contains: GRAPHIC=value where value is one of the values listed above. APAR = SE03814 CA400EXP-ODBC-PERFM - PERFORMANCE WITH SCROLLABLE CURSORS The driver indicates the scrollability of a cursor to the server when a cursor is opened. The server does not always honor this. If the driver sends this information when the SQL statement to generate the result set is prepared it will be honored and can lead to improved performance. APAR = SE03815 CA400EXP-ODBC-INCORROUT - BLOCK INSERT PROBLEMS The driver incorrectly returns SQL_ERROR when a block insert fails. The driver should return SQL_SUCCESS_WITH_INFO and fill in the SQL_ATTR_PARAM_STATUS_PTR array. APAR = SE03816 OSP-DB-INCORROUT CORRUPT DATA WITH LOCAL PACKAGE CACHE There are several problems related to local package caching. One problem occurs when accessing LOB or DBCS GRAPHIC fields. The ODBC application may see this problem through an error message, a crash, or incorrect lengths of data being reported. Also, the driver does not correctly set the internal state of a statement to prepared after a statement has been prepared. This results in SQLDescribeCol reporting an error that the statement is not prepared. APAR = SE03817 CA400EXP-ODBC-INCORROUT CRASH WHEN BIND_OFFSET_PTR SET When an application binds parameters using the statement attribute SQL_ATTR_PARAM_BIND_OFFSET_PTR with a non-zero value Client Access ODBC may incorrectly calculate the offset to the data causing a fault. The problem affects ADO applications that use client side cursors and perform update, insert or delete operations. ADO will report the access violation as run-time error '-2147467259 (80004005)' Data provider or other service returned an E_FAIL status. The driver also mishandles if an application sets the descriptor fields for SQL_DESC_OCTET_LENGTH_PTR and SQL_DESC_INDICATOR_PTR. The driver incorrectly assumes that the two pointers always point to the same location. In the 2.x specification there was only one pointer that handled both the length and indication of if the data was NULL or not. OLE DB PROVIDER --------------- IMPORTANT: If you have the OLE DB component of Client Access Express installed on a Windows NT or Windows 2000 PC, and this is the first V5R1M0 service pack installed on this PC, you should make sure that an Administrator performs the initial reboot after the service pack install. The DLL self-registration that occurs during the reboot requires Administrator authority. In the event that this recommendation is not followed, you can self-register the DLL by running the following command: regsvr32 "C:\Program Files\IBM\Client Access\cwbzzodb.dll" (where the actual Client Access Express install directory is substituted into this command) APAR = SE03328 CA400EXP-OLEDB-INCORROUT ERRORS WITH OLEDB AND SQL SERVER Several errors occur when using the Client Access OLEDB provider (IBMDA400) with Microsoft SQL Server 2000 and SQL Server 7.0. Accessing the table listing for a linked server will cause the SQL Server manager to hang. Communication trace and cwbzztrc show the hang occurs after returning the first record. Further problems occur when using SQL Server to perform queries against a linked server. In some cases, a query will return 0 rows of data, even though there are valid rows that could be returned. A final problem occurs when using SQL Server's Data Transformation Services (DTS) to copy data from the OLEDB provider to SQL Server. Examination of cwbzztrc output shows "PROVIDEROWNED memory not allowed for this column." Circumvention for APAR SE03328: ------------------------------- You may be able to circumvent the DTS problem by specifying to use 'SQL' instead of opening a 'Table' in DTS. APAR = SE03505 CA400EXP-OLEDB-MSGCWBZZ5014 ASCII TO ZONED CONVERSION, VALUE Customer has a ZONED(2,2) field that he is updating through his Visual Basic program using IBMDA400. When he attempts to set the value using two digits, for instance .11, message CWBZZ5014 is reported. The same problem would happen with any field whose precision and scale are the same number. Circumvention for APAR SE03505: ------------------------------- Define the field as ZONED(3,2). APAR = SE03818 CA400EXP-DBACCESS-OLEDB-MSGCWBZZ5014 DATA CONVERSION ERROR When PC Regional Settings are configured as non-English (in this case they were Spanish(Traditional Sort)), a Visual Basic application fails with CWBZZ5014 - "Value of parameter xxx could not be converted to the host data type". This happens after an SQL statement (eg. SELECT * FROM QIWS.QCUSTCDT) is executed using ADO. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR = SE03821 QIWA-PRINT-INCORROUT OP NAV SPOOLED FILE VIEWING FORM DEFS When attempting to view an iSeries spooled file that has an externally specified form definition, the form definition is not used. AS/400 JAVA TOOLBOX ------------------- This Client Access Express service pack will also install the equivalent of 5722JC1 product PTF SI02679. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE02217 CA400EXP PC5250 IME_AUTO_START_Y FUNCTION INCORROUT The function which is related to IME has incorrout since SF65345. In IME_AUTO_START=Y status, FEP mode must be HIRAGANA DBCS on J and G type field. When cursor is located at 1st first which is J or G type, FEP mode is HIRAGANA SBCS. APAR = SE02462 CA400EXP-PRINTEMUL-UNPRED MANUFACTURERTYPE IN PC5250 PRINTER When configuring a PC5250 printer emulation session to transform print data to ASCII on the AS/400, the session will fail to connect for some printer models such as the IBM 4247. In the PC5250 printer session file, the ManufacturerType has been truncated to ten characters. APAR = SE02687 OSP-INCORROUT CUT AND PASTE INTO SEU OR EDTTXT FROM CA400EXP When using Cut/Paste feature of CAE R510 at SI01037 service pack with modifications documented in II12920 made to the .ws file, blank lines are removed when copied into SEU or EDTTXT from Microsoft Word. APAR = SE02752 CA400EXP-PC5250 WIN2K PREFORMANCE DEGRADATION ON WS DURING Performance of keystroke and command execution is degraded on Windows 2000 when printing on LPT1 (parallel port connection). APAR = SE02851 OSP-PAR HOTSPOTS SETTING ARE NOT RETAINED WHEN MULTIPLE If hotspots are configured and saved, then subsequent sessions that are opened from that configuration do not use the hotspot settings. APAR = SE02852 CA400EXP-PC5250 PROBLEMS WITH MULTI LINE PASTE Trying to paste multiple lines into Sequel's CHGVIEW screen at the 27x132 setting only pastes the first line of the copied item. APAR = SE02901 CA400EXP-TERMEMUL-INCORROUT AFTER INSTALLING SI01907, CURSO After installing SI01907, the cursor does not return to correct position within a subfile. APAR = SE03448 CA400EXP-TERMEMUL-PERFM PC5250 SLOW REFRESH SINCE 3D BUTTONS When using PC5250 display emulation with 3-D buttons in Execute URL enabled via Edit->Preferences->Hotspots, screen refresh is noticeably slower. APAR = SE03566 CA400EXP PC5250 INVALID FONT IMAGE Using Japanese CA Express R510, when the Host code-page of the display emulation session is changed, an invalid font image is used in the session. It seems the character data is for DBCS, but the font image is for SBCS only. The problem can be solved by selecting any DBCS font file, but this should not be necessary. APAR = SE03671 CA400EXP-TERMEMUL DDS ATTRIBUTE PROTECT DOES NOT WORK IF If an indicator is used with the DDS DSPATR(PR) to protect the field only when the indicator is ON, the indicator is ignored. This works correctly on a green screen but fails with PC5250. APAR = SE03686 OSP-PAR COPY AND PASTE FROM PC5250 TO EXCEL/123 WITH TRAILIN Copying a numeric value with a trailing negative sign from a PC5250 screen and pasting it to a spreadsheet does not work correctly. The characters are all pasted, but they are not pasted as numeric data, so the spreadsheet cannot perform any calculations on the data. APAR = SE03698 CA400EXP-TERMEMUL-UNPRED USING TAB KEY HANGS SESSION After applying SF65345 and using PC5250 emulation, use of the Tab key to move between entry fields in an OEM application causes the session to hang. APAR = SE03708 CA400EXP-TERMEMUL-INCORROUT SETTING LETTER GOTHIC BOLD FONT PC5250 printer emulation session saved with "font for AS400 print file" parameter defined to "Letter Gothic Bold" will result in Window popup error while attempting to start the saved session profile. APAR = SE03709 CA400EXP-TERMEMUL INCORROUT DANISH NATIVE CHARS CANNOT Cannot enter Danish native letters in alphabetical fields in Display screens (which are described by an 'X') in a Client Access Express PC5250 session. APAR = SE03719 CA400EXP-TERMEMUL-INCORROUT STRPCO AND STRPCCMD FAIL TO STRPCO and STRPCCMD are called within a CL program to transfer a file from the network to the AS/400-iSeries, but they fail to complete before the CL program continues processing and the program fails. When the steps within the CL program are performed manually, no failure occurs. Before SF65345 was installed, the CL program would complete successfully. This PTF fixes the reported problem. Further detail describing how STRPCO and STRPCCMD are designed to work is available in Information APAR II13099. APAR = SE03720 CA400EXP-PC5250 INCORRECT IME CONVERSION IME conversion is not working properly. APAR = SE03744 CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE FUNCTION FAILS IF Copy and paste function fails if working on S/36 DSPF file creation. APAR = SE03747 CA400WINOPT-TERMEMUL-INCORROUT VB SCRIPT MACRO TIMEOUT Using PC5250 emulation session and the VB script macro function results in performance degradation. APAR = SE03795 CA400EXP-TERMEMUL-INCORROUT AUTO SIGNON DOES NOT WORK PROPER Running CA400EXP R450 SF SF65345 and R510 SI01907, bypass signon is not working if the password contains only numeric characters. APAR = SE03822 CA400EXP-TERMEMUL-INCORROUT PC5250 SCROLLBAR DOESN'T WORK AS Customer developed a DSPF with scroll bars to work with a subfile. The scroll bar is not working as it should. You can not use the bar with your mouse to change the viewable part of the subfile by sliding the bar, however, after you have moved the cursor in the DSPF (e.g. pressing any key, or pressing the arrows in the scroll bar) you are able to use the scroll bar as expected. APAR = SE03823 CA400EXP-TERMEMUL-INCORROUT PC5250 SCROLL BAR NOT DRAGABLE The scroll bar can't be used until you move the cursor in the display file by pressing any key or pressing the arrows in the scroll bar. After doing this, you are able to use the scroll bar, but after scrolling down the problem repeats. APAR = SE03824 CA400EXP-TERMEMUL-PERFM MACRO FAILS TO PAUSE WHEN IT REACHES Macro fails to pause when it reaches {rpause} in macro script after applying sf65345. APAR = SE03825 OSP-PAR NEW WINDOWS 2000 DESKJET PRINTER DRIVERS CAUSE PC525 When using the dj657en.exe and dj655en.exe Deskjet printer drivers, PC5250 print sessions fail with PCSWS.EXE page fault errors. PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- APAR = SE03819 CA400EXP-INCORROUT FAX PRINTER DRIVER COVER PAGE TEXT When faxing a PC document using the AFP fax printer driver included with Client Access Express, non-English characters located on the cover page do not get translated correctly. APAR = SE03820 QIWA ERROR INSTALLING PRINTERS ON WINDOWS XP When attempting to install the AFP or SCS printer drivers on Windows XP, an error message is issued indicating that the install operation cannot be completed. SCS PRINT DRIVER ---------------- See APAR SE03820 under AFP PRINT DRIVER section. AS/400 OPERATIONS CONSOLE ------------------------- APAR = SE03192 CA400EXP-OPCON RAS CONNECTION FAILS AFTER SI01907 IS APPLIED With SI01907 service pack applied to CA Express, Operations Console direct cable connection fails to connect with "RAS dial-up connection failed" message box. In the CWBOPCON.LOG error log there is a "NULL MODEM NOT PRESENT" error. APAR = SE03969 CA400EXP-OPCON-INCORROUT LAN REMOTE CONTROL PANEL POINTS AT WRONG PARTITION The configuration of an Operations Console Remote Control Panel (RCP) for other than the first secondary partition is incorrect. When one selects any partition ID greater than 1 for the RCP, it is stored in the registry as ID 1 and thus the RCP controls the wrong partition. Correction for APAR SE03969: ---------------------------- The selected partition number is now preserved in the registry. Circumvention for APAR SE03969: ------------------------------- One can use regedit to adjust the partition ID by opening the specified registry key and changing the partition ID appropriately. Open the registry key and replace "configname" in the following with the name of the Operations Console configuration whose RCP is pointing at the wrong partition: HKLM\Software\IBM\Client Access\CurrentVersion\ AS400 Operations Console\LCS\configname\Control Panel Port Double click on "Control Panel Port" and edit the value, changing the ",1" at the end of the string to reflect the proper partition number. CLIENT ACCESS EXPRESS TOOLKIT ----------------------------- HEADER, LIBRARY, AND DOCUMENTATION ---------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. TOOLS FOR JAVA -------------- No fixes. EZ-SETUP WIZARD --------------- No fixes. --------------------------------- Service Pack Level = SI01907 Build date = August 2001 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SE01670 CA400EXP-CONNECTIONS-MSGCWBLM0011 CWBLM0011 INTERNAL LICENCE APAR = SE01897 CA400EXP-MIGRATION-UNPRED AFTER MIGRATION TO CLIENT ACCESS 5 APAR = SE02319 CA400EXP-TERMEMUL PERSONAL COMMUNICATIONS V4.3 NOT STARTING APAR = SE02320 CA400EXP-TERMEMUL-INCORROUT PCOM 5.0 START/CFG FAILURES EXPRESS OPTIONAL COMPONENTS --------------------------- DIRECTORY UPDATE ---------------- No fixes. INCOMING REMOTE COMMAND ----------------------- No fixes. MAPI ---- No fixes. EXPRESS ONLINE USER'S GUIDE --------------------------- No fixes. AS/400 OPERATIONS NAVIGATOR --------------------------- OPERATIONS NAVIGATOR BASE SUPPORT --------------------------------- APAR = SE02363 CA400EXP-OPNAV - VISUALBASIC PLUGINS FAIL APAR = SE02365 CA400EXP-OPNAV MGMT CENTRAL JAVA PORT REDUCTION/SSL BASIC OPERATIONS ---------------- No fixes. WORK MANAGEMENT -------------- No fixes. CONFIGURATION AND SERVICE ------------------------- Non-APAR fixes. NETWORK ------- APAR = SE02364 CA400EXP-OPNAV L2TP AND IGN DIAL WIZARD UPDATES SECURITY -------- No fixes. USERS AND GROUPS ---------------- No fixes. DATABASE -------- Non-APAR fixes. FILE SYSTEMS ------------ No fixes. BACKUP ------ No fixes. APPLICATION DEVELOPMENT ----------------------- No fixes. COMMANDS -------- No fixes. PACKAGES AND PRODUCTS --------------------- No fixes. MONITORS -------- Non-APAR fixes. LOGICAL SYSTEMS --------------- Non-APAR fixes. AFP MANAGER ----------- No fixes. APPLICATION ADMINISTRATION -------------------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR = SE02321 CA400EXP-DTRANSFER EXCEL XP UPLOAD NOT SUPPORTED ODBC ---- APAR = SE01815 CA400EXP-ODBC-INCORROUT LIBRARY LISTS FOR EXISTING DATA SOUR APAR = SE01894 OSP-MSGPWS0006-PAR ODBC - APPLICATION REQUEST FOR STATIC CUR APAR = SE02158 CA400EXP-ODBC-INCORROUT INVALID TABLE TYPE ON CATALOG REQUES APAR = SE02205 CA400EXP-ODBC-INCORROUT - NUMERIC COLATTRIBUTE UPDATE LENGTH APAR = SE02322 CA400EXP-ODBC FAILURE ON PROCEDURE CALL WITH PARAMETER NAMES APAR = SE02323 CA400WINOPT-ODBC-INCORROUT LOCKED RECORD INDICATES EOF WITH APAR = SE02324 CA400EXP-ODBC-INCORROUT - NUMERIC CONVERSION PROBLEMS APAR = SE02325 CA400EXP-ODBC-INCORROUT PROBLEMS WITH ERROR HANDLING APAR = SE02326 CA400EXP-ODBC-INCORROUT PROBLEMS WITH SQL STMT PARSING APAR = SE02327 CA400EXP-INSTALL-INCORROUT - CONCURRENCY SETTING NOT HONORED APAR = SE02328 CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS APAR = SE02329 CA400EXP-ODBC-UNPRED - OPTION TO RETURN DB2-DEFINED SQLSTATE APAR = SE02330 CA400EXP-ODBC-INCORROUT - SQLGETDATA PROBLEMS APAR = SE02331 CA400EXP-ODBC ERROR IN SQLPARAMDATA APAR = SE02332 CA400EXP-ODBC-UNPRED - USABILITY ENHANCEMENTS APAR = SE02333 CA400EXP-ODBC-INCORROUT - BLOCK FETCH ISSUES APAR = SE02334 CA400EXP-ODBC-INCORROUT - ERROR ON PREPARE OF DRDA & DECLARE APAR = SE02335 CA400EXP-ODBC LAST BLOCK FETCH FOR CATALOG RETURN SWI OLE DB PROVIDER --------------- APAR = SE02336 CA400EXP-OLEDB-UNPRED CHANGE REGISTRY ENTRIES FOR TRACE/LOG LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. AS/400 JAVA TOOLBOX ------------------- This Client Access Express Service Pack will also install the equivalent of 5722JC1 product PTF SI02679. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE02343 CA400WINOPT - PC5250 CURSOR POSITIONING PROBLEM APAR = SE02344 CA400WINOPT - FIELD EXIT ON A MANDATORY FILL SIGNED NUMERIC APAR = SE02345 CA400EXP-TERMEMUL-INCORROUT PC5250 VB SCRIPT MACROS RUNNING APAR = SE02346 CA400EXP-TERMEMUL-PC5250 STRPCO COMMAND CAUSES HANG APAR = SE02350 CA400EXP-PC5250 TELNET PRINTER SESSION INCORROUT APAR = SE02351 CA400EXP-CREATE MULTIPLE SESSIONS GIVES PAGE FAULT APAR = SE02352 CA400EXP -PAGE SETUP GREYED OUT AFTER PRINT SCREEN APAR = SE02353 DBCS HPT FOR SESSION TYPE APAR = SE02354 CA400EXP-TERMEMUL-UNPRED PC5250 CURSOR JUMPS TO WRONG POSITI APAR = SE02355 CA400EXP-TERMEMUL-INCORROUT USING END OF FIELD KEY IN SOME O APAR = SE02356 PC5250-PRT-INCORROUT TRAY SELECTION DOES NOT WORK APAR = SE02357 CA400EXP - PC5250 PRESSING TAB KEY IN DBU HANGS SESSION APAR = SE02358 CA400EXP-TERMEMUL-INCORROUT PC5250 SESSIONS HANG WITH F10 APAR = SE02359 CA400EXP - WORDWRAP ON EMULATOR FAILS TO REMOVE NULLS OR APAR = SE02360 CA400EXP-TERMEMUL-INCORROUT PC5250 CURSOR POSITIONING DOESN' APAR = SE02361 CA400EXP - PC5250 PAGE FAULT MESSAGE WITH SF65706 APPLIED APAR = SE02387 CA400EXP-TERMEMUL-INCORROUT PC5250 BELGIAN DUTCH (2963) TOOL PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- No fixes. SCS PRINT DRIVER ---------------- APAR = SE02338 CA400EXP- UNPRED SCS PRINTER DRIVER HANGS WINNT WIN2000 APAR = SE02339 CA400EXP-INCORROUT SCS FONT CHANGES ON D/T423 AS/400 OPERATIONS CONSOLE ------------------------- APAR = SE02340 CA400EXP-OPCON-INCORROUT RCP CONNECTION FAILS TO CONNECT TO APAR = SE02341 CA400EXP-OPCON -MSGACCESS WAS DENIED BECAUSE THE USERNAME/AN APAR = SE02342 CA400EXP-OPCON-MSGCPF5140 OPERATIONS CONSOLE RANDOMLY DROPS CLIENT ACCESS EXPRESS TOOLKIT ----------------------------- HEADER, LIBRARY, AND DOCUMENTATION ---------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. TOOLS FOR JAVA -------------- No fixes. EZ-SETUP WIZARD --------------- APAR = SE02362 CA400EXP-OPNAV LANGUAGE MISMATCH IN DOMINO EZ SETUP WIZARD --------------------------------- Service Pack Level = SI01037 Build date = May 2001 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SE01206 CA400EXP-CONNECTIONS-INCORROUT CLIENT ACCESS EXPRESS CWBCFG APAR = SE01207 CA400EXP-UPDATE DIRECTORY UPDATE FAILS WHEN A DBCS FILE NAME APAR = SE01236 CA400EXP-OPNAV-HWINV-INCORROUT DISK UNITS NOT SHOWN EXPRESS OPTIONAL COMPONENTS --------------------------- DIRECTORY UPDATE ---------------- No fixes. INCOMING REMOTE COMMAND ----------------------- No fixes. MAPI ---- No fixes. EXPRESS ONLINE USER'S GUIDE --------------------------- No fixes. AS/400 OPERATIONS NAVIGATOR --------------------------- OPERATIONS NAVIGATOR BASE SUPPORT --------------------------------- Non-APAR fixes. BASIC OPERATIONS ---------------- No fixes. WORK MANAGEMENT -------------- No fixes. CONFIGURATION AND SERVICE ------------------------- Non-APAR fixes. NETWORK ------- Non-APAR fixes. SECURITY -------- No fixes. USERS AND GROUPS ---------------- No fixes. DATABASE -------- Non-APAR fixes. FILE SYSTEMS ------------ APAR = SE01235 CA400EXP-OPNAV-FILESYS-UNPRED NEW JAVA PROGRAM LABEL GONE BACKUP ------ No fixes. APPLICATION DEVELOPMENT ----------------------- No fixes. COMMANDS -------- No fixes. PACKAGES AND PRODUCTS --------------------- No fixes. MONITORS -------- Non-APAR fixes. LOGICAL SYSTEMS --------------- Non-APAR fixes. AFP MANAGER ----------- Non-APAR fixes. APPLICATION ADMINISTRATION -------------------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE01208 CA400EXP-DTRANSFER V4R4/R5 DTF GIVES INCORRECT FILE OPTIONS DATA TRANSFER EXCEL ADD-IN -------------------------- Non-APAR fixes. ODBC ---- APAR = SE01237 CA400EXP-ODBC-MSGSQL0106 FAILURE WHEN CREATING A TABLE APAR = SE01238 CA400EXP-ODBC INVALID VALUE RETURNED FOR FLOAT DATA TYPES APAR = SE01239 CA400EXP-ODBC ADDITIONAL OPTION TO DISABLE PROMPTING APAR = SE01240 CA400EXP-ODBC-INCORROUT WRONG SQLSTATE VALUE RETURNED OLE DB PROVIDER --------------- APAR = SE01241 CA400EXP-OLEDB-INCORROUT SUPPORT FOR MULTIPLE RESULT SETS APAR = SE01243 CA400EXP-OLEDB-INCORROUT FREE THREADING LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. AS/400 JAVA TOOLBOX ------------------- This Client Access Express Service Pack will also install the equivalent of 5722JC1 product PTF SI00131. 5250 Display and Printer Emulation ---------------------------------- This Service Pack includes PCOM5.0 CSD1 plus additional fixes. APAR = SE01205 CA400EXP-OPNAV-INCORROUT DISPLAY EMULATOR (PC5250) VIA OPNAV PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- No fixes. SCS PRINT DRIVER ---------------- No fixes. AS/400 OPERATIONS CONSOLE ------------------------- APAR = SE01244 CA400EXP-OPCON OPERATIONS CONSOLE LAN CONNECTION CLIENT ACCESS EXPRESS TOOLKIT ----------------------------- HEADER, LIBRARY, AND DOCUMENTATION ---------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- APAR = SE01242 CA400EXP-OLEDB-INCORROUT VB WIZARD GENERATES INCORRECT CODE TOOLS FOR JAVA -------------- No fixes. EZ-SETUP WIZARD --------------- 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 AS/400 Client Access Express for Windows SIxxxxx 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 Client Access Express 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 Client Access Express 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 AS/400 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 AS/400 National Language Support Manual.