======================================================================== Readme File for AS/400 Client Access Express for Windows Service Packs 5769-XE1 V4R5M0 Cumulative Service Pack Level ------------- SF66513 ------------- (c) Copyright IBM Corporation 2000. All rights reserved. ======================================================================== IMPORTANT: Please check Informational APAR II11759 for the latest list of OS/400 PTFs that must be installed on the AS/400 prior to attempting any Client Access functions. Some of the fixes contained in this service pack will not work if the required OS/400 PTFs are not installed on the AS/400. Informational APARs for Client Access can be viewed on the internet at "http://www.as400.ibm.com/clientaccess/" under the "Information APARs" link. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN AS/400 SYSTEM 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE 2.0 RESTRICTIONS 2.1 OPERATIONS NAVIGATOR 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SF66513 (October 2001) 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. 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. 2.0 RESTRICTIONS ----------------- 2.1 OPERATIONS NAVIGATOR ------------------------- 1) 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) The online help for some Operations Navigator functions will not display on PCs that have less than 128MB of memory. For example, the help for Visual Explain (under Database) may not display. 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 = SF66513 Build date = October 2001 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SA92953 CA400EXP-OPNAV-OUTPUT-MSGCWBUNNAV.EXE DOMAIN NAMES WITH 13 O Attempting to view spooled files, or copy them to a PC using Operations Navigator, causes CWBUNNAV.EXE failure when the connection uses fully qualified domain names of 13 or more characters. Correction for APAR SA92953: ---------------------------- This PTF fixes the reported problem. Circumvention for APAR SA92953: ------------------------------- Use a system name that is 12 characters or less in length. APAR = SA93179 CA400EXP-OPNAV-UNPRED OPERATION NAVIGATOR HANGS AFTER The problem is when the customer opens operations navigator and expands the system tree, then expands the OnDemand Archive option, and expands either Report Administration or Media Administration, Ops Nav hangs. If you right-click and select open and that works. APAR = SA93548 CA400EXP-OPNAV-PRINTERS-INCORROUT PRINTERS NOT LISTED AFTER After sf65345 installation on caexp r450 printers aren't listed anymore in Operations Navigator Basic Operations with INCLUDE ALL option. APAR = SA93803 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 = SA94077 CA400EXP CHANGING SERVICE SOURCE DIRECTORY IN CA PROPERTIES Changing Service Source Directory in the Service tab of Client Access Properties to shorter string fails to display correct string. For example, if you first enter the string \\netserver\qibm\proddata\ca400\express\service\image in the Service Source Directory field of the Service tab of Client Access Properties and then change it to just \\netserver\qibm, the next time you open Properties and look at this setting the long string will be displayed again. 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 = SA90035 CA400EXP-OPNAV INCORROUT MOUSE ICON ON WINDOWS2000 ENVIRONME An hourglass is displayed next to the mouse pointer while a node is expanding in the AS/400 Operations Navigator tree. This hourglass may remain displayed after the expansion has completed on the Windows 2000 operating system. APAR = SA93354 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". Correction for APAR SA93354: ---------------------------- This PTF fixes the reported problem. Circumvention for APAR SA93354: ------------------------------- 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) BASIC OPERATIONS ---------------- No fixes. JOB MANAGEMENT -------------- No fixes. CONFIGURATION AND SERVICE ------------------------- No fixes. NETWORK ------- APAR = SA94180 CA400EXP-OPNAV PPP - AT&T GLOBAL NETWORK DIAL WIZARD UPDATE The AT&T Global Network Dial Connection wizard was updated so that the route redistribution dynamic routing parameter is no longer set when the dial profile is created. The wizard was incorrectly setting the route redistribution parameter when the profile was created and passive routing was configured. SECURITY -------- No fixes. USERS AND GROUPS ---------------- No fixes. DATABASE -------- No fixes. FILE SYSTEMS ------------ No fixes. MULTIMEDIA ---------- No fixes. BACKUP ------ No fixes. APPLICATION DEVELOPMENT ----------------------- No fixes. MANAGEMENT CENTRAL ------------------ No fixes. APPLICATION ADMINISTRATION -------------------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. DATA TRANSFER WK4 FILE SUPPORT ------------------------------ No fixes. ODBC ---- APAR = SA92483 CA400EXP-ODBC-INCORROUT ODBC USING DATA SOURCE FORMAT OPTION Customer set ODBC data source to decimal seperator of comma(,). This setting should only apply to the job. The conversions between the ODBC C Data type and ODBC SQL Data type defined to always use a decimal seperator of period(.). Problem recreated on Express 440 with sp SF63638. Also tested on Express 450 SP SF64217 and failed. APAR = SA92567 CA400EXP-ODBC-MSGSQL0406 TRUNCATION ON BLOCK INSERTS It appears that the last portion of the data from the PC never reaches the AS/400. This occurs in the last block of a blocked record on the last several fields. It appears that if the block does not get larger than the initial size then everything works okay. However, if the block should get larger that is when the 'conversion problem happens'. APAR = SA92788 CA400EXP-ODBC-UNPRED SQLGETDATA DOESN'T RETRIEVE ALL DATA The customer is getting a Dr. Watson on his PC during a select on the Blob Field. The problem is caused by setting the LOB threshold to the maximum level of 16384 KB in the DSN when using an application which doesn't bind the column to a variable but rather, uses the SQLGetData function to retrieve only a part of the data. In this case the driver should return the amount of data requested and indicate through the return code, that there is more data available and through on of the parameters on the SQLGetData function, it should return the size of the remaining data. On subsequent calls to SQLGetData, the driver should return the next "chunk" of data and indicate whether or not more data remains and how much. The driver is incorrectly returning the total size of the LOB on all calls and is always returning the first "chunk" of data instead of progressing through the field. This causes the application to loop, continuously calling SQLGetData because we never get to the end of the data. Eventually the application will fault. Circumvention: Set the LOB threshold to a lower value. APAR = SA93050 CA400EXP-ODBC-INCORROUT INCORRECT NUMBER OF ROWS RETURNED WH An application uses a forward only cursor and block fetches. The application sets the statement property SQL_MAX_ROWS to some small value to limit the number of rows returned. Instead of returning SQL_NO_DATA_FOUND after the MAX ROWS has been fetched the ODBC driver returns MAX_ROWS of data for each block of data that can be fetched. For example: Assume each row is 1K, blocking is set to 32K, 100 rows are in the result set and SQL_MAX_ROWS is 10. ODBC returns: Rows 0-9, 32-41, 64-73, 96-100. APAR = SA93212 CA400EXP-ODBC-INCORROUT SQL_MAX_LENGTH SQLSETSTMTOPTION Using the SQLSetStmtOption to set the SQL_MAX_LENGTH or the newer SQLSetStmtAttr function to set the SQL_ATTR_MAX_LENGTH will not result in any errors from our driver but when character data is fetched, the output will quite likely be incorrect. 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 retieve 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 were returned but the value indicating the size of the returned data was incorrect, rather than getting the size of the returned data, we got the size of the SQL_MAX_LENGTH. Testing with the V5R1 ODBC driver revealed that there are no such problems with that driver. APAR = SA93266 CA400EXP-ODBC-INCORROUT NUMERIC KEYS CAN CAUSE RECORDS TO SH Linked tables in Microsoft Access 2000 may show records as #deleted rather than showing the data. If the table has a key field defined which is a numeric field, then the record will be displayed as #deleted if this key field contains a non-zero value between -1 and 1 (i.e. the absolute value is less than one but greater than zero, for example 0.123). The reason this is happening is due to the way in which Access is comparing the key values it retrieved versus the values it retrieves later when it retrieves all of the fields. This is a numeric field but they request that the ODBC driver convert the data to a character string. Our driver converts the character string and includes the leading zero (e.g. '0.123'). The ODBC version 3.x specification states that the leading zero should be supressed when numeric values whose absolute value are between 0 and 1 are converted to character representations. Our V4 drivers were written to conform with the version 2.x ODBC specification which didn't define whether the leading zeros should be included or suppressed. CAUTION: All the numbers between 0 - 1, now have the leading zero ( .123) omitted. If your application requires a leading zero, then you will need to change your application to add this. APAR = SA93486 CA400EXP-ODBC-WAIT ADDITIONAL OPTION TO DISABLE PROMPTING Client Access Express ODBC driver shows a prompting window when an invalid user ID and/or password is passed to SQLConnect instead of returning SQL state of 28000. Applications that run as service programs do not expect the prompting and appear hung in this situation. One common application that requires this function is Seagate Crystal Reports. APAR = SA93828 CA400EXP-ODBC-INCORROUT MAXIMUM FIELD DATA RETURNED PARAMETE Configuring a File DSN through ODBC Administrator results in the "Maximum Field Data Returned" option always being reset to 32. Steps to reproduce : 1) Create a File DSN and set the "Maximum Field Data Returned" option to a value (e.g. 1024). 2) Close the ODBC Administrator. 3) When reopening the ODBC Administrator and editing the previously created File DSN , MAXIMUM FIELD DATA RETURNED parameter is always reset to default value 32. This happens with all CAEXP r450 levels, this doesn't happen with r510. APAR = SA93942 ODBC ERROR: SQLBINDPARAMETER PCBVALUE HAS TO BE SQL_NULL_DAT The driver does not correctly handle binding a parameter to an empty string. To bind a parameter to an empty string the application calls the SQLBindParameter API with the Strlen_or_IndPtr parameter set to 0. The driver mishandles this and reports SQL_ERROR when executing the statement. An error message of: "pcbvalue has to be equal to SQL_NULL_DATA, when rgbValue equals null." is reported as the problem. APAR = SA94177 CA400WINOPT-ODBC-INCORROUT LOCKED RECORD INDICATES EOF WITH The Client Access ODBC driver returns the incorrect result when an ODBC application fails to fetch a locked record using SQLExtendedFetch and a block size greater than 1. The ODBC driver returns SQL_SUCCESS and rowstatus values of SQL_ROW_NOROW for the locked row and all rows after the locked row. This result indicates EOF and not a locked row. In addition, the next fetch receives SQL_NO_DATA_FOUND even if the lock has been released. The driver should be returning SQL_SUCCESS_WITH_INFO. The row status buffer should be set to SQL_ROW_ERROR for each row not fetched. The error buffer should be filled with at least one error per row with SQLState 01S01 and an appropriate error message (SQL0913 or similar). A second fetch request should be sent to the server to retry the fetch from the locked row. The problem has been observed with R320, R440 and R450 versions of Client Access. The problem may not occur when the block size is very large. With very large block sizes a SQL0913 and SQL_ERROR may be returned. APAR = SA94178 CA400EXP-ODBC-INCORROUT - ERROR WITH SOME SCALAR FUNCTIONS If the driver does not recognize a scalar function, such as {fn QUARTER( A_DATE_FIELD ) }, the following error is reported: Unrecognizable or unsupported scalar function in vendor string. The driver should not report an error. The driver should also remove the leading {fn and trailing } like it does with other scalar functions. APAR = SA94179 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. OLE DB PROVIDER --------------- APAR = SA93087 CA400EXP-OLEDB-INCORROUT MSGILLEGAL OPERATION ON SP REFRESH With IBMDA400 provider, parameters for a stored procedure experience corruption if a VARCHAR input parameter is used. APAR = SA93824 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. AFP WORKBENCH VIEWER -------------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- This Service Pack includes PCOM4.3 CSD4 plus additional fixes. APAR = SA91132 CA400EXP - VB SCRIPT MACRO CAUSES ACTIVE SESSION TO CLOSE Using PC5250 emulation, session A (display) has a macro that automatically runs to launch session B (hidden printer session). The PC5250 printer session does start and hide, however this results in session A being hidden, and a PCSWS.EXE error. APAR = SA92551 CA400EXP-TERMEMUL-INCORROUT PC5250 VB SCRIPT MACROS RUNNING VB Script Macros running system request actions fail since SF64474 installation. Previous service pack SF63638 works fine. APAR = SA92722 CA400EXP-TERMEMUL-PC5250 STRPCO COMMAND CAUSES HANG STRPCO command causes PC5250 to hang. PC5250 session comes back after clicking on the desktop or another window and then clicking on the emulation session again. APAR = SA92862 CA400EXP-PC5250 TELNET PRINTER SESSION INCORROUT When multiple spool files are printed, they are incorrectly being printed as if they are one file in some cases. APAR = SA92940 CA400EXP-CREATE MULTIPLE SESSIONS GIVES PAGE FAULT Creating multiple sessions with Client Access Express PC5250 give page fault errors on Window ME. APAR = SA92972 CA400EXP -PAGE SETUP GREYED OUT AFTER PRINT SCREEN When doing a print screen from a Client Access display session it greys out the page setup. You have to then goto file/printer setup and reselect a printer. You then have the option to use page setup until another print screen is done. APAR = SA93055 CA400EXP-DBCS HPT FOR SESSION TYPE Need a change of session type (AS/400 provides DBCS HPT for session type 3812, not 5553). APAR = SA93125 CA400EXP-TERMEMUL-UNPRED PC5250 CURSOR JUMPS TO WRONG POSITI After the user makes an incorrect input in the entry mask (DSPF) of his CA5250 application screen and hits the RESET/CTRL key the cursor doesn't jump to field which is incorrect filled in. The problem doesn't occur with the AS/400 workstation. APAR = SA93198 CA400EXP-TERMEMUL-INCORROUT USING END OF FIELD KEY IN SOME O Using Client Access Express V4R5 with either service pack SF64217 or SF65345, remapping and using the END OF FIELD key may hang the session during data entry on some OEM applications. APAR = SA93283 PC5250-PRT-INCORROUT TRAY SELECTION DOES NOT WORK PC5250 does not generate a Select Paper Tray command =X/1b7e46 when she receive PPM command = x/2bd20a48 if the tray number is same as before. It should not be suppressed on Windows environ- ment since other application is also using printer and might specify the paper tray. APAR = SA93313 CA400EXP - PC5250 PRESSING TAB KEY IN DBU HANGS SESSION After applying SF65345 and using PC5250 emulation, if either the Tab key or the F10 key are pressed when in DBU, the session hangs. APAR = SA93315 CA400EXP-TERMEMUL-PC5250 SESSION HANGS WITH EDTMSK FIELD After applying SF65345, the PC5250 session hangs when filling in the field defined by DDS EDTMSK with data. APAR = SA93322 CA400EXP-TERMEMUL-INCORROUT PC5250 SESSIONS HANG WITH F10 After applying SF65345, when navigating through an OEM application menu and the F10 key is pressed, the PC5250 PC5250 session hangs. APAR = SA93338 CA400EXP - WORDWRAP ON EMULATOR FAILS TO REMOVE NULLS OR When using the DDS keyword for wordwrap on a CAE Emulator nulls are not removed after a word has been wrapped. APAR = SA93434 CA400EXP-TERMEMUL-INCORROUT PC5250 CURSOR POSITIONING DOESN' Cursor positioning doesn't work on PC5250 display sessions, since SF65345 installation. APAR = SA93479 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 = SA93493 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 = SA93501 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 = SA93574 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 = SA93577 CA400EXP-TERMEMUL-INCORROUT HOTSPOTS WITH MAILTO URL Trying to create a mail link from an emulator session to a PC email program with MAILTO://name@domain HOTSPOT, results in '//' placed into 'to' field. APAR = SA93837 CA400EXP-PC5250 INCORRECT IME CONVERSION IME conversion is not working properly. PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- APAR = SA93188 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. SCS PRINT DRIVER ---------------- APAR = SA92649 CA400EXP- UNPRED SCS PRINTER DRIVER HANGS WINNT WIN2000 The 5.03 version of the SCS printer driver shipped with Client Access Express for Windows may cause a hang condition when a user attempts to change the conversion table used by the driver. APAR = SA92818 CA400EXP-INCORROUT SCS FONT CHANGES ON D/T423 Using the IBM SCS printer driver and printing to d/t 4234 printer, the font changes point size. AS/400 OPERATIONS CONSOLE ------------------------- APAR = SA92250 CA400EXP-OPCON-INCORROUT RCP CONNECTION FAILS TO CONNECT TO 27x and 8xx AS/400 Systems require a specific cable connection between the Debug port on the AS/400 and a parallel port on the PC that has been configured to use EPP. The documented requirement is that the PC Parallel Port be EPP 1.9 compliant. Most PCs that meet this requirement fail to connect and in some cases will connect but cause the AS/400 to IPL. APAR = SA92755 CA400EXP-OPCON -MSGACCESS WAS DENIED BECAUSE THE USERNAME/AN When using a PC with Windows 2000 as an RCS to connect to a Windows 2000 LCS that logs onto a domain, Client Access V4R5M0 Operations Console, the RCS receives the following error when trying to connect to the LCS "Access was denied because the username/and or password was invalid on the domain". The code has been changed to call the Microsoft Dial-up networking dialogs to prompt the user for a userid and password. This allows the user to enter the userid, password, and domain they want to validate to. Apply this PTF to correct the problem. APAR = SA93051 CA400EXP-OPCON-MSGCPF5140 OPERATIONS CONSOLE RANDOMLY DROPS Since upgrading to R450 OS/400 and Client Access Express R450 the customer's nightly CL program that does a delay job every 1 second until a predetermined time then starts a savsys, followed by several savlib commands, then restarts all of the subsystems will fail at various times about once every 10 days. The failure is always accompanied by a msgCPF5140 in the joblog for the CL. The CWBOPCON.LOG file contains a corresponding entry that indicates the PC is initiating a new console connection that starts by doing an END RAS CONNECTION that ends the connection to the system. This process causes the console display session on the AS/400 to end, which in turn ends the interactive CL job, then starts a new console connection/session. This same CL job was run in the same manner on the system at R430 with Client Access for Windows 95/NT R320 Operations Console with no problem. Operations Console was not waiting long enough while detecting if the system was still there. The length of time to wait before detecting the system had been IPLed or powered off has been extended. Apply this PTF to correct the problem. CLIENT ACCESS EXPRESS TOOLKIT ----------------------------- HEADER, LIBRARY, AND DOCUMENTATION ---------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. --------------------------------- Service Pack Level = SF65345 Build date = April 2001 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SA91076 CA400EXP CONNECTION INCORROUT CWBCFG DFLT USER NOT UPD WIN2K APAR = SA91383 CA400EXP-CONNECTIONS-INCORROUT CLIENT ACCESS EXPRESS CWBCFG APAR = SA92058 CA400EXP-OPNAV-HWINV-INCORROUT DISK UNITS NOT SHOWN APAR = SA92357 CA400EXP-UPDATE DIRECTORY UPDATE FAILS WHEN A DBCS FILE NAME APAR = SA92679 CA400EXP CLIENT ACCESS PROPERTIES SECURE SOCKETS PAGE APAR = SA92693 CA400EXP-OPNAV PRINTER LIST ERRORS ON V5R1 SYSTEM 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 --------------------------------- No fixes. BASIC OPERATIONS ---------------- No fixes. JOB MANAGEMENT -------------- No fixes. CONFIGURATION AND SERVICE ------------------------- No fixes. NETWORK ------- APAR = SA92692 CA400EXP-OPNAV PPP LINE CFG ERROR USING 2771 INT MODEM APAR = SA92691 CA400EXP-OPNAV UCW 2771 PORT 0 CREATES RS232/V24 MODEM SECURITY -------- No fixes. USERS AND GROUPS ---------------- No fixes. DATABASE -------- No fixes. FILE SYSTEMS ------------ No fixes. MULTIMEDIA ---------- No fixes. BACKUP ------ APAR = SA90077 CA400WINOPT-APIS-UPDATE-INCORROUT OPS NAV BACKUP FILE LIST APPLICATION DEVELOPMENT ----------------------- No fixes. MANAGEMENT CENTRAL ------------------ APAR = SA92690 CA400EXP-OPNAV ADD EXTREME SUPPORT TO MC APPLICATION ADMINISTRATION -------------------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SA90042 CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD WITH CSV FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. DATA TRANSFER WK4 FILE SUPPORT ------------------------------ No fixes. ODBC ---- APAR = SA88998 CA400EXP-ODBC INVALID DATA RETRIEVED FROM DBCLOB COLUMNS APAR = SA90924 CA400EXP-ODBC PROBLEMS PROCESSING HOST ERRORS ON SQLFREESTMT APAR = SA91139 CA400EXP-ODBC WRONG VALUE RETURNED FOR SQL_ACTIVE_STATEMENTS APAR = SA91323 CA400EXP-ODBC ADDITIONAL OPTION TO DISABLE PROMPTING APAR = SA91326 CA400WINOPT-ODBC DATA TRUNCATION PROBLEMS WHEN FETCHING DATA APAR = SA91779 CA400EXP-ODBC FAILURE ON PROCEDURE CALL WITH PARAMETER NAMES APAR = SA91795 CA400EXP-ODBC-MSGSQL0106 FAILURE WHEN CREATING A TABLE APAR = SA91821 CA400EXP-ODBC INVALID VALUE RETURNED FOR FLOAT DATA TYPES APAR = SA92237 CA400EXP-ODBC ERROR WHEN RETRIEVING THE 24:00:00 TIME VALUE APAR = SA92484 CA400EXP-ODBC-INCORROUT WRONG SQLSTATE VALUE RETURNED OLE DB PROVIDER --------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- This Service Pack includes PCOM4.3 CSD4 plus additional fixes. APAR = SA91031 CA400EXP - WRONG KEY OUTPUT ON BELGIUM KEYBOARD APAR = SA91103 CA400EXP-OPNAV-INCORROUT DISPLAY EMULATOR (PC5250) VIA OPNAV APAR = SA91293 CA400EXP-TERMEMUL INCORRECT CURSOR POSITION FOR PC5250 APAR = SA91529 CA400EXP-PC5250 RESET AND FUNCTION KEYS STOP RESPONDING APAR = SA91943 CA400EXP-TERMEMUL-INCORROUT BEEP API NOT SENDING SOUND TO APAR = SA92262 CA400EXP-SECURITY-MSGCPF1393 USER PROFILE BEING DISABLED WHE APAR = SA92288 CA400EXP - PC5250 DEVICE IN USE MESSAGE IS NOT CLEARED APAR = SA92481 CA400EXP-TERMEMUL-INCORROUT SESSION HANG WITH BREAK MESSAGE APAR = SA92250 CA400EXP- PC5250 VB SCRIPT MACROS CAUSE PCSMMERR.LOG TO GROW APAR = SA92680 CA400WINOPT-PC5250 UNABLE TO CUSTOMIZE POPUP KEYPAD APAR = SA92681 CA400WINOPT-TERMEMUL-INCORROUT KEY MAPPED TO NEWLINE SPACES APAR = SA92682 CA400EXP-PRINTEMUL INCORRECT OUTPUT OF LATIN2 CHARACTERS APAR = SA92683 CA400WINOPT-TERMEMUL-INCORROUT DSPF FIELD WITH CHECK(RL) AND APAR = SA92684 CA400WINOPT-TERMEMUL-INCORROUT ERROR MESSAGES FLASH ON SCREE APAR = SA92685 CA400WINOPT-TERMEMUL CURSOR POSITIONING WITH MENUS APAR = SA92686 CA400WINOPT CURSOR MOVEMENT BETWEEN FIELDS WITH CHECK(RLTB) APAR = SA92687 CA400WINOPT PC5250 DATA NOT SHOWN EXCEPT WHERE CURSOR IS POS APAR = SA92688 CA400WINOPT - PC5250 CURSOR POSITIONING PROBLEM APAR = SA92689 CA400WINOPT - FIELD EXIT ON A MANDATORY FILL SIGNED NUMERIC APAR = SA92757 CA400EXP -PC5250 BREAK MESSAGE CAUSES SESSION TO HANG PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- No fixes. SCS PRINT DRIVER ---------------- No fixes. AS/400 OPERATIONS CONSOLE ------------------------- APAR = SA91185 CA400EXP OPCON EPP RCP AND CONSOLE ON WIN2000 CLIENT ACCESS EXPRESS TOOLKIT ----------------------------- HEADER, LIBRARY, AND DOCUMENTATION ---------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. --------------------------------- Service Pack Level = SF64217 Build date = October 2000 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SA89626 CA400EXP-SECURITY-WAIT NT PC W/ MS SMS 2.0 & XE1 UNPREDICTAB APAR = SA89784 CA400WINOPT-INCORROUT DATA XFER UPLOAD APAR = SA91035 CA400WINOPT-APIS-OBJPRINT-INCORROUT PAGE WIDTH WRONG EXPRESS OPTIONAL COMPONENTS --------------------------- DIRECTORY UPDATE ---------------- APAR = SA89200 CA400EXP-UPDATE-MSGCWBUP4249 UPDATE FAILS WITH DBCS FILENAME INCOMING REMOTE COMMAND ----------------------- No fixes. MAPI ---- No fixes. EXPRESS ONLINE USER'S GUIDE --------------------------- No fixes. AS/400 OPERATIONS NAVIGATOR --------------------------- OPERATIONS NAVIGATOR BASE SUPPORT --------------------------------- APAR = SA91042 CA400EXP-OPNAV AF JOURNAL ENTRY LOGGED TO QAUDJRN APAR = SA91043 CA400EXP-OPNAV INCORRECT CONVERSION OF '\' IN DBCS LANG BASIC OPERATIONS ---------------- Non-APAR fixes. JOB MANAGEMENT -------------- No fixes. CONFIGURATION AND SERVICE ------------------------- Non-APAR fixes. NETWORK ------- APAR = SA89644 CA400EXP-OPNAV-FILESYS-MSGCPF8A77 UNABLE TO CHANGE PERMISSIO APAR = SA91044 CA400EXP-OPNAV INTF PARM-2771/PORT2 PPP *LIN SET WRONG APAR = SA91045 CA400EXP-OPNAV ALLOW OPTICONNECT SUPPORT IN IP FILTERING APAR = SA91046 CA400EXP-OPNAV ADD SUPPORT FOR UNIVERSAL CONNECTION WIZARD APAR = SA91047 CA400EXP-OPNAV DNS GUI HANGS W/ LARGE NUMBER OF DOMAINS APAR = SA91048 CA400EXP-OPNAV ADD SUPPORT FOR INTERNET SETUP WIZARD SECURITY -------- No fixes. USERS AND GROUPS ---------------- No fixes. DATABASE -------- APAR = SA91049 CA400EXP-OPNAV VISUAL EXPLAIN FAILS IF COMMENT PRECEDES SQL FILE SYSTEMS ------------ No fixes. MULTIMEDIA ---------- No fixes. BACKUP ------ No fixes. APPLICATION DEVELOPMENT ----------------------- No fixes. MANAGEMENT CENTRAL ------------------ Non-APAR fixes. APPLICATION ADMINISTRATION -------------------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SA90042 CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD WITH CSV FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. DATA TRANSFER WK4 FILE SUPPORT ------------------------------ No fixes. ODBC ---- APAR = SA89304 CA400EXP-ODBC SYNTAX ERROR WITH MORE THAN 72 PARAMETERS APAR = SA89763 CA400EXP-ODBC-UNPRED MEMORY VIOLATION ON INSERT OPERATIONS APAR = SA89787 CA400EXP-ODBC ADDITIONAL SUPPORT TO CANCEL ODBC OPERATIONS APAR = SA89916 CA400EXP-ODBC WRONG PARAMETER SIZE RETURNED FOR LOB FIELDS APAR = SA90192 CA400EXP-ODBC SPACES ARE APPENDED AFTER THE DATA IN DBCS PCS APAR = SA90296 CA400EXP-ODBC SQLDESCRIBECOL RETURNS ZERO AS THE COLUMN SIZE APAR = SA90502 CA400EXP-ODBC JUST ONE RECORD BACK ON SELECT STATEMENTS APAR = SA90551 CA400EXP-ODBC DATA TRUNCATION ON BLOCK INSERT OPERATIONS APAR = SA91034 CA400EXP-ODBC ADDITIONAL SUPPORT FOR THE SIGNAL FUNCTION OLE DB PROVIDER --------------- APAR = SA88910 CA400EXP-OLEDB-MSGCWBNL0107 HEX ZERO IN FIELD NOT ALLOWED APAR = SA88914 CA400EXP-OLEDB-INCORROUT NULL FIELD PROPERTIES NOT SET AFP WORKBENCH VIEWER -------------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- This Service Pack includes PCOM4.3 CSD3 plus additional fixes. APAR = SA86984 CA400EXP- PC5250 PCSWS.EXE ERROR VIOLATION ACCESS APAR = SA87009 CA400EXP-TERMEMUL PCSCM CAUSES PAGE FAULT IN MODULE PCSLT52. APAR = SA87449 CA400EXP - FONT NOT RESTORED AFTER MAXIMIZING 27X132 SESSION APAR = SA87545 CA400WINOPT-PC5250 CURSOR JUMPS WHEN MESSAGE ON LINE 24 APAR = SA87842 CA400EXP-PRINT EMULATION PRINTING STOPS WITH MSGCPF5261 APAR = SA88073 CA400WINOPT-PC5250 WRONG CURSOR POSITION FOR DBCS FIELD APAR = SA88178 CA400EXP-PC5250 DISPLAY MEMBERS WITH WRKMBRPDM LOCKS SESSION APAR = SA88371 CA400EXP-PC5250 SYSTEM LANGUAGE AS KYBD LAYOUT CAUSES GPF APAR = SA88563 CA400WINOPT-CONNECTIONS PRINTER SESSION WILL NOT CONNECT APAR = SA88797 CA400EXP- WINDOWS 2000 RESTRICTED USER CLASS PROFILES CANNOT APAR = SA88937 CA400EXP - PC5250 ERROR WHEN SAVE SETTINGS IS DISABLED APAR = SA88989 CA400EXP- BACKSPACE RESULTS IN X'24'IN DATA FILES APAR = SA89328 CA400EXP-PC5250 AUTO-IME BEHAVIOR INCORROUT SPACE INTO THE F APAR = SA89333 CA400EXP- BACKSPACE KEY CAUSES ENTRY FIELD TO DISAPPEAR APAR = SA89362 CA400EXP- PC5250 INCORRECT CHARACTERS ON CUSTOMIZE KEYBOARD APAR = SA89793 CA400WINOPT - INCORROUT AN EXTRA BLANK PAGE AS THE LAST PAGE APAR = SA89794 CA400WINOPT-PRINTEMUL- DEVD NOT CREATED WITH ITALIAN CODE PA APAR = SA89795 CA400WINOPT-PC5250-INCORROUT DSPF WITH CNTFLD CHECK(RL) APAR = SA89797 CA400WINOPT- INACTIVE TIMEOUT NOT WORKING FOR AUTO-RECONNECT APAR = SA89798 CA400WINOPT-PC5250 PRINTER SESSION DEVICES REMAIN ACTIVE APAR = SA89799 CA400WINOPT - COPY PASTE FUNCTION CAUSES IPF WITH PCSWS APAR = SA89800 CA400WINOPT INCORROUT T-CHINESE CHARACTER F9DC PRINTS BLANK APAR = SA89801 CA400WINOPT-TERMEMUL-INCORROUT USING PC5250 DDE FUNCTION APAR = SA89802 CA400WINOPT-PC5250 DOWN ARROW ACTING AS ENTER APAR = SA89803 CA400WINOPT-TERMEMUL-INCORROUT END KEY HANGS PC5250 SESSIONS APAR = SA89804 CA400WINOPT-PC5250 KEYBOARD MAPPING ERRORS AFTER SF59923 APAR = SA89805 CA400WINOPT-PC5250 FIELD EXIT REQUIRED WITH DBCS OPEN FIELDS APAR = SA89806 CA400WINOPT-INCORROUT RIGHT MOUSE BUTTON CAUSES POPUP-KEYPAD APAR = SA89807 CA400WINOPT-PC5250 CHARACTER OVERLAP ON GRID LINE FOR PRINT APAR = SA89808 CA400WINOPT - RPG DISPLAY SCREEN MIS-ALIGNED WITH WORD WRAP APAR = SA89809 CA400WINOPT-PC5250 KEYSTROKE PROBLEM APAR = SA89810 CA400WINOPT-PC5250 REPEATED SYSREQ CAUSES SESSION HANG APAR = SA89811 CA400WINOPT- PC5250 WORDSPILL/CARRIER RETURN FAILS IN OV APAR = SA89812 CA400WINOPT-PC5250 DDE KEYSTROKE CAPTURE FUNCTION NOT WORKIN APAR = SA89813 CA400WINOPT-PC5250 UNDERLINE / BOLD ATTRIBUTES LOST IN OV400 APAR = SA89814 CA400WINOPT- PC5250 DATA ENTERED NOT VISIBLE AFTER SF59923 APAR = SA89858 CA400EXP-TERMEMUL-MSGMCH0601 CSRINPONLY SPECIFIED IN DSPF APAR = SA90022 CA400EXP PC5250 VISUAL BASIC MACROS WILL LOCK SESSION APAR = SA90520 OSP-MSGCPF5192-PAR CLIENT ACCESS EXPRESS PC5250 SESSIONS CAU APAR = SA90524 CA400WINOPT-PC5250 ERROR USING HP 970CXI DESKJET PRINTER APAR = SA90564 CA400WINOPT-PC5250 RESET KEY DOES NOT REMOVE SYS REQUEST APAR = SA90703 CA400EXP - PC5250 DOES NOT DISPLAY DATA IN SUBFILE CORRECTLY APAR = SA90807 CA400EXP- PC5250 REVERSE IMAGE DOES NOT WORK CORRECTLY APAR = SA90909 CA400EXP-PC5250 BLANK LINE INSERTED AFTER DBCS CAUSES HANG APAR = SA90915 CA400WINOPT-PC5250 FIRST LINE DISPLAYED INCORRECTLY APAR = SA91037 CA400WINOPT-PC5250 INCORROUT AUTO IME BEHAVIOR CORRECTION APAR = SA91038 CA400WINOPT-PC5250-INCORROUT SETTING NLS ON OR OFF USING MAC APAR = SA91039 CA400WINOPT-PC5250 NONDISPLAY FIELDS ARE DISPLAYED ON SCREEN APAR = SA91040 CA400WINOPT-PC5250 CURSOR POSITIONING PROBLEM APAR = SA91041 PC5250 EMULATOR CHANGES THE CURRENT ACTIVE WINDOW TO ITSELF PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- APAR = SA91036 CA400EXP-UNPRED AFP DRIVER BLUE SCREENS ON WINDOWS2000 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. --------------------------------- Service Pack Level = SF62213 Build date = May 2000 --------------------------------- EXPRESS REQUIRED PROGRAMS ------------------------- APAR = SA86951 CA400EXP-SECURITY-WAIT FLASH APP WHEN SIGNON DIALOG PENDING APAR = SA86954 CA400EXP-PERFM MEMORY LEAK WHEN ERROR WITH ACTIVEX OBJECTS APAR = SA87150 CA400EXP-APIS-DATQ FAULT WITH NT SP5 OR WIN2K APAR = SA87177 CA400EXP-APIS-INCORROUT DISTRIBUTED PROGRAM CALL (DPC) API APAR = SA87698 CA400EXP-ODBC-MSGCWB0999 AFTER APPLY OF SF60796 IN ODBC APAR = SA88328 CA400EXP-DTRANSFER-MSGCWBDB0052 DATA TRANSFER HALTS ON DOS APAR = SA88621 CA400EXP-DBACCESS INCORROUT OLEDB WILL NOT BE CHANGED BACK APAR = SA88734 CA400EXP-OPNAV-HWINV-INCORROUT ALLOW ACCESS TO 'DISK UNITS' APAR = SA88787 CA400EXP-OLEDB-MSGCWBNL0101 DBCS CONVERSION ERRORS EXPRESS OPTIONAL COMPONENTS --------------------------- DIRECTORY UPDATE ---------------- No fixes. INCOMING REMOTE COMMAND ----------------------- Non-APAR 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. JOB MANAGEMENT -------------- No fixes. CONFIGURATION AND SERVICE ------------------------- No fixes. NETWORK ------- APAR = SA88732 CA400EXP-OPNAV - VPN DEFAULT LIFETIMES REVERSED SECURITY -------- No fixes. USERS AND GROUPS ---------------- Non-APAR fixes. DATABASE -------- APAR = SA88524 CA400EXP-OPNAV-DBASE-UNPRED DATA TRUNCATED ERROR WHEN UPDATI APAR = SA88728 CA400EXP-OPNAV VISUAL EXPLAIN GRAPH WITH TEMP TABLE FAILS APAR = SA88729 CA400EXP-OPNAV VISUAL-EXPLAIN-ONLY SHOWS NO PICTURE APAR = SA88730 CA400EXP-OPNAV VISUAL EXPLAIN FAILS IF SYSTEM NAMING USED APAR = SA88731 CA400EXP-OPNAV SQL0204 WHEN USE MENU IN RUN SQL SCRIPTS APAR = SA88733 CA400EXP-OPNAV HANDLE MULTIPLE PROCEDURES WITH SAME NAME FILE SYSTEMS ------------ No fixes. MULTIMEDIA ---------- No fixes. BACKUP ------ No fixes. APPLICATION DEVELOPMENT ----------------------- No fixes. MANAGEMENT CENTRAL ------------------ Non-APAR fixes. APPLICATION ADMINISTRATION -------------------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SA86088 CA400EXP-DTRANSFER TRANSFER FROM GIVES APPLICATION ERROR APAR = SA86952 CA400EXP-DTRANSFER UPLOAD FAILS WITH NON-ENGLISH CCSID APAR = SA88575 CA400EXP-DTRANSFER RTO FILES GIVE BAD DECIMAL SEPARATOR DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. DATA TRANSFER WK4 FILE SUPPORT ------------------------------ No fixes. ODBC ---- APAR = SA85355 CA400EXP-ODBC-MSGSQL0518 TAB CHARACTER AFTER SELECT KEYWORD APAR = SA85421 CA400EXP-ODBC CONNECTION FAILURE WHEN USING A MANAGED DSN APAR = SA85634 CA400EXP-ODBC SQL STATEMENTS FAIL IN A REMOTE SYSTEM APAR = SA85635 CA400EXP-ODBC PERMISSIONS TO A DATA SOURCE ARE LOST APAR = SA85636 CA400EXP-ODBC DATA TRUNCATED WHEN INSERTING SMALL VALUES APAR = SA85856 CA400EXP-ODBC SYNTAX ERROR ON NESTED LEFT OUTER JOINS APAR = SA85892 CA400EXP-ODBC ADDITIONAL FIXES FOR MULTITHREAD ENVIRONMENTS APAR = SA85893 CA400WINOPT-ODBC FAILURE WHEN THE LOCAL CACHE IS USED APAR = SA86302 CA400EXP-ODBC FAILURES WHEN EXTENDED DYNAMIC IS ENABLED APAR = SA86569 CA400EXP-ODBC DEFAULT PACKAGE LIBRARY NAME IS IGNORED APAR = SA86653 CA400EXP-ODBC SQLGETDATA IGNORES THE BUFFERLENGTH PARAMETER APAR = SA86802 CA400EXP-ODBC ERROR WHEN A MANAGED DSN IS CREATED APAR = SA86949 CA400EXP-ODBC THE PIROW PARAMETER IS NOT CORRECTLY SET APAR = SA86950 CA400EXP-ODBC DOUBLE PROMPTING ON ODBC CONNECTIONS APAR = SA87366 CA400EXP-ODBC SUPPORT FOR TRUE AUTOCOMMIT APAR = SA87837 CA400EXP-ODBC STATEMENTS WITH SCALAR FUNCTIONS ARE TRUNCATED APAR = SA88129 CA400EXP-ODBC BINARY DATA IS TRUNCATED ON INSERT OPERATIONS APAR = SA88405 CA400EXP-ODBC SQLGETTYPEINFO RETURNS WRONG TYPE INFORMATION APAR = SA88718 CA400EXP-ODBC RETRIEVE THE ACTUAL LENGTH FOR LOB LOCATORS OLE DB PROVIDER --------------- APAR = SA87735 CA400EXP-OLEDB CONNECTION INTERMITTENTLY FAILS APAR = SA88719 CA400EXP-OLEDB MISCELLANEOUS FIXES APAR = SA88622 CA400EXP-DBACCESS-INCORROUT OLEDB DATA CONVERSION AFP WORKBENCH VIEWER -------------------- APAR = SA88722 CA400EXP-AFPVIEWER-INCORROUT HEBREW TEXT INCORRECT 5250 Display and Printer Emulation ---------------------------------- APAR = SA84062 CA400EXP-SSL-INCORROUT CLIENT ACCESS EXPRESS SSL CONNECTION APAR = SA85076 CA400EXP-PC5250 CONNECTION THRU RAS GIVES INVALID PAGE FAULT APAR = SA85131 CA400EXP-PC5250 SESSION DOES NOT SWITCH BACK TO 24X80 APAR = SA85414 CA400EXP-TERMEMUL-INCORROUT LINE 25 STATUS BOX IS CHECKED AF APAR = SA85630 CA400WINOPT-PC5250-INCORROUT PCOMM DDE EXCEL PCSEDIT APAR = SA85642 CA400WINOPT- PC5250 SESSIONS FAIL TO MAXIMIZE APAR = SA85643 CA400WINOPT-PC5250-INCORROUT HALF INDEX UP/DOWN IN OV DOC APAR = SA85644 CA400WINOPT-PC5250-INCORROUT PAGE FAULT AFTER SELECTING FONT APAR = SA85645 CA400WINOPT-PC5250-INCORROUT MOUSE BUTTON NOT WORKING IN DDS APAR = SA85646 CA400WINOPT- FAILURE TO PRINT USER DEFINED DBCS FONT APAR = SA85647 CA400WINOPT-TERMEMUL-INCORROUT INSERT TURNED OFF AFTER PRINT APAR = SA85648 CA400WINOPT-PC5250 NEW LINE KEY WORKS INCORRECTLY AFTER SF57 APAR = SA85649 CA400WINOPT-TERMEMUL-AUTO FIELD EXIT BROKEN AFTER SF58125 APAR = SA85650 CA400WINOPT-PC5250 PAGE UP/DOWN DO NOT RESET AFTER SF55446 APAR = SA85651 PC5250 INCORROUT WRONG CURSOR POSITION APAR = SA85652 CA400WINOPT-PC5250 HPT CONFIGURATION WIZARD FOR PRINTER SESS APAR = SA85653 CA400WINOPT PCSTLNET.DLL FAILS APAR = SA85724 CA400EXP - NEW ENHANCEMENTS FOR PC5250 APAR = SA85891 CA400EXP- CURSOR CHANGES POSITION WHEN START RECORDING MACRO APAR = SA85894 CA400WINOPT-PC5250 LIGHT PEN INCORROUT IN PROTECTED FIELDS APAR = SA86140 CA400EXP-TERMEMUL- COLUMN SEPARATORS NO LONGER VISIBLE APAR = SA86771 CA400EXP-TERMEMUL-INCORROUT SCREENPRINT PRINTER SETUP NOT SA APAR = SA86956 CA400WINOPT-PRINTEMUL-INCORROUT PC5250 PRINTER SESSION CHARA APAR = SA86957 CA400WINOPT-TERMEMUL-PC5250 OVER TCPIP CAUSES CPF5063 APAR = SA86958 PC5250 VIEWS NOT DISPLAYED IN THE SAME ORDER AS SAVED APAR = SA86959 CA400EXP-PC5250-INCORROUT IBM3270-1250 FONT MISSING APAR = SA86960 CA400EXP-PC5250 ENHANCEMENTS APAR = SA87076 CA400EXP-PC5250 CHANGES MADE TO PRINTER SETUP ARE NOT SAVED APAR = SA87433 CA400EXP PC5250 TERMEMUL - DISPLAY SCREEN HANG WHERE DSPF HA APAR = SA87731 CA400EXP - PC5250 DBCS PRINT PROPERTIES NOT CHANGED AFTER SF APAR = SA87757 CA400EXP-PC5250 DOUBLE-CLICK ON KEYBOARD HOTSPOTS FAILS APAR = SA88150 CA400EXP - PC5250 BLINKING CURSOR FAILS TO ADVANCE APAR = SA88278 CA400EXP-PC5250 USB KEYBOARD FAILS WITH PCSWS037 PRINTER DRIVERS --------------- AFP PRINT DRIVER ---------------- APAR = SA88723 CA400EXP-INCORROUT AFP FAX BROWSE PROBLEM ON WINNT APAR = SA88724 CA400EXP-MSGCWBAF1100 AFP FAX DRIVER CONVERSION TABLE APAR = SA88725 CA400EXP-INCORROUT AFP FAX DRIVER MESSAGES TRUNCATED SCS PRINT DRIVER ---------------- APAR = SA88726 CA400WINOPT-NETPRINT-INCORROUT MEMORY PROBLEM IN SCS DRIVER APAR = SA88727 CA400EXP-UNPRED SCS PRINTER DRIVER BLUE SCREEN WINDOWS2000 AS/400 OPERATIONS CONSOLE ------------------------- APAR = SA86953 CA400EXP-OPCON-UNPRED OP CONSOLE FAILS TO RECONNECT APAR = SA88721 CA400EXP-OPCON REMOTE CONTROL PANEL SUPPORT ON WIN 2000 CLIENT ACCESS EXPRESS TOOLKIT ----------------------------- HEADER, LIBRARY, AND DOCUMENTATION ---------------------------------- Non-APAR fixes. VISUAL BASIC WIZARDS -------------------- 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 SFxxxxx 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.