======================================================================== Readme File for AS/400 Client Access Express for Windows Service Packs 5722-XE1 V5R1M0 Cumulative Service Pack Level ------------- SI05361 ------------- (c) Copyright IBM Corporation 2000. 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. 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 = SI05361 (July 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 (from the FTP /subcomps 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 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 = SI05361 Build date = July 2002 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SE04044 CA400EXP-SSL-INCORROUT MSGCWBCO1034 RC25426 ON PC5250 FIRST A problem occurs at the very first attempt of a PC5250 connection using a Windows 2000 user profile that doesn't have Administrator authority. The customer receives CWBCO1034 RC25426 connecting the PC5250 session. After pressing disconnect and connect again, the session successfully connects. APAR = SE04241 CA400EXP 2 MSGCWBLMSRV SHUTDOWN HANGS WITH CWBLMSRV MESSAGE Shutdown will hang after PC5250 session was open. Message states CWBLMSRV is not ended. APAR = SE05333 OSP-INCORROUT UNABLE TO USE DBCS SPECIFIC CHARACTER ON MS AC If Microsoft Access 2000 and the Client Access ODBC driver are used to retrieve records containing the following DBCS characters for Japanese, the records will not be retrieved correctly. x'4260' (PC code x'817C') x'43A1' (PC code x'8160') x'444A' (PC code x'815C') x'447C' (PC code x'8161') x'426A' (PC code x'FA55') The problem appears while retrieving records with these characters, not while updating records with these characters. APAR = SE06009 CA400EXP-OLEDB-INCORROUT IBMDA400 MIXES DATA IN BIDI IBMDA400 OLEDB provider mixes the order of a BIDI environment data when data contains both english and hebrew words. APAR = SE06195 INCORROUT UNABLE TO USE THREE THAI CHARACTERS WITH MS ACCESS Three Thai characters, mai ek, mai to, and mai tri, are handled incorrectly. If MS Access is used to link to a table and then insert or update a record with these 3 characters the wrong characters are inserted into the table. APAR = SE06839 CA400EXP-OLEDB-MSGCWBDB0052 OLEDB APP CANNOT FIND CONVERSION TBL An ASP application using VBScript, containing ADO objects, and using Client Access OLE DB fails with message CWBDB0052, "Error occurred during data conversion." This failure occurs when run on Windows NT 4 Server with service pack 6a, but does NOT fail when run on Windows 2000 Server. The OLE DB trace (cwbzztrc) indicates that the translation tables cannot be found in the Client Access common documents location, which on NT is usually C:\WINNT\PROFILES\ALL USERS\DOCUMENTS\IBM\CLIENT ACCESS. When the *.tbl files are copied from this location to the Client Access install directory, usually C:\PROGRAM FILES\IBM\CLIENT ACCESS the application runs successfully. This PTF fixes the reported problem, and some other problems in which a failure occurs because the conversion tables could not be found. Copying the *.tbl files into the Client Access install directory, which was mentioned in the problem description, is not a supported circumvention. APAR = SE06863 OSP-PAR CLIENT ACCESS LICENSING FAILS WHEN FRAME SIZES ARE V Client Access connections to PC5250 and/or data transfer will fail when communicating over a network that uses very small frame sizes. 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 --------------------------- 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 (SI05361) 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. 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 = SE03464 CA400EXP-OPNAV COLLECTION SERVICE REPORTS WRONG PARAMETERS I Scheduling a Collection Data from Operation Navigator/Management Central following the above instruction causes the Data Collection parameters to be uncorrectly reported. 1) On this group start a Collection using the following parms: - Create Database file during collection - Create Graph data when collection is cycled - Create summary data when collection in cycled 2) Schedule this to run 3) After the collection is started, looking at collection properties from "Task Activity" / "Collection Services" you may see that not all of these were correctly reported. In particular "Create Database files, Create Graph Data... and Create summary data..." are set to NO, regardless the original settings of the collection. In other words the collection properties seems to be changed to a different value than the original set when starting the collection. The collection services gui code has been changed to properly transfer the information from the gui to the server. If you have installed this service pack and are intending to use Management Central, Collection Services, you will need to apply 1 co-requisite PTF to your V5R1M0 Central System. Connections to V4R5M0 or earlier will not be affected. The PTF for the 5722SS1 product and its number is: SI03010 APAR = SE04653 CA400EXP-OPNAV-INCORROUT AUTHORITY ERROR CONFIGURING NETSERV Using a user profile which has a group profile which has*IOSYSCFG authority (rather than the profile itself having that special authority), will cause errors when attempting to configure AS/400 NetServer via the configuration wizard. The wizard will fail to launch with an authority error. The group profile special authorities will also be checked during the startup of the AS/400 NetServer configuration wizard. APAR = SE05472 CA400EXP-OPNAV VISUAL EXPLAIN PANEL IS NOT SHOWN WHEN USING Unable to get OPNAV Visual Explain panel when having XE1 italian and MS Windows with italian Locale settings. Customer executes the following: OPNAV, Database, SQL performance monitor, right click on any SQL performance monitor entry, select list explainable stms. From Explainable statements for SQL performance panel they then choose Run Visual Explain. After performing the above operations nothing is shown. OPNAV must be restated to recover from the above failure. Circumvention: Temporarily use a locale other than Italian on the pc. The problem is caused by translation errors in the Italian version of an mri file: DBV.pdml. This mri file cannot be fixed, but we can provide a code change that works around most of the problem. With the fix, everything will work except that Italian users will not have the same graph orientation button selected in the Visual Explain window that they selected the last time they did a Visual Explain. Users can reselect that graph orientation when the Visual Explain window is shown again. It will work properly in V5R2. APAR = SE05531 CA400EXP-OPNAV-INCORROUT MOVE CPU RESOURCES HANGS OPERATIONS When the panel to Move CPU resource is opened , it has no text and Operations Navigator hangs. This happens with SI02795 applied and for PC with a locale using commas for decimal values instead of periods. This APAR will fix the following defects. - Incorrectly parsing floating point numbers in some locales - An error in Move Memory which causes the panel to be given negative values. - An error which causes a set of 1.0x processing units to set the system with 1.x processing units. - An error which doesn't allow a non-zero share processor minimum during the create wizard. This APAR will remove the following function: - Operations Console integration into the LPAR GUI - Enabling OptiConnect on guest partitions. APAR = SE05818 OSP-DB DATABASE NAVIGATOR 'ADD TO MAP' FUNCTION FAILS IF Database Navigator fails to map OS/400 tables if these tables have a constraint. It occurs only with tables that have key and check constraints with defaulted names (defaulted to system names instead of explicitly naming them). When the failure occurs , you get :MSG SQL Ecxeption, SQL State : HY109, Vendor Code 99999. Database Navigator then starts "finding relations" forever. It can be stopped only by ending Operations Navigator. CIRCUMVENTION: This problem occurs when a parent file in a referential constraint is missing from the system, usually because it was not restored from media. Restoring the missing parent file would circumvent the problem. APAR = SE06861 OSP-PAR CLIENT ACCESS V450 OPERATIONS NAVIGATOR FATAL EXCEPT The user double-clicks on a folder in the hierarchy and receives two message boxes indicating that the list cannot be retrieved from the server. The user clicks OK on the first dialog box. After clicking OK on the second dialog box, a fatal exception occurs in cwbuna4d.dll ending the application. Non-APAR fix = CA400EXP-OPNAV-NETWORK-INCORROUT Servers linked to disk The following problems occur when a V5R1 Operations Navigator client PC connects to a V5R2 or later OS/400 system: 1) In Operations Navigator, expand Network, then Windows Administration. Then open the Disk Drives folder. The Servers column in the list shows incorrect data. Also, if the the properties of a disk drive are displayed, then the Windows server name and sequence position values are garbled on the Links tab. 2) In Operations Navigator, expand Network, then Windows Administration. Then open the Integrated Netfinity Servers folder. Then display the properties of a server. On the Software tab, the Windows Integration service pack list values are garbled. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE04511 CA400EXP-DTRANSFER-UNPRED UPLOADING BIFF8 FAILS Using Data Transfer To AS/400 to transfer a BIFF8 file to the AS/400 may fail with the message "CWBTF.EXE - Application error." The file must have been created with or modified and saved in Microsoft Excel for the problem to occur. APAR = SE04637 CA400EXP-DTRANSFER MSG "INVALID DATA PATH" WITH BIFF5 Error message"Invalid Data Path" is issued by the Data Transfer application when transferring files from AS/400 to PC with a PC file type BIFF5/7/8 and without a path included in the destination "File Name". This problem does not occur using previous versions of CA Express and/or using different PC file types (ie. BIFF3/4, CSV...). APAR = SE06350 CA400EXP-DTRANSFER-INCORROUT ASCII TEXT WITH ZERO PAD Using Data Transfer From AS/400 to transfer data to an ASCII text file may produce incorrect results if the option to pad with leading zeros is enabled. In the case where a numeric field which is less than 1 and contains decimal places is downloaded, a random value may get inserted in the digit to the left of the decimal separator instead of a zero. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR = SE04596 CA400EXP-DTRANSFER-UNPRED EXCEL GPFS WHEN USING THE ADD-IN Microsoft Excel may produce an application error upon startup if the Data Transfer Add-In is installed on the client workstation. This problem is not dependent on the client operating system or the version of Excel. ODBC ---- APAR = SE03767 CA400EXP-ODBC-MSGSQL0107 POWERBUILDER APPLICATION USING V5R1 Using the V5R1 Client Access Express ODBC driver fails with msgSQL0107 - "sum(CMSFIL" too long. Maximum 10 characters. Following is the statement which is being run: SELECT "CMSFIL"."PRPWKD"."GPEENO", sum(CMSFIL.PRPWKD.GPRGHR), Max(CMSFIL.PRPWKD.GPGP05) FROM "CMSFIL"."PRPWKD" WHERE ( ( CMSFIL.PRPWKD.GPCKTY = 'R1' ) ) AND CMSFIL.PRPWKD.GPCONO = 01 GROUP BY "CMSFIL"."PRPWKD"."GPEENO" HAVING ( sum(CMSFIL.PRPWKD.GPRGHR) > :reg_hours ) ORDER BY "CMSFIL"."PRPWKD"."GPEENO" ASC Client Access V5R1M0 returns different information for SQLGetInfo with the SQL_SPECIAL_CHARACTERS option than the Client Access V4R5M0 driver. SQL_SPECIAL_CHARACTERS as defined by the ODBC specification states that this option is: A character string containing all special characters (that is, all characters except a through z, A through Z, 0 through 9, and underscore) can be used in an identifier name, such as a table name, column name, or index name, on the data source. For example, "#$ ". If an identifier contains one or more of these characters, the identifier must be a delimited identifier. It appears that Powerbuilder sees "(" in this list and thinks that their sum function is really a library name. Most likely double quoting the library, table, and column names in their query source will get around this bug/limitation in Powerbuilder. There may be some other setting in PB to define these. R450 limited the special characters to only #@$. A test DLL was provided which removes only "(" and ")" so the output is "%&'*+,|-./:;<=>?_$@#. APAR = SE04020 CA400EXP-ODBC-INCORROUT NEGATIVE NUMBERS INSERTED AS POSITIV Customer has a Visual Fox application which uses the CA ODBC to insert and update records in an AS/400 table. When using parameter markers to update data in that table, negative numbers are being passed to the server as positive numbers. The problem is that the application is binding character representation of the number with leading blanks to SQL_DECIMAL or SQL_NUMERIC types. It would appear that the negative sign preceding the first numeric character was stripped off along with the spaces. CIRCUMVENTION: Do not pad character strings with leading blanks if the conversion is from character to a numeric data type. APAR = SE04119 CA400EXP-ODBC-INCORROUT AUTOCOMMIT ON DOESN'T CHANGE THE The ODBC application has not enabled true autocommit. The application does the following: - set autocommit off and isolation level to read committed. - perform some work - commit - set autocommit on In previous versions this sets the isolation level back to *NONE. ODBC R510 left the job in read committed and the application encountered a lock violation error MSGSQL0913. APAR = SE04230 CA400EXP-ODBC-UNPRED MEMORY LEAK ASSOCIATED WITH ENVIRONMENT There is a memory leak with some of the memory associated with the ODBC Environment handle. The leak is only seen in applications that continuously allocate (SQLAllocEnv) and deallocate (SQLFreeEnv) the environment handle. APAR = SE04467 CA400EXP-ODBC-INCORROUT DATA TRUNCATION ERROR WITH POWERBUIL When using the V5R1 CAE ODBC driver with Powerbuilder 6.0 or 6.5, polling for a certain character value returns garbage. The SQL log shows data truncation errors. It was found that the CAE ODBC driver is returning ODBC 3.0 types to a 2.0 application on the SQLGetTypeInfo call. APAR = SE04540 CA400EXP-ODBC-INCORROUT ODBC RETURNS NULL IF LOB THRESHOLD I ODBC returns a NULL value if you don't set the lob threshold higher than the size of your LOB. For example, if the LOB field size is 33K and the LOB threshold is 64K you will get the data back as expected. However, if you change the LOB threshold to 32K will cause a NULL value to be returned. APAR = SE04592 CA400EXP-ODBC-MSGSQL0104 ODBC FUNCTIONS WITH MORE THAN ONE ODBC functions with more than one parameter fail with the error message "MSGSQL0104 token ) was not valid." Example : select * from qiws.qcustcdt where {fn right(lstnam,3)}='' APAR = SE04649 CA400EXP-ODBC-INCORROUT VIEWING TABLE WITH OP NAV INCORRECTL Using V5R1 Client Access Express Operations Navigator to display a DB table results in incorrect data displayed for Graphic fields. The ODBC driver is incorrectly reporting GRAPHIC fields with ccsid 13488 as the SQL_WCHAR ODBC 3.0 data type to ODBC 2.x applications. The ODBC driver also has a problem in that it reports a character count for SQLColAttribute's SQL_COLUMN_LENGTH option. Previous ODBC drivers returned a byte count. APAR = SE04726 CA400EXP-ODBC-INCORROUT SP WITH CHAR IN/OUT PARM DOES NOT Stored Procedure works fine the first time. On the second call a char inout returns no data. Works fine with int inout. APAR = SE04900 CA400EXP-ODBC-INCORROUT DBCLOB DATA WRITTEN INCORRECTLY Using the ODBC driver to insert double byte or wide character data into a DBCLOB field, the data will be written correctly but twice as much space will be allocated as needed to store the data. This results in errors when retrieving the data because there will be extraneous information retrieved with the valid data. One way to check that the data is or isn't written correctly is to use SQL's CHARACTER_LENGTH function in a SELECT statement to determine the number of characters allocated to store the data. If the data is bound as SQL_C_CHAR rather than SQL_C_WCHAR, there is no problem. APAR = SE04915 OSP-PAR ODBC POOR PERFORMANCE Using Crystal Report 8.5 and ODBC driver V5R10 , the report takes a long time to run vs running it with ODBC driver R440 The V5R1 ODBC driver is indicating that there are search patterns in the ALL of the catalog requests whether there are or not. This causes the host server to use a select statement which bases its comparisons on LIKE rather than = (equal to). The time is spent for each one of catalog requests. APAR = SE05199 CA400EXP-ODBC-WAIT JDE ONEWORLD APPLICATION APPEARS TO HANG Customer using JDE OneWorld application encounters what is perceived as a hang condition. Application or QZDASOINIT job must be ended to recover. Detail trace shows multiple threads using the same connection handle. Both threads enter the critical section at the same time, one SQLSetCursorName, and the other SQLFreeStmt but neither return. There is the potential for a deadlock condition when SQLSetCursorName is used in a multi-threaded environment when the threads are using the same connection handle. APAR = SE06149 CA400EXP-ODBC-INCORROUT INVALID LENGTH REPORTED ON CATALOG Catalog requests such as SQLTables or SQLColumn will fail in certain cases with an error message 'Invalid string or buffer length' and an SQL State of HY090. If the length of one of the names such as the catalog, schema or table name is longer than 10 characters, the failure occurs. Typically these names cannot be longer than 10 characters; however, if the name contains underscores, they must be preceded by an escape sequence so that they are interpreted as a literal part of the name rather than an wildcard. For example a library named DUMMY_1234 should be passed to this function as DUMMY\_1234 so the length is legitimately longer than 10 characters. APAR = SE06297 CA400EXP-ODBC-PERFM PARAMETER MARKER DESCRIPTION A performance enhancement is needed to speed up execution when executing a SQL statement involving parameter markers for variable length columns. The enhancement will cut the amount of data that the ODBC driver sends to the server leading to better performance. Also, an enhancement is needed to give an application the ability to specify the exact number of rows that the driver fetches when processing the results from a query. Note, this does not affect how many rows are returned to the application. This performance option allows an application to fine tune performance particularly in cases where the application runs over a WAN or slower connection. The app can get the exact number of rows and data that it really needs rather than a fixed 16k, 32k, etc. This prevents using up bandwidth for data that will not be used and speeds response times. Both of the above changes are critical for running the Siebel application in some environments and the Siebel application is now being installed and run by customers on the iSeries. APAR = SE06414 CA400EXP-ODBC-MSGSQL0181 AND MSGCPF5035 RC18 ON ODBC TIMESTA msgSQL0181 and msgCPF5035 RC18 on odbc timestamp. OS R450 CAE R510 SI02795 Reviewed SQLLOG which shows msgsql0181 and the qzdasoinit joblog shows msgcpf5035 rc18 followed by the msgsql0181 Customer runs the same application on R320 of client access with no problems. Application passes a timestamp field in valid SQL format to be processed by SQL/400 via ODBC and returns error. APAR = SE06447 CA400EXP-ODBC-INCORROUT - ODBC FAILS TO RETURN FULL STORED P An ODBC application, using the Client Access Express R510 ODBC driver, fails to return all of the rows when calling a stored procedure which retrieves data from a table containing over 200 records. The number of rows returned may vary. When the same stored procedure is called using the CAEXP R450 ODBC driver, all rows are returned correctly. APAR = SE06546 CA400EXP-ODBC-MSGCWB0111 CHARACTER DATA RIGHT TRUNCATION WIT The R510 Client Access Express ODBC driver version 8.0.4.3 and 8.0.4.4 may incorrectly report the following error: 22018 Column 1: CWB0111 - A buffer passed to a system call is too small to hold return data 22001 Character data right truncation. The problem only affects VARCHAR, CLOB and BLOB parameters with a size less then 500. The problem may appear intermittent since it is affected by the parameter value. The problem can only occur if multiple executes for the same parameterized statement are run. Note that this version of the dll was only available as a separate download from the Client Access FTP site and was not included on any service pack. APAR = SE06714 CA400EXP-ODBC-INCORROUT Multiple problems are fixed with this APAR: 1. If an application does a block insert, increases the number of rows in the block, and does another block insert, the driver crashes. 2. The driver is not honoring the connection attribute for SQL_ATTR_ACCESS_MODE. 3. The driver incorrectly returns an error about 'Invalid string or buffer length' when binding SQL_C_CHAR parameters with SQL_NULL_DATA on a single row insert. 4. When dealing with DBCLOB locators, the driver mishandles the length of the data on fetches. This can lead to conversion errors. The circumvention for this problem is to specify a arger 'Large objects (LOB) threshold (KB)' setting. 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 = SE04281 CA400EXP-OLEDB-INCORROUT RUNTIME ERROR -2147217887 on OpenIndex VB Application using OLEDB and ADO that functions on R450 CAE SF66513 fails on R510 CAE SI02795. IBMDA400.LOG shows CBindingImpl::CanConvert - FAILED: 1; wFromType: 128; wToType:3 CBindingImpl::CreateAccessor failure: binding 0, column 3, cannot coerce types. Code sample that causes failure Set m_ixInp26 = m_ix.OpenIndex(t.GetIfsName, t.GetIfsName) Circumvention for SE04281: -------------------------- Use the built-in integrated index support with Seek, instead of using the AD400 index object. APAR = SE06083 CA400EXP-OLEDB-INCORROUT NUMBER OF ROWS AFFECTED IS INCORRECT Using the IBMDA400 OLE DB provider with ADO in Visual Basic to perform an insert, update, or delete function. The number of rows affected by the statement should be returned as output but with the V5R1 provider, only a value of -1 is returned. APAR = SE06106 CA400EXP-OLEDB-INCORROUT SINGLE PRECISION DEC INCORRECTLY INSERTED Customer uses a VB/ADO application which calls a stored procedure and pass a single precision decimal data to a packed 7,2 field. They found that if they use decimal numbers with values between 0.01 and 0.10 the resulting data passed to the OLEDB provider from ADO is not the same as what is passed to ADO from the VB program. For example, the VB program passed a value of 0.01 in a single precision numeric variable. ADO passed the OLEDB provider 9.99999998E-3. While this would be the same once it is rounded up, the OLEDB provider does not handle numbers in scientific notation, it seems to strip off the exponent and pass the mantissa to the host. Subsequently, the values passed to the stored procedure are integers between 1 and 10. are incorrectly converted to integers. Problem happens when using numbers with values between 0.01 and 0.10 with the exception of 0.02 and 0.07 which are never converted to the exponential notation. Generally, this occurs when VB/ADO uses floating point as input. OLE DB will handle exponential notation properly. APAR = SE06469 CA400EXP-OLEDB-INCORROUT IBMDA400 RETURNS EMPTY RESULT SET F IBMDA400 returns empty result set for array result set with no indicators. An application uses the Client Access Express OLEDB provider IBMDA400. The application calls a stored procedure which returns an array result set. If the SET RESULT SETS ARRAY statement does not include an optional indicator array, IBMDA400 incorrectly handles the result set. In R510 the error appears as follows: The cwbzztrc trace will log "GetNextRows returning E_FAIL.". ADO appears to ignore the error and returns a result set object with EOF set to true. The application detects no error and believes that zero rows were returned. In R450 and earlier the error may surface as intermittent incorrect null values being returned. The OLE DB provider will handle results sets returned that do not have indicators. APAR = SE06588 CA400EXP-OLEDB-UNPRED EXECUTING A PREPARED CALL STATEMENT Customer application uses the Client Access Express OLEDB provider IBMDA400 to execute a prepared CALL statement multiple times. If the stored procedure being called returns a different result set type (i.e. a result set with different metadata) on a later execute an error will occur. If the later execute returns a result with more columns then the first execute the error results in a Application error fault the first time the result set is accessed. If the later execute returns a result with fewer columns the application may see the error -2147217887 "Multi-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR = SE05031 CA400EXP-AFPVIEWER CWBNP1019 AFP RESOURCE NOT FOUND ON SYSTEM When viewing an AFP spooled file with the AFP viewer shipped with Client Access Express, the following error is issued: "CWBNP1019 - AFP Resource F1DFLT.FORMDF on system not found". AS/400 JAVA TOOLBOX ------------------- This Client Access Express service pack will also install the equivalent of 5722JC1 product PTF SI?????. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE03871 OSP-INCORROUT CUT AND PASTE INTO SEU OR EDTTXT OR DDS DISPLA When using cut/paste into a PC5250 session where line wrapping takes place, wordwrap is not occurring at a space in between words. Instead the word will be split between lines. The problem can be demonstrated in screens such as SEU, EDTTXT, STRSQL and a Display File using the Edit words WRDWRAP and CNTFLD used to control the wrapping of text. APAR = SE03895 CA400EXP-TERMEMUL-INCORROUT ALARM DOES NOT SOUND WHEN USING Alarm works when a break message is received, but it does not work when the user tries to type at any protected area. Works ok at the server console. APAR = SE03962 CA400EXP-DBCS PRINTED AS GARBAGE BY PRINTER SESSION Env : CA/400 R510 EXP SF01907 Prob : Printer session with ESC_P, DBCS printed as Garbage and CR/LF was lost. Also unable to compile ESC_P PDF. APAR = SE03929 CA400EXP-TERMEMUL-INCORROUT DIACRITIC CHARACTERS PROBLEMS WI Unable to type capital letters with caron or overcircle. Error message displayed is " Key following diacritic not valid". Problem does not occur when using Host Code page 870. APAR = SE04033 CA400EXP-TERMEMUL-INCORROUT WRONG KBDTYPE AND CHRID USING 1112 When configuring a PC5250 display session with Host Codepage 1112, a wrong KBDTYPE and CHRID is set on the device created on the AS/400 (it results in 'USB 1305 37'). APAR = SE04096 CA400EXP PCSWS PAGE FAULT WHEN CLOSE A 5250 SESSION PCSWS page fault occurs when closing a session with 'X II' on the 25th line. APAR = SE04154 CA400EXP-TERMEMUL-INCORROUT WRONG KBDTYPE AND CHRID USING 1122 When configuring a PC5250 display session with Host Codepage 1122, a wrong KBDTYPE and CHRID is set on the device created on the AS/400 (it results in 'USB 1307 37'). APAR = SE04192 CA400EXP-SECURITY-MSG656 UNABLE TO CONNECT PC5250 WHEN PASSW Unable to start PC5250 session when the password is more than 45 characters when using the new 128 character password encryption support. Getting a commcheck 656 message. APAR = SE04551 CA400EXP-TERMEMUL FIELDS IN RPG APPLICATION GETS TRUNCATED S Problem with fields getting truncated in RPG applcaition after application of SI02795 service pack. Unable to recreate the problem with previous service pack or client version. APAR = SE04835 CA400EXP-TERMEMUL-INCORROUT EMBEDDED SESSION DOES NOT RESIZE When a PC5250 session is embedded within an OLE container it does not resize correctly when the size mode property of the container is set to stretch. The session should resize itself to fill the container, instead it is resizing the container to fit the size of the session. This may actually be larger than the window itself. It has been reported that this behavior does not occur on the Windows NT platform but it has been reproduced in Windows 98, 2000 and XP. APAR = SE04867 CA400EXP-TERMEMUL-UNPRED MISSING FILES FOR HACL CLASS LIBRAR Client Access Express installation registers the following files in the Windows registry. autsrec.tlb autsrec.dll autsdsc.tlb autsdsc.dll autohio.tlb autohio.dll These files are missing from the registered location. These files are common to 5250 emulation and 3270 emulation and may be used by both. Files should be included with the emulator. APAR = SE05133 CA400EXP-TERMEMUL-INCORROUT PC5250 CONFIGURATION USING 1157 MSGPCSCC007 is issued when selecting 1157 as Host Codepage from the PC5250 configuration panel. APAR = SE05152 CA400EXP-TERMEMUL-INCORROUT BLANKS ARE REMOVED FROM ENTRY FI Since installing the latest SP SI02795, customer is getting the blanks removed from the entry field in her display file. She noticed that this only happens when she uses the keyword CTNFLD in the display file. APAR = SE05160 CA400EXP-TERMEMUL-INCORROUT PROBLEM WITH CONTINUOUS FILED EN When user re-enters a screen with a continuous entry field, some segments of the continuous field suddenly become "protected" and does not allow the user to enter any character in those fields. APAR = SE05180 CA400EXP-TERMEMUL PCSCM.EXE-APPLICATION ERROR. THE INSTRUCTI PCSCM.EXE - Application Error received stating 'The instruction at "0x?" referenced memory at "0x?". The memory could not be read.' when closing one of multiple PC5250 emulation sessions open. This only happened after installing Client Access Express Service Pack SI02795. APAR = SE06164 CA400EXP-TERMEMUL-MSGMCH0601 CSRINPONLY SPECIFIED IN DSPF Using PC5250 emulation, when the CSRINPONLY keyword is specified in a display file with MSGSFL, the cursor treats the message on line 24 as an input capable field. If the Field Exit key is pressed on the message, and then the enter key is pressed, the error 'MSGMCH0601 - Space offset is outside current limit.' is displayed and a dump is generated. APAR = SE06296 OSP-PAR PC5250 PROCESSING OF FIELD WITH WORD WRAP AFTER SI02 PC5250 processing of a field with continuous input and word wrap ( CNTFLD WRDWRAP ) has changed with SI02795. Previously, PC5250 sent data to the OS/400 telnet server with blanks padded at the end of the line when a word was wrapped. SC41-5715 specifies that the blank padding will be removed. Once this was fixed in SI02795, some customers have had application problems. Some programs depend on this feature for processing of the field. A new keyword has been added to specify the wordwrap behavior as follows. This should be added to the workstation profile (.ws file). [LT52] WordWrapRemoveNulls = Y or N (default value is N) Value of Y: The nulls within wordwrap entry fields are removed from the data sent to the server. Value of N: The nulls within wordwrap entry fields are padded with blanks (instead of removing them) and then sent to server. APAR = SE06586 CA400EXP-TERMEMUL-LOOP WHEN USING IWMP2000 TO SCAN DOCUMENTS When using WIN 2000 with Client Access Express V5R1M0 SI02795 scanning documents with IWPM software will cause PC5250 session to hang. APAR = SE06719 CA400EXP-PC5250-INCORROUT VIETNAMESE 5250 DISPLAY EMULN Encountered the following problems when using Vietnamese: a. Input : When key in a non-space accent mark, the field length will be reduced by one space. It looks like system counts each non-space character as one allocated position. b. Edit : If we make a correction by delete with backspace or move the cursor backward, accent marks at before the cursor will jump over to other character and make wrong combination to Vietnamese character. c. Page Up - Down : When using STRDFU to update or view the physical file if the new record has reduced-length field, then old data from old display will not be completely cleared from screen. Old characters will be left as residue. APAR = SE06866 CA400EXP-TERMEMUL-MSGPCSCC006 WITH HOST CODEPAGE 924 OR 1148 When configuring a PC5250 session to use Host Codepage of 924 - 'Multinational ISO Euro' or 1148 - 'Multinational Euro', once the session connects to the AS/400, the virtual device description is created with KBDTYPE=RUE and CHRID=1381 1154. Reviewing the PC5250 session configuration you find that the Host Codepage setting has been changed to 1154(Russian Euro). If this is changed again to 924, and the session is saved prior to reconnection to AS/400, subsequent attempts to open the saved session fail with error message PCSCC006 - 'The host codepage specified in the workstation profile is invalid'. This problem occurs on R450 Express SF65345 and R510 SI01907 service levels. APAR = SE06867 CA400EXP-PC5250 INCORROUT MSGPCSCC007 FOR INVALID CODE PAGE Selcting Host Codepage 1148 Multinational Euro results in MSGPCSCC007. Other 1148 Host Codepages work fine. Host Codepage 1148 Multinational Euro is not valid when connecting to an iSeries Server. It is no longer selectable from the PC5250 configuration panel. APAR = SE06869 CA400EXP-TERMEMUL-INCORROUT SESSION HANGS ON EXIT IF CHANGES When using a workstation file that is read only, if changes are made to that session that would normally be written to the WS file (i.e. Changing the font color through Appearance), the session will not close. The session appears to hang while attempting to access the WS file for modification. Clicking on the "X" to close the session, or doing a File->Exit will not close the session. The session has to be closed through the Task Manager. APAR = SE06870 CA400EXP-TERMEMUL-INCORROUT WRONG CURSOR POSITION IN A PC525 Customer reports cursor position problem using a custom application in a CAE PC5250 video session. This application consists of an entry field mask and it was designed to put the incoming messages for the user at row 24. When a message is received on the video session the message is correctly displayed at row 24 but the cursor jumps to the first entry field of the mask. This behavior only occurs on CAE R450 SF67104. APAR = SE06871 CA400EXP-TERMEMUL-INCORROUT UNABLE TO SPECIFY A SECURE WEBSI When entering a secure website, unable to click on it and go to that specific url. A non-secured url still works fine. PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- APAR = SE05172 CA400EXP 2 UNPRED CANCELED FAX IS STILL SENT Some recipients receive a faxed PC document even though the print operation is cancelled by the user. This problem occurs when using the Client Access Express Windows NT/2000/XP Facsimile Support/400 AFP printer driver and mutiple recipients are specified. SCS PRINT DRIVER ---------------- No fixes. AS/400 OPERATIONS CONSOLE ------------------------- No fixes. 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 = SI02795 Build date = February 2002 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SE03045 OSP-PAR CLIENT ACCESS WITH V5R1 AND SI01907 HAS SHUTDOWN APAR = SE03411 OSP-PAR CWBLM0011 ERROR GIVEN ON FIRST LICENSE USAGE AFTER APAR = SE03520 CA400EXP-SECURITY-MSGCWBSY0011 PASSWORDS STARTING WITH A APAR = SE03552 OSP-MSGCWB0111 BINDING A ZERO LENGTH STRING AS A SQL_C_WCHAR APAR = SE03810 CA400EXP-OPNAV-INCORROUT WRONG HEBREW TRANSLATION IN IFS APAR = SE03811 CA400EXP-CONNECTIONS-INCORROUT CWBCFG FAILS, MUST BE ADMIN APAR = SE03812 CA400EXP-CONNECTIONS-INCORROUT CWBCFG SET IP ADDRESS LOOKUP APAR = SE03830 CA400WINOPT IBMDA400 PARAMETER BIDI TRANSFORM IGNORED APAR = SE03863 CA400WINOPT - ARABIC TRANSLATION LAM-ALEF CHARACTER NOT GET EXPRESS OPTIONAL COMPONENTS --------------------------- DIRECTORY UPDATE ---------------- No fixes. INCOMING REMOTE COMMAND ----------------------- APAR = SE02529 CA400EXP-INRMTCMD-INCORROUT RUNRMTCMD BAD SPECIAL CHARACTERS MAPI ---- No fixes. EXPRESS ONLINE USER'S GUIDE --------------------------- No fixes. AS/400 OPERATIONS NAVIGATOR --------------------------- APAR = SE02797 CA400EXP-OPNAV-PERFM CLICKING ON BY LOCATION UNDER HARDWARE APAR = SE03288 CA400EXP-OPNAV-FILESYS-INCORROUT NOT ABLE TO EXPAND A APAR = SE03836 OSP-MSGCPD0020 MSGCPD0014 SETTING PERMISSIONS VIA OPNAV APAR = SE04017 CA400EXP-OPNAV FIX MC REGISTRY WRAPPER CLASS ON WIN XP APAR = SE04016 CA400EXP-OPNAV PACKET RULES DON'T LOAD ON CORRECT LINENAME APAR = SE04018 CA400EXP-OPNAV SMTP PROPERTY PAGE FIXES APAR = SE04019 CA400EXP-OPNAV PPP VALIDATION LIST 99 ENTRY LIMIT DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE02766 CA400EXP-DTRANSFER-MSGSQL0010 DATA TRANSFER WHERE CLAUSE APAR = SE02833 CA400EXP-DTRANSFER-INCORROUT DATA TRANSFER UPLOAD WITH ASCII APAR = SE03076 CA400EXP-DTRANSFER-MSGCWBTF0008 CREATE WIZARD LOSES EXPONENT APAR = SE03267 CA400EXP-DTRANSFER-INCORROUT LEADING ZEROS ARE NOT HANDLED APAR = SE03580 CA400EXP-DTRANSFER-INCORROUT DBCS CELLS INCORRECT IN BIFF8 DATA TRANSFER EXCEL ADD-IN -------------------------- APAR = SE02898 CA400EXP CWBTF0084 EXCEL 97 ADD-IN FAILS AFTER SI01907 APAR = SE03439 CA400EXP-DTRANSFER-INCORROUT EXCEL XP DATAXFER ADD-IN STOPS APAR = SE03567 CA400EXP-DTRANSFER-INCORROUT ADDIN FAILS TO UPLOAD JAPANESE APAR = SE03595 CA400EXP-DTRANSFER-INCORROUT 5722XE1 DATA TRANSFER EXCEL ADD ODBC ---- APAR = SE02678 CA400EXP-ODBC-MSGSQL0180 TIMESTAMP ESCAPE SEQUENCE CONVERTED APAR = SE02794 CA400EXP-ODBC-INCORROUT CREATE DSN USING LOWER LETTER FOR APAR = SE02802 CA400EXP-ODBC-UNPRED FAILOVER FAILURE WITH CA EXPRESS V5R1 APAR = SE02837 CA400EXP-ODBC-MSG3265 SQLPROCEDURECOLUMNS, DRDA, OTHER FIXES APAR = SE03121 CA400EXP-ODBC-INCORROUT TRANSACTION ISOLATION LEVEL SET APAR = SE03217 CA400EXP-ODBC-LOOP LOOP APPENDING ROWS USING ODBC APAR = SE03270 CA400EXP-ODBC-INCORROUT GRAPHIC TYPE DATA IS NOT HANDLED APAR = SE03278 CA400EXP-ODBC STORE PROCEDURE CALLED VIA ODBC IS NOT RETURNI APAR = SE03352 CA400EXP-ODBC-INCORROUT SQLCOLATTRIBUTES FOR SQL_DESC_COUNT APAR = SE03389 CA400EXP-ODBC-INCORROUT SQLEXTENDEDFETCH AND SQLFETCHSCROLL APAR = SE03417 CA400EXP-ODBC-INCORROUT COLUMNWISE BINDING USED IN CONJUNCTI APAR = SE03561 CA400EXP-ODBC-UNPRED MS VB RDO APP. REPORTS DIAG³S1003Û APAR = SE03704 CA400EXP-ODBC-INCORROUT THE ODBC DRIVER IS ALWAYS REPORTING APAR = SA93212 CA400EXP-ODBC-INCORROUT SQL_MAX_LENGTH SQLSETSTMTOPTION APAR = SE03813 CA400EXP-ODBC-INCORROUT GRAPHIC TYPE DATA IS TRUNCATED WHEN APAR = SE03814 CA400EXP-ODBC-PERFM - PERFORMANCE WITH SCROLLABLE CURSORS APAR = SE03815 CA400EXP-ODBC-INCORROUT - BLOCK INSERT PROBLEMS APAR = SE03816 OSP-DB-INCORROUT CORRUPT DATA WITH LOCAL PACKAGE CACHE APAR = SE03817 CA400EXP-ODBC-INCORROUT CRASH WHEN BIND_OFFSET_PTR SET OLE DB PROVIDER --------------- APAR = SE03328 CA400EXP-OLEDB-INCORROUT ERRORS WITH OLEDB AND SQL SERVER APAR = SE03505 CA400EXP-OLEDB-MSGCWBZZ5014 ASCII TO ZONED CONVERSION, VALUE APAR = SE03818 CA400EXP-DBACCESS-OLEDB-MSGCWBZZ5014 DATA CONVERSION ERROR LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR = SE03821 QIWA-PRINT-INCORROUT OP NAV SPOOLED FILE VIEWING FORM DEFS 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 APAR = SE02462 CA400EXP-PRINTEMUL-UNPRED MANUFACTURERTYPE IN PC5250 PRINTER APAR = SE02687 OSP-INCORROUT CUT AND PASTE INTO SEU OR EDTTXT FROM CA400EXP APAR = SE02752 CA400EXP-PC5250 WIN2K PREFORMANCE DEGRADATION ON WS DURING APAR = SE02851 OSP-PAR HOTSPOTS SETTING ARE NOT RETAINED WHEN MULTIPLE APAR = SE02852 CA400EXP-PC5250 PROBLEMS WITH MULTI LINE PASTE APAR = SE02901 CA400EXP-TERMEMUL-INCORROUT AFTER INSTALLING SI01907, CURSO APAR = SE03448 CA400EXP-TERMEMUL-PERFM PC5250 SLOW REFRESH SINCE 3D BUTTONS APAR = SE03566 CA400EXP PC5250 INVALID FONT IMAGE APAR = SE03671 CA400EXP-TERMEMUL DDS ATTRIBUTE PROTECT DOES NOT WORK IF APAR = SE03686 OSP-PAR COPY AND PASTE FROM PC5250 TO EXCEL/123 WITH TRAILIN APAR = SE03698 CA400EXP-TERMEMUL-UNPRED USING TAB KEY HANGS SESSION APAR = SE03708 CA400EXP-TERMEMUL-INCORROUT SETTING LETTER GOTHIC BOLD FONT APAR = SE03709 CA400EXP-TERMEMUL INCORROUT DANISH NATIVE CHARS CANNOT APAR = SE03719 CA400EXP-TERMEMUL-INCORROUT STRPCO AND STRPCCMD FAIL TO APAR = SE03720 CA400EXP-PC5250 INCORRECT IME CONVERSION APAR = SE03744 CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE FUNCTION FAILS IF APAR = SE03747 CA400WINOPT-TERMEMUL-INCORROUT VB SCRIPT MACRO TIMEOUT APAR = SE03795 CA400EXP-TERMEMUL-INCORROUT AUTO SIGNON DOES NOT WORK PROPER APAR = SE03822 CA400EXP-TERMEMUL-INCORROUT PC5250 SCROLLBAR DOESN'T WORK AS APAR = SE03823 CA400EXP-TERMEMUL-INCORROUT PC5250 SCROLL BAR NOT DRAGABLE APAR = SE03824 CA400EXP-TERMEMUL-PERFM MACRO FAILS TO PAUSE WHEN IT REACHES APAR = SE03825 OSP-PAR NEW WINDOWS 2000 DESKJET PRINTER DRIVERS CAUSE PC525 PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- APAR = SE03819 CA400EXP-INCORROUT FAX PRINTER DRIVER COVER PAGE TEXT APAR = SE03820 QIWA ERROR INSTALLING PRINTERS ON WINDOWS XP 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 APAR = SE03969 CA400EXP-OPCON-INCORROUT LAN REMOTE CONTROL PANEL POINTS AT WRONG PARTITION 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 --------------------------- APAR = SE02363 CA400EXP-OPNAV - VISUALBASIC PLUGINS FAIL APAR = SE02364 CA400EXP-OPNAV L2TP AND IGN DIAL WIZARD UPDATES APAR = SE02365 CA400EXP-OPNAV MGMT CENTRAL JAVA PORT REDUCTION/SSL 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 --------------------------- APAR = SE01235 CA400EXP-OPNAV-FILESYS-UNPRED NEW JAVA PROGRAM LABEL GONE 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.