============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R2M0 Cumulative Service Pack Level ------------- SI14294 ------------- (c) Copyright IBM Corporation 2002. All rights reserved. ======================================================================== Co-requisite PTF SI14295 is automatically included with any shipment or web download of SI14294. SI14295 exists only for packaging reasons. All service pack level references will be to SI14294. NOTICE: ------- Application of this PTF may disable or render ineffective programs that use system memory addresses not generated by the IBM translator, including programs that circumvent control technology designed to limit interactive capacity to purchased levels. This PTF may be a prerequisite for future PTFs. By applying this PTF you authorize and agree to the foregoing. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN iSeries SYSTEM 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE 2.0 RESTRICTIONS 2.1 iSeries NAVIGATOR 2.2 iSeries OPERATIONS CONSOLE 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI14294 (June 2004) 4.0 INSTALL/UNINSTALL CONSIDERATIONS 4.1 REMOVING THE SERVICE PACK 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? 4.3 SERVICE PACK CONTROL 5.0 DATA TRANSFER CONSIDERATIONS 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 --------------------------------------------------------------------- 1.0 INSTALLATION INSTRUCTIONS ------------------------------ 1.1 INSTALLING FROM AN iSeries SYSTEM -------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack through the iSeries PTF ordering process either as an individual PTF order or as part of an OS/400 PTF cumulative package. Once this service pack has been applied to an iSeries system with the LODPTF and APYPTF iSeries commands, it can be installed on individual PC's with the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Check Service Level, controlled by the iSeries Access for Windows Properties Service tab, will detect that the Service source directory has been updated, and will present the user with the option to install the service pack at startup time as well. The APYPTF will update the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) on the iSeries. Any client that installs iSeries Access for Windows (or selected components) from this image will automatically receive this service pack level (no extra steps or reboots). In this scenario, the service pack cannot be uninstalled on the client PC because it is merged in with the base release. Running setupsp.bat from the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) will launch the service pack install wizard. View setupsp.bat via Notepad or Wordpad to see instructions on how to invoke setupsp.bat to record or run a silent service pack install. RMVPTF will restore your iSeries install image to the prior service level (or the base release if there was no prior service pack applied). 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE --------------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack as a set of install image files. Install the service pack by running the "SETUP.EXE" program from your PC. This program is part of the install image files shipped with a service pack. If you change the iSeries Access for Windows Properties Service tab Source Directory to the directory containing these install image files, you can also use the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Before running this program, copy the service pack install image files to a local drive on your PC or to any accessible network drive. Once the install setup program has completed, you can then remove the install image files from that drive. 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE ------------------------------------------------------------------------------------- The following method could be used if you downloaded the service pack image from the iSeries Access for Windows web page location: http://www-1.ibm.com/servers/eserver/iseries/clientaccess/casp.htm The iSeries Access for Windows service pack PTFs are combined with the original iSeries Access for Windows installation image in QIBM\ProdData\Access\Windows\Install\Image NOTE: this directory is a symbolic link to QIBM\ProdData\CA400\Express\Install\Image There is one physical directory - either of these paths will access the directory. This means that a user can install (or upgrade) iSeries Access for Windows from this combined image directory and get the latest applied service level automatically in one integrated step - since the original installation image files have been replaced by updated versions via the service pack PTF. Selectively installing components from this combined image directory will also automatically get the latest applied service level for that component. If you tailor the Client Access Express install image to another directory (for instance, on another server), using the Create Tailored Installation Image (cwbinimg.bat) tool, you can use the PTFFORM.EXE download in the FTP directory to duplicate the function of applying the iSeries PTF by following these steps: 1. Download PTFFORM.EXE (from the tailored/ FTP directory) to a temporary directory. 2. Run PTFFORM.EXE to expand the service pack files and copy them into an iSeries Access for Windows installation image directory, replacing any existing files. 3. Delete PTFFORM.EXE after it has completed its processing. Now you have combined this service pack level with the iSeries Access for Windows installation image, so that users can install iSeries Access for Windows plus this service pack in one integrated step. Note that this procedure also works if the installation image has already been combined with a prior service pack level. This procedure will replace the prior service level in the combined image with this new level. Alternatively, if you have a full copy of the original iSeries Access for Windows install image in a directory, you can combine PTFFORM.EXE with this full image, using the same 3-step procedure detailed above. Then you can run Create Tailored Installation Image (cwbinimg.bat) from this full image directory, to create tailored image directories that will automatically have the service pack merged in. 2.0 RESTRICTIONS ----------------- 2.1 iSeries NAVIGATOR ---------------------- 1) Due to technology incompatibilities, occasionally a window can be displayed behind other windows when running the iSeries Navigator. If the iSeries Navigator looks like it has stopped working, it is possible that the window you are waiting for is being displayed behind another window on your desktop. Press the Alt key and then the Tab key to see a list of all the windows on your system and select window behind the iSeries Navigator window, or another window on your desktop. 2.2 iSeries OPERATIONS CONSOLE -------------------------------- 1) It is recommended that you restrict LAN topologies for LCS attachment to a single, physical ring/hub/switch fabric. In the event that the LCS is used in a larger network topology, broadcast (DHCP) packet filtering is always recommended. 2) The maximum number of concurrent active sessions via the PCOM 5250 emulator is 26. 3) If an automatic session re-connect to an OS/400 image on an iSeries or iSeries server on iSeries Operations Console start-up fails, simply use the manual re-connect process by right-clicking the connection profile that failed to re-connect and selecting 'Connect'. 2.3 Management Central -------------------------------- The problem identified regarding a Management Central File Monitor not triggering when "System logs" is the option selected for "Files to monitor" on the General property page has been resolved. IMPORTANT NOTE: You must also install V5R2 HOST PTF SI08454 in order to fix this problem. 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 = SI14294 Build date = June 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE13926: CA400EXP-CONNECTIONS-UNPRED NO CWBCFG KERBEROS SETTING The cwbcfg utility provides a parameter for configuring the signon mode of the connection being defined: /uid . All signon modes may be set using this parameter except the use of Kerberos. The /uid parameter of cwbcfg now accepts the value *KERBEROS which configures the connection to use Kerberos for authentication. For example: cwbcfg /host server1 /uid *KERBEROS creates a connection to server "server1" and configures it for all users of the PC, and for the Default User, so that Kerberos is used for authentication. Previously, the only allowed values were *WINLOGON, *PROMPTALWAYS, and an actual iSeries user ID. IMPORTANT NOTE: Although you can now configure the new connection to use Kerberos, authenticating this way may not work. One possible reason is that the new or changed connection is configured only for accounts local to the PC on which cwbcfg is run. Successful use of Kerberos may require logging on to a domain, and local account configuration information is not typically used for domain logons. This is no different from the case in which a user logs on to the local PC, then uses iSeries Navigator to configure a connection to use Kerberos as the means of authentication. APAR SE15016: SSL - Update default key database A VeriSign Global Server Intermediate Root CA certificate has expired on 01/07/2004. This CA certificate was included in the default SSL key database shipped with the product. Updated SSL key database files (cwbssldf.kdb and cwbssldf.sth) will be provided by this service pack. The new files will only be installed if the previous files are deleted or do not exist in the Common Documents folder. APAR SE15205: CA400EXP - Incorrect data passed to database server from XDA Windows client The correct data is not getting sent to the database server through the XDA Windows client, thus causing a MCH3601 error message to get passed back from the database server. The process of setting up the data buffer in the XDA Windows client was updated to pass the correct data to the database server. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- IMPORTANT NOTE for Management Central: You must also install V5R2 HOST PTF SI08454 in order to fix the problem identified regarding a Management Central File Monitor not triggering when "System logs" is the option selected for "Files to monitor" on the General property page. APAR SE12441: CA400EXP-OPNAV-NETWORK-MSGCPI0954 CREATE DISK TO MAX ASP USE Customer uses iSeries Navigator to create a disk drive for a Windows server. iSeries Navigator shows a message that indicates the maximum size that can be specified for the disk drive. If the user specifies the maximum size that iSeries Navigator indicates, then the ASP overflows and message CPI0954 is issued to QSYSOPR. The customer then must delete the disk drive and recreate it using a smaller size. If the size that they specify is still too large to fit in the ASP, message CPI0954 is issued again and they must start over. It may take several tries to get the disk drive size reduced enough so that the ASP does not overflow. The customer wants iSeries Navigator to give a better indication of the maximum disk drive size that will fit in the ASP so that they can create a disk drive that fills up the ASP without overflowing the ASP. iSeries Navigator was incorrectly calculating the amount of space that is available in the ASP. It showed a maximum disk capacity value that was larger than the actual size that would fit in the ASP. The maximum disk capacity calculation has been adjusted to give a more accurate indication of the disk size that will fit in the ASP. APAR SE12695: CA400EXP-OPNAV-NETWORK-PERFM Duplicate MX records in DNS configuration Duplicate MX records appear in BIND 8 DNS configuration that was migrated from BIND 4. The duplicate MX records will be removed the first time that the DNS configuration is saved after this PTF is applied. APAR SE13106: CA400EXP-OPNAV-NETWORK-INCORROUT change Service Agent login The existing login for Service Agent: login.secureip.URUS.AS400ESUS, needs to be changed to: login.internet.ACCT.USERID Change made to set the correct login for Service Agent. The following PTF need to be applied in the iSeries box in order to have Service Agent connecting with the new userid: PTF SI13334 APAR SE14236: CA400EXP-OPNAV ISERIES NAVIGATOR HANG LISTING PRINTER OUTPUT When opening iSeries Navigator, expand a system and click on Users and groups --> All users --> Right click a user --> select User Objects and select Printer Output, hangs, and iSeries Navigator has to be killed from the Windows Task Manager. APAR SE14302: OSP-DB INVALID OPERATIONS OH, UH, AND FH IN VISUAL EXPLAIN O In Visual Explain, on the Detailed Reports tab "Open Information" report, invalid operation types are returned. These types are: OH, UH, & FH APAR SE14408: CA400EXP-OPNAV-FILESYS-PERFM LONG DELAYS WHEN MOVING MULTIPL Long delays when trying to move files from one directory to another. Improved speed of file copies and context menu displays in File Systems hierarchy. APAR SE14555: CA400EXP-OPNAV-NETWORK-INCORROUT DNS ENABLES ADD HOST When the DNS is configured for Dynamic updates you are unable to add host manually. When you stop the server, you have to close the window and open it again in order to add a host manually. Submenu items for Foward Lookup Zone, and Reverse Lookup Zone nodes have been enabled when the server is stopped in order to add a host manually. APAR SE14558: CA400EXP-OPNAV-NETWORK-INCORROUT SMTP properties update fails A null exception error occurs when trying to update SMTP properties through iSeries Navigator. To the user, it appears that iSeries Navigator is not doing anything when the OK button is selected in SMTP Properties. The problem occurs when certain SMTP attributes are not defined in the configuration file, presumably after migration to a new release. The smpt changes are saved when you click ok, there was a record retrieved with a null value. This might happend when the system is migrated. APAR SE14563: CA400EXP-OPNAV-NETWORK PPP Navigator incorrect default for SBSD V5R2 Navigator - Network - Remote access services - Originator connection profiles - New Intranet or ISP Dial connection; by going through all steps of the wizard to create a new connection profile it is assigned to an invalid subsystem name by default: QUSWRK. It should be QUSRWRK. APAR SE14734: CA400EXP-OPNAV-INCORROUT CURRENT ADMINISTRATION SYSTEM/USER CAN NOT BE REMOVED The current Administration system/user pair is not removed if the system is taken out of service or if it is no longer configured as the Administration system, therefore iSeries Access keeps prompting for signon to the Administration System at Windows logon when the scan frequency time has been expired. APAR SE14799: CA400EXP-OPNAV Performance problem in Run SQL Scripts Attempting to execute thousands of statements in the Run SQL Scripts window keeps getting slower as statements are executed. APAR SE14800: CA400EXP-OPNAV-NETWORK-INCORROUT Webfacing settings not saved On TCP/IP configuration properties, when the user goes to the start tab and clicks on webfacing server. The selection is not saved. When the user clicks on TCP/IP properties and goes to the start tab and selects webfacing, now the selection is saved. The program wasn't getting the right string. APAR SE14802: CA400EXP-OPNAV-NETWORK-INCORROUT Netserver Single Signon failing due to uppercase keytab entries. Single signon is failing for Netserver due to problems with the Netserver Keytab entries created by the Network Authentication wizard. For both V5R2 and V5R3 versions of iSeries Navigator: The Network Authentication wizard will be updated so that the uppercase Netserver keytab entries are no longer created. These keytab entries begin with 'HOST/Q' and 'cifs/Q'. After applying the service pack, rerun the Network Authentication configuration wizard and these duplicate uppercase Netserver entries will be removed. For the V5R2 version of iSeries Navigator: Several of the Network Authentication Services (NAS) configuration tasks can be automated by creating a batch file of commands for you to run on the Windows Active Directory server. An enhancement has been made to the NAS configuration wizard in this service pack to generate this batch file. To generate the batch file you must create the QKRBKTBATF data area in the QUSRSYS library before running the NAS configuration wizard. The following is an example of the command that can be run on a V5R2 iSeries system where Network Authentication Service is about to be configured. This command will cause the NAS configuration wizard to create the C:\Temp\NasCfg_sysname.bat batch file. In this example, the batch file will be created with configuration commands that contain passwords. CRTDTAARA DTAARA(QUSRSYS/QKRBKTBATF) TYPE(*CHAR) LEN(100) VALUE('P C:\Temp\NasCfg_sysname.bat') TEXT('NAS configuration bat file info with passwords') Once this command has completed, sign on to the V5R2 iSeries system using iSeries Navigator. Run the NAS configuration wizard to configure Network Authentication Service on the system. The batch file will be created when the NAS configuration wizard completes. The format of the QUSRSYS/QKRBKTBATF data area is as follows: Characters 1 & 2 : "P " to include passwords in the batch file "NP" to indicate that passwords will NOT be included in the batch file Characters 3 - # : Contains the fully qualified file name for the batch file. If no name is specified, a default name will be generated. The filename will be displayed at the completion of the NAS wizard. Warning: If you choose to include passwords in your batch file, they will be in clear text and viewable to anyone with read access to the batch file. Delete this file immediately after using! If you do not include passwords in the batch file, you will be prompted for each password when the batch file is run. APAR SE14968: CA400EXP-OPNAV- PRINTER OUTPUT ACTION ERROR IN OUTQ SHORTCUT An error is generated when you double click on a printer output file that is located in an output queue shortcut. The file may also not have any actions displayed in it's context menu. APAR SE15219: CA400EXP-OPNAV-OUTPUT-INCORROUT SPOOLED FILE LIST INCOMPLETE Opening an output queue in iSeries Navigator Work Management may result in a list of spooled files that appears empty even though files do exist on the output queue. APAR SE15222: CA400EXP-OPNAV-INCORROUT Error removing user in Customize Access dialog Problem occurs on V5R2M0 SI10914 or V5R3M0 GA with Windows XP and Windows 2000. Error occurs on the Local Settings Application Administration Customization dialog when attempting to remove a single user from the Access Allowed or Access Denied lists via the Remove or Remove Customization buttons. APAR SE15235: OSP-DB TIME LABEL INCORRECT ON TOTAL RUNTIME LABEL IN INAV S Detailed reports for SQL Performance Monitor's Analyze Results function was reporting total runtime as microseconds when it has actually been converted to seconds. The headings on the SQL Performance Monitor's Analyze Results indicate that total runtime is represented in seconds. CIRCUMVENTION: The data returned in the report is correctly represented in seconds. The heading for the total runtime column is misleading. APAR SE15899: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DELETE HOST DYNAMIC The DNS server can't perform a Dynamic zone host deletion when it is running. The delete option for a dynamic zone host is only available when the server is stopped before opening the configuration window. When the server is brought from start to stop inside the configuration window the GUI seems to perform the deletion but it doesn't occur. Enable delete option for a dynamic zone host when the server is stopped before opening the configuration window. After that if the DNS server is started or stopped inside the configuration window the delete option for dynamic zones will be disabled. APAR SE15929: CA400EXP-OPNAV-NETWORK-INCORROUT DNS needs to validate subnet field In the new Primary Zone Wizard, on the first page, type in any invalid subnet number (i.e. 99999.99999) and continue on through the wizard and will allow creating an invalid zone. Add validation for the subnet field. APAR SE15930: CA400EXP-OPNAV-NETWORK-INCORROUT SMTP 3 PARAMETERS OUT 3 POP parameters are not supported anymore for V5R3, and this doesn't allow changing the SMTP properties when you use a V5R3 system. 3 parameters for the CHGPOPA will be taken out. APAR SE16141: CA400EXP-OPNAV SQL7008 WHEN EDIT TABLE IN CHINESE When connected to Chinese server, trying to edit a table using iSeries Navigator database causes SQL7008 to appear. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE13715: CA400EXP-DTRANSFER-INCORROUT CREATE ISERIES DATABASE FILE Data transfer "Create iSeries database file..." wizard scan of a PC CSV file detects a blank character field (seen in Notepad as a set of double quotes) as a numeric field. APAR SE15151: CA400EXP-DTRANSFER-INCORROUT UNICODE data conversion error using automation The iSeries Access for Windows DataTransfer ActiveX automation object or rxferpcb command line utility is used to execute a datatransfer upload request (dtt file). If the user profile name used for the request is 10 characters long then the transfer request fails with the error message: A UNICODE data conversion error occured while processing the transfer request. Profiles names that are 9 characters or shorter work fine, as do download requests (dtf files). APAR SE15339: CA400EXP-DTRANSFER-MSGCWBDB0052 DATA TFR DOWNLOAD TO HTML Data Transfer download output to a HTML file converting to UTF-8 results in message CWBDB0052 or CWBTF.EXE terminates when downloading DBCS data. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE15357: CA400EXP-DTRANSFER-INCORROUT INVALID DATE/TIME SEPARATORS ENABLED In the Excel Wizard, Properties page, when a date/time format that does not allow selectable date/time separators is chosen, the separators are enabled back when the Properties page is accessed again. ODBC ---- APAR SE14242: CA400EXP-ODBC-MSGCPF5035 OVERLAY OF PARAMETER DATA ON SECON Applications call the ODBC API SQLBindParameter to bind data for parameter markers. The ParameterType and ColumnSize options on the SQLBindParameter call allow a user to specify values that correspond to the server field's data type and size. If a user specifies data types that don't match well with the server field, problems can occur. In one scenario, the following sequence of steps resulted in a syntax error: 1. SQLBindParameter called with bad information for ParameterType and ColumnSize 2. SQLPrepare 3. SQLExecute works successfully 4. SQLBindParameter called with bad information for ParameterType and ColumnSize 5. SQLExecute returns a syntax error APAR SE14415: CA400EXP-ODBC-INCORROUT - RETURN TIME, DATE, TIMESTAMP AS SQL_CHAR The ODBC-defined data type for date (SQL_TYPE_DATE), time (SQL_TYPE_TIME), and timestamp (SQL_TYPE_TIMESTAMP) do not allow for all possible iSeries date, time, and timestamp values to be returned in them. For example, with an iSeries time value of 24:00:00, the ODBC data type of SQL_TYPE_TIME can not handle this as it is defined for the largest possible time to be 23:59:59. To give a way for an application to work with those fields more easily, an enhancement is necessary so that the ODBC driver reports those fields as SQL_CHAR. This PTF provides the new functionality. APAR SE14963: CA400EXP SQLEXTENDEDFETCH RETURNS PWS0001 RETURNING DATA FRO An ODBC application calls SQLTables and uses the SQLExtendedFetch API to retrieve the rows in the result set. When SQLExtendedFetch is called and there are no more rows left to retrieve, the driver should return SQL_NO_DATA_FOUND, but instead returns a PWS0001 message. APAR SE15598: CA400EXP-ODBC-UNPRED SQLSETPOS RETURNS DRIVER NOT CAPABLE ER An application uses Microsoft RDO and iSeries Access for Windows ODBC to access lob fields. The application uses a block size of 100 rows on the fetch, then attempts to use SQLSetPos and SQLGetData to access the lob data. The ODBC driver returns SQLState S1C00 "Driver not capable" on the SQLGetData api. The error is caused because the odbc driver does not support positioning to a specific row in a block fetch when the requested block size is greater than 1. This restriction is described in the ODBC driver metadata via the SQLGetInfo SQL_GETDATA_EXTENSIONS API. The driver is adding support so that SQLSetPos can be called to position to the first row in a rowset. The driver will return the "driver not capable" error on a SQLSetPos call if an attempt is made using this API to position to a row beyond on the first in the rowset. APAR SE15814: CA400EXP-ODBC CATALOG_NAME NAMES ARE PADDED WITH SPACES The driver is incorrectly blank padding the TABLE_CAT field when the SQLTables API is called to get a list of catalogs. The SQLTables call that causes the problem is when CatalogName is set to SQL_ALL_CATALOGS (%) and the SchemaName and TableName arguments are empty-strings. APAR SE15895: CA400EXP-ODBC-MSGINTERNAL DRIVER ERROR INTERMITTENT FAULT IN Applications such as Microsoft SQL Server and Microsoft IIS that use the iSeries Access for Windows odbc driver may encounter intermittent faults or hangs in cwbodbc.dll. Multiple threads may appear to hang on SQLDriverConnect, SQLFreeConnect. A client access detail trace will show that an attempt to free the environment handle never completed. APAR SE16131: CA400EXP-ODBC-UNPRED - PACKAGE PROBLEM WITH STATEMENT IN USE Statements that do not contain parameter markers can incorrectly be added into an SQL package. This occurs if an application uses the same ODBC statement handle for two different SQL statements. If the first statement gets added to the package, the 2nd one gets added too. This can cause problems where a user would see a "statement in use" error. OLE DB PROVIDER --------------- APAR SE14470: CA400EXP-OLEDB-INCORROUT ZERO LENGTH PARAMETER DATA INCORREC OLEDB is incorrectly padding for a zero length string given for parameter data. In this case the parameter is described as graphic CCSID 13488(UNICODE). OLEDB sends the parameter data to the host indicating the data is in CCSID 13488 but the actual data is all X'40's. It appears that the padded data is in EBCDIC rather than UNICODE. This only occurs on a zero length string. If any real data is given then the rest of the string is padded correctly. This can cause incorrect data to be inserted, updated, etc. APAR SE14643: CA400EXP-OLEDB-INCORROUT SQL Server hangs Hang in SQL Server when working with out-of-process linked servers. APAR SE15809: CA400EXP-OLEDB-MSGCPF9810 TABLE NAME LISTED AS THE LIBRARY Using record level access with the iSeries Access for Windows OLE DB provider to open a table through ADO fails with message CPF9810. The error lists the table name as the name of the library in the error message. This problem occurs when the library name is a substring of the system name. For example if the system name is MYSYSTEM and the library was MYSYS and the table name was MYTABLE, the command text in ADO would be: "/QSYS.LIB/MYSYS.LIB/MYTABLE.FILE/*FIRST.MBR(*FIRST,*NONE)" Opening the recordest object results in error CPF9810: Library MYTABLE not found. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR SE12423: CA400EXP-TERMEMUL-INCORROUT CHARACTERS NOT CHANGED TO UPPERC V5R2M0 SI08894 and Czech Keyboard. The s-caron and the r-caron are not appearing in upper case when typed in signon field APAR SE13208: OSP-PAR CLIENT ACCESS MARGIN SETTINGS LOST AFTER FIRST PRINT On printer session using Windows GDI printer driver, File - Page Setup - Margins setings are saved, but the first spooled file to print after the session is re-started reverts both top and left margin settings back to the 0.5" default margin. APAR SE13349: CA400EXP-TERMEMUL-DBCS U/3010(EBCDIC:X/4466) CANNOT DISPLAY The customer created Code page 1399(Unicode) session. When he input character u/3010(Left Black Lenticular Bracket), it didn't appear correctly. However, once another DBCS character stays infront of the character, it appears correctly. I took host print screen copy -> cpysplf to PF then checked the Kanji code. Both cases, u/0310 appeared x/4466 which was correct Kanji. APAR SE13658: CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE ISSUE ON JAPANESE Copy paste fails to function as expected. APAR SE13859: OSP-PAR RUNTIME ERROR. ABNORMAL PROGRAM TERMINATION. Problems running consecutive macros. An enduser at one time, can run up to 50 macros consecutively and repeat this process throughout the day. APAR SE13964: CA400EXP-TERMEMUL-INCORROUT DATA IN BLINKING FIELDS DOES NOT When screen is refreshed the data in blinking fields disappears or does not display after applying SI10376. APAR SE13971: OSP-PAR USING VBSCRIPT MACROS MULTIPLE TIMES IN PC5250 HANGS With iSeries Access for Windows V5R2, using VBScript macros multiple times in PC5250 hangs the session. It will usually not happen until 50 or more uses of the same macro. APAR SE13991: CA400EXP-TERMEMUL-UNPRED FUNCTION AND ENTER KEYS INTERMITTEN While working normally in a PC5250 session Function and Enter keys go unresponding. The reason for this could be a break message. While the user is typing normally, they get a break message. The screen changes to display the break message. The user is unaware of the break message screen and keeps typing. They notice the break message only after an operator error happens (i.e. a ding is heard). They hit the reset/arrow key to clear the error on OIA. Since an operator error occurred, a couple of internal PC5250 flags get set. These flags should get reset when the user hits the reset or arrow key. But in the problematic scenario only one of the flag is getting reset. Everytime a user hits a key, these flags are checked to see if the keys can be sent to the host or not. If the flags are not set then keys are sent. Since one of the flag is still set (indicating an error), the keys are not sent. Because of this the user experiences Function and Enter keys go unresponding. APAR SE14730: CA400EXP-TERMEMUL-INCORROUT PC5250 NEGOTIATES WRONG KBDTYPE OS400 Virtual Device creation is negotiated with WRONG KBDTYPE by PC5250 when using 1140 Portugal Euro Host Code Page. Virtual Device is created with KBDTYPE=BLM.It should be PRE. APAR SE14747: OSP-PAR PC5250 CURSOR POSITIONING PROBLEMS WITH V5R1 OF CLIE With V5R1 of Client Access Express there are PC5250 cursor positioning problems when tabbing between fields. Also fixes problem in APAR SE14942 which the Customer is using the QSNGETCSRADR API, which should return the actual cursor position. After PGM start the API won't return the correct value. It returns the position of the first entry field. With the next call of the API in the PGM it returns the correct coordinates. APAR SE15297: OSP PCSERR101 ERROR WHEN A COPY/PASTE FUNCTION IS PERFORMED. PCSERR101 error is reported when doing a COPY function. APAR SE15562: CA400EXP-TERMEMUL-MSGPCSERR999 MACRO LIMITED TO 64KBYTE PCSERR999 internal error: PCSKBD.DLL - 4001 Macroeditor limit macro size to 64KB APAR SE15735: CA400EXP-PRINTEMUL-UNPRED PRINTER SETUP WINDOW DOES NOT DISP When using a PC5250 printer session, click File/Printer Setup, and then check the box that says to "Display this dialog before every print". When you go to print a spooled file, the printer setup window is supposed to be displayed, but it is not happening. APAR SE15931: CA400EXP-TERMEMUL-INCORROUT AFTER RETURNING TO CALLING PGM Program A is called from Program B. After returning to B Characters on the DSPF gets overwritten if cursor was set with mouse PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE13412: CA400EXP-OPCON-INCORROUT REMOTE CONTROL PANEL FAILS WIN-XP SP1 with current security patches fails to restart the parallel Remote Control Panel after it is disconnected, or the PC may stop responding or produce a blue screen termination and reboot. One can now stop and restart the parallel Remote Control Panel on Windows XP. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE15136: CA400EXP-INCORROUT cwbCO_GetPasswordExpireDate The API cwbCO_GetPasswordExpireDate returns CWB_INV_BEFORE_VALIDATE when user profile set to *NOMAX. The documentation for API cwbCO_GetPasswordExpireDate will be updated as follows: CWB_INV_BEFORE_VALIDATE The user ID and password that were set in the specified system object have not been validated (so the password expire date is not available), or validation has occurred and the user profile password expiration interval is set to *NOMAX. Usage Notes: You must have successfully called cwbCO_VerifyUserIDPassword(), cwbCO_Signon(), or cwbCO_Connect() before using this API. If you want to guarantee that the value returned is recent, you must either call cwbCO_VerifyUserIDPassword() explicitly, or set the Validate Mode to CWBCO_VALIDATE_ALWAYS before you call cwbCO_Signon() or cwbCO_Connect(). If the user profile password expiration interval is set to *NOMAX, a password expire date does not exist. To detect this case, first validate the user ID and password as noted above, and then, if successful, call cwbCO_GetPasswordExpireDate. A return code of CWBCO_INV_BEFORE_VALIDATE means that the password expiration interval is set to *NOMAX. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI10914 Build date = February 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE12606: CA400EXP-2-MSGCWBCF0005-F/CWBBACK CWBBACK FAILS WHEN DBCS INVOLVED APAR SE13599: CA400EXP - Add 64 bit support to XDA Windows client OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE11922: CA400EXP-OPNAV-OUTPUT-INCORROUT TOP OF PDF FILE IS CUT OFF W APAR SE12158: CA400EXP-OPNAV-INCORROUT CPD0082 IS RECEIVED BY CHANGING THE SCHEDULE DATE OF A J APAR SE12240: CA400EXP-OPNAV-UNPRED UNABLE TO SCHEDULE CHANGE TO VIRTUAL APAR SE12353: CA400EXP-OPNAV-NETWORK-INCORROUT QoS data corruption APAR SE12354: CA400EXP-OPNAV-NETWORK UCW support new version 5 QTOCcit.fil APAR SE12355: CA400EXP-OPNAV-NETWORK VPN needs to use Tunnel Mode APAR SE12356: CA400EXP-OPNAV-NETWORK-INCORROUT Wrong policy priority value written when connected to V5R1 system Quality of Service ( QoS ) APAR SE12438: CA400EXP-OPNAV-OUTPUT-INCORROUT CWBUN_GETPUBLICLISTOBJECT AP APAR SE12610: Client Access iSeries Navigator System status appears greyed out APAR SE12783: CA400EXP-OPNAV-MSG88 ERROR WHEN TRYING TO CHANGE PARITY APAR SE13297: CA400EXP-OPNAV-NETWORK Incorrect subsystem forced in PPP initiator profiles DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE11455: CA400EXP-DTRANSFER-DBCS CHARACTERS IN PC BIFF8 FILENAME MAKES SHEETNAME INCORRECT APAR SE12420: CA400EXP-DTRANSFER UPLOAD REQUEST LARGER THAN 4K RESULTS IN CWBTF0013 DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE12467: CA400EXP-DTRANSFER DATE PROPERTIES NOT APPLIED USING EXCEL WIZARD ODBC ---- APAR SE12051: CA400EXP-ODBC INTERNAL DRIVER ERROR WHEN USING COM+ APAR SE12232: CA400EXP-ODBC-UNPRED MEMORY LEAK IN CLIENT ACCESS ODBC DRIVE APAR SE12311: CA400EXP-ODBC-INCORROUT PROBLEMS WITH SYNONYM TYPE IN SQLTAB APAR SE13115: CA400EXP-ODBC-INCORROUT - FETCH PROBLEMS WITH PARTIAL BLOCKS APAR SE13347: CA400EXP-ODBC-UNPRED SQLCOLATTRIBUTES SQL_COLUMN_SEARCHABLE OLE DB PROVIDER --------------- APAR SE11849: CA400EXP-OLEDB-MSGCWB0111 ERROR OPENING ADO RECORDSET APAR SE11854: CA400EXP - OLEDB - INSERTING DBCS CHARS INTO UNICODE COLUMN LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR SE11237: CA400EXP-TERMEMUL DISPLAYING SUBFILES CONTAINING FIELDS DEFI APAR SE11341: CA400EXP-PRINTEMUL-INCORROUT PC5250 PRINTER EMULATION APAR SE11890: OSP-PAR ISERIES ACCESS FOR WINDOWS COPY AND PASTE WITH PC525 APAR SE11914: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION BY NEWLINE KEY W APAR SE12161: CA400EXP-TERMEMUL-INCORROUT IBM3270-1250 FONTS ARE NOT APAR SE12522: CA400EXP-MIGRATION-INCORROUT MIGRATING A WS FILE FOR PC5250 APAR SE12599: CA400EXP KERBEROS SETTING WILL NOT SAVE APAR SE12600: CA400EXP-PC5250 SESSION HANG WITH HYPER THREADING CPU. APAR SE12767: OSP-PAR INCORRECT OUTPUT LABELS PRINT 2 LINES PER LABEL INST APAR SE12821: CA400EXP-TERMEMUL-UNPRED PC5250 SESSION DROPPING WHEN USING APAR SE13430: CA400EXP - TERMEMUL - Add support for LotusScript Extension PCOMM supports a LotusScript Extension to their HACL interface. iSeries Access for Windows does not ship this interface. This support has now been added. APAR SE13431: TERMEMUL Signed Numeric won't paste to protected fields PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE12381: CA400EXP-OPCON-UNPRED Direct connect fails with Windows NT PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI09809 Build date = October 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE10680: CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION V5R2 CLI APAR SE10769: CA400EXP-APIS-INCORROUT SAP400 WITH WINDOWS APPLICATION SERV APAR SE10863: CA400EXP-TERMEMUL-INCORROUT CREATE 5250 ICON FAILS CWBCFG is run to set the PC5250 files path to each users' My Documents directory, as follows: cwbcfg /pc5250path *MYDOCUMENTS After this, restricted users cannot perform PC5250-related tasks that require changing or creating PC5250 files. For example, creating an icon for or saving a new session, creating a macro, and changing the keyboard map settings all may fail. This PTF fixes the reported problem. However, there are possible side-effects the user should be aware of. If cwbcfg.exe was used with "/pc5250path *MYDOCUMENTS" before applying this fix, the following are true: 1) All users' PC5250 paths were set to the My Documents of the user who last ran cwbcfg.exe with this option. 2) Any user who changed his PC5250 path using the PC5250 tab of iSeries Access for Windows Properties replaced the incorrect path with the correct one. 3) Users with enough authority -- for example, users in the Administrators group -- will see no failure since they have write access to the other user's My Documents. 4) Users without such authority will fail as described. 5) After this fix is applied, running cwbcfg.exe specifying "/pc5250path *MYDOCUMENTS" will change each users' PC5250 path to that user's correct My Documents location. Because of (3) and (5) above, some users may, after this fix is applied and cwbcfg.exe is run, no longer have access to their saved PC5250 connections, macros, etc. To have access to these things, an administrator of the PC must manually copy PC5250-related files from the old PC5250 path to the new one. This has always been true when a user's PC5250 path has been changed. APAR SE11169: CA400EXP-OPNAV-FILESYS-INCORROUT IFS NETSERVER SHARE LISTING APAR SE11183: CA400EXP-INSTALL-UNPRED SELECTIVE PLUGIN COMPLETION PERCENTAGE APAR SE11205: CA400EXP-SERVICE-INCORROUT AppAdmin Autostart service job APAR SE11653: OSP - XDA performance enhancements APAR SE11654: OSP - ODP cleanup for XDA Windows Client APAR SE11769: OSP - CA comm layer and tracing in XDA Windows client The XDA Windows client contains minimal support features. The Client Access Detail Trace and Client Access communications layer have been added to the XDA Windows Client. The sndbufsz.reg file will be obsolete and have no effect beginning with the installation of this fix and later fixes. The cwbcopwr tool can be used to set the send and receive buffer sizes. When using this fix to connect to the iSeries, the iSeries being connected to must have PTF SI10128 applied if connecting to a v5r2 server, or PTF SI10160 applied if connecting to a v5r1 server. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE10286: CA400EXP-OPNAV UNABLE TO DELETE SQL MONITOR BY INAV APAR SE10324: TCPIP CANNOT MAKE CHANGES TO DNS CONFIG USING OPSNAV APAR SE10394: OSP-PAR ACCESSING MGTC GRAPH History DATA LOCKS OPERATIONS NAVIGATOR APAR SE10515: CA400EXP-OPNAV-INCORROUT CONFIGURING A SWEDISH LPAR SYSTEM APAR SE10617: OSP-DB ERRORS WHEN USING ISERIES NAVIGATOR APAR SE11065: CA400EXP-OPNAV-OUTPUT Printer Output ERROR non-English workstations APAR SE11159: CA400EXP-OPNAV-OUTPUT PASTING SPOOLED FILES TO DESKTOP FAILS APAR SE11223: CA400EXP-OPNAV-OUTPUT-PERFM CONVERT TO PDF OPTION IN OPS NAV APAR SE11504: CA400EXP-OPNAV-OUTPUT-INCORROUT INCORRECT DISPLAY OF ISERIES APAR SE11590: OSP-DB FILE CREATED WITH SRTSEQ TABLE SHOWS INCORRECT SRTSEQ APAR SE11599: CA400EXP-OPNAV-DBASE-INCORROUT RUN & EXPLAIN DOES NOT Run & Explain does not accurately display the "Total Execution Time" for a query. This PTF fixes the reported problem. Note that it may now take longer to see the Visual Explain diagram when performing Run & Explain in the Run SQL Scripts window, because with this change the diagram is not built until all rows of the query have been fetched. This change will only be in effect when the graph detail setting is FULL, and the query is not for update. APAR SE11645: CA400EXP-OPNAV-NETWORK-INCORROUT Error on domain "A" record APAR SE11646: CA400EXP-OPNAV-NETWORK-INCORROUT Keep RBL if add SMTP filter APAR SE11647: CA400EXP-OPNAV-NETWORK-INCORROUT Allow apostrophe in SMTP filter APAR SE11648: CA400EXP-OPNAV-NETWORK-INCORROUT BOOTP Relay Configuration APAR SE11649: CA400EXP-OPNAV-NETWORK-INCORROUT UCW not set dial attempts The Universal Connection is incorrectly setting the Number of Dial Attempts, Delay between Dial Attempts, and Line Inactivity Timeout when creating the connection profiles. The Universal Connection will be changed to set the Number of Dial Attempts to 3, Delay between Dial Attempts to 15, and Line Inactivity Timeout to 10 minutes. APAR SE11650: CA400EXP-OPNAV-NETWORK-INCORROUT Writing DNS config failure APAR SE11651: FTP Properties Config Fails TCP9503 APAR SE11669: INCORROUT Journaling dialog box shows different for IASPs under the Integrated File System APAR SE11714: CA400EXP-OPNAV-FILESYS-INCORROUT LARGE FILES SHOW INCORRECT APAR SE11743: CA400EXP-OPNAV-INCORROUT WHEN USING A MOUSE WHEEL WITHIN APP. ADMIN. APAR SE11892: CA400EXP-OPNAV-AUTHLIST-INCORROUT CANNOT ADD AN AUTL TO A APAR SE11901: CA400EXP-OPNAV-FILESYS-INCORROUT - Changing AUTL on a NetServer share in v5r2 OpNav to v5r2 OS400 fails DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE10644: CA400EXP-DTRANSFER CSV FILE WITH DBCS CAN BE TRANSFERED TO Data Transfer To iSeries (AS/400) may not report data conversion warnings if DBCS data is transferred to a SBCS only column. This is typically the case if the data in the file contains a mix of DBCS and SBCS data. As a result, no warning is displayed and DBCS data transferred to the SBCS column is normally corrupt. After installing this fix a translation error will produce a warning message. The warning message will contain an OK button to allow the user to continue the transfer and a Cancel button to cancel the transfer. APAR SE10934: CA400EXP-DTRANSFER-PERFM SLOW TAB DELIMITED TRANSFER APAR SE11009: CA400EXP-DTRANSFER-INCORROUT CANNOT DELETE THE WHERE CLAUSE APAR SE11667: CA400EXP-DTRANSFER ADDED RXFERPCB TO DATA TRANSFER RXFERPCB is a new utility for facilitating remote data transfers. A new tool, RXFERPCB.EXE has been added to iSeries Access for Windows Data Transfer. This new tool was added to aid in remote data transfers via Incoming Remote Command and RUNRMTCMD from the iSeries. RXFERPCB is much like RTOPCB and RFROMPCB except that it allows you to specify a user ID and password on the command line. This helps to alleviate remote signon problems that are typical when trying to do remote transfers with RTOPCB and RFROMPCB. To run RXFERPCB, specify the transfer request profile name, userID, and password. An example invocation of RXFERPCB and its parameter descriptions are as follows: RXFERPCB request userID password request - Fully qualified file name of any Client Access upload or download request of type .DTF, .DTT, .TTO, or .TFR. userID - A valid iSeries user profile for the system specified in the request. password - A valid password for the specified user profile. RXFERPCB C:\TRANSFERS\MYREQUEST.DTF myuserid mypassword RXFERPCB can be found in the directory where you installed iSeries Access for Windows. NOTE: RXFERPCB specific messages and help text will display as English only. However, most error and warning messages will display using the correct language. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE11659: CA400EXP-DTRANSFER EXCEL ADD-IN LIMITED TO 16K ROWS ON XP ODBC ---- APAR SE10773: CA400EXP-ODBC SQL SERVER 2000 LINKED SERVERS RETURN PARTIAL APAR SE10781: CA400EXP-ODBC-UNPRED EXTENDED DYNAMIC WARNINGS ON CATALOG The V5R2M0 iSeries Access ODBC driver retrieves catalog (metadata) information differently than previous incarnations of the Client Access ODBC driver did. This difference can cause catalog requests to receive a return code of 1 meaning success with additional information, rather than a return code of 0 which simply means success. Some applications may be coded in such a way that they treat this as a failure rather than success. Specific examples of applications behaving in this incorrect manner include Microsoft Query and Microsoft Word. While this really is a coding defect in the application, it is one that the application would not have previously encountered using older versions of Client Access. The problems may be circumvented by disabling extended dynamic support in the ODBC data source on the Packages tab. APAR SE11349: CA400EXP-ODBC-INCORROUT PRECISION NOT CORRECT FOR FLOATING APAR SE11453: CA400EXP-ODBC-INCORROUT COLUMN NAMES FOR RESULT SETS NOT OLE DB PROVIDER --------------- APAR SE11652: CA400EXP-DBACCESS-OLEDB APPLICATION FAILS WITH SQL0904 RC7 An application uses iSeries Access for Windows OLE DB (IBMDA400) to access DB2 UDB for iSeries data. The application creates and destroys a very large number of ADO command objects. The same SQL Statement is run multiple times with different values. After approximately 40,000 command objects the application fails with the error message SQL0904 RESOURCE LIMIT EXCEEDED, RESOURCE LIMIT TYPE 7 EXCEEDED. OLEDB will now reuse statement names. Note that applications that run large quantities of unique SQL Statements (different SQL statements after converting literals to parameters) will still hit the SQL0904 error when the maximum number of prepared statements is reached. This is a restriction of DB2 UDB for iSeries. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR SE10503: CA400EXP-PRINTEMUL-INCORROUT WORD CLAMPING WITHIN PAGE WIDTH APAR SE10544: CA400EXP-TERMEMUL-INCORROUT PCSCM GETS AN APPLICATION ERROR APAR SE10659: CA400EXP-PC5250 PCSFONT WAS FILTERED FROM WIN2K/XP OS. APAR SE10660: CA400EXP-PC5250 JAPANESE KATAKANA APPEARED INCORRECTLY IF APAR SE10707: CA400EXP-TERMEMUL-LOOP RPG APPLICATION IS CAUSING PCSWS.EXE APAR SE10729: CA400EXP-TERMEMUL-INCORROUT PCSWS.EXE FAULTS STARTING AND ST APAR SE10742: CA400EXP-TERMEMUL-INCORROUT EHLLAPI MNEMONIC RESET FAILS TO APAR SE10864: OSP DISPLAYING A SUBFILE, IT IS BLANK. APAR SE10879: CA400EXP PCSWS APPLICATION ERROR WHEN USING SEQUENCE KEY TO APAR SE11161: OSP-PAR COPY AND PASTE WITH ISERIES ACCESS FOR WINDOWS PC525 APAR SE11324: OSP-PAR COPY AND PASTE WITH ISERIES ACCESS FOR WINDOWS PC525 APAR SE11656: CA400EXP-PRINTEMUL-INCORROUT Problem with IBM5577.PDT APAR SE11657: CA400EXP-TERMEMUL-INCORROUT Horizontal Scroll bar when Font Size is changed is not working APAR SE11658: CA400EXP-TERMEMUL-INCORROUT Connect and Config options are disabled if the Host code page is changed and autoconnect is disabled PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE11182: CA400EXP-OPCON-UNPRED Direct connect fault with Win2k SP4 PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI08894 Build date = June 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE09627 OSP-PAR USING CHECK VERSION TO COPY INSTALL CODE TO PC BEFORE INSTALLING APAR = SE09912 CA400EXP-OPNAV-DBASE-INCORROUT AFTER SP INSTALL INSERT APAR = SE10014 OSP-PAR FUNCTIONS GRAYED-OUT OR FAIL EVEN WHEN ADMIN APAR = SE10564 CA400EXP-INCORROUT Cannot use Windows logon on 64-bit PC OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR = SE09708 CA400EXP-INRMTCMD-INCORROUT CMDS FAIL AFTER UPGRADING WINDOWS A PC used for running Incoming Remote Command (IRC) requests is upgraded from Windows 9x/Me to Windows NT/2000/XP. Some commands sent using RUNRMTCMD to this PC now fail, when they had worked before the Windows upgrade. Incoming Remote Command (IRC) now recognizes a new option: /loadprof This option tells IRC that whenever a command will be run in the context of a user ID sent with the command, the user profile should be loaded first. If it is successfully loaded, the command will have access to user-specific configuration information it might need to succeed. This information includes the HKEY_CURRENT_USER part of the registry and user-specific environment variables. The /loadprof option may be used in either of two ways. The first is to enter it as a Start Parameter when you start the iSeries Access for Windows Remote Command service. If you do that, the option will be applied to all commands run by IRC. The second method is to enter it as part of the command string, before the actual command. This method is useful if you want the option applied only to some commands but not others. For example, to tell IRC to load the user profile and then run the command 'myprog.exe' you would specify as the command the string '/loadprof myprog.exe'. If /loadprof is specified, but IRC has no user context to run the command in, the user profile will not be loaded. For example, when /runassystem ("run as system") is also used, the command is run in the context of whatever account the iSeries Access for Windows Remote Command service is configured to run under, not the context of the user ID sent with the command. Another example is when /nosecok ("Allow generic security") is also used, and *NONE is sent as the user ID. In both of these cases, no user profile can be loaded. There are several considerations to keep in mind when the /loadprof option is used. Firstly, use of this option does not guarantee that the user profile will be loaded successfully before your command is run. If IRC fails to load the user profile, it will run the command anyway, and the command may not have access to the user-specific configuration information. If this occurs, a message will be logged to the History Log indicating that the user profile was not loaded successfully. Secondly, omitting /loadprof does not guarantee that the user profile is not loaded when your command runs. User profiles are system-wide things, and some other process may have already loaded the user profile. If the user is signed-on to the PC on which the command is run, their profile might already be loaded and available to the command. APAR = SE10619 CA400EXP-INRMTCMD MSG1313 IRC DAEMON SERVICE DOES NOT START iSeries Navigator ----------------- APAR = SE06054 CA400EXP-OPNAV-NETWORK-INCORROUT Updating SMTP filters APAR = SE08141 OSP-DB-F/QZDACMDP-MSGPWS0010-T/QZDACMDP OPERATIONS NAVIGATOR APAR = SE09027 CA400EXP-OPNAV-NETWORK-INCORROUT RouteD config loses data APAR = SE09604 CA400EXP-OPNAV-INCORROUT ERROR CWBUNPLA DIALOG APPEARED APAR = SE09614 CA400EXP-OPNAV-MESSAGES-MSGSQL7959 CA400EXP USING OPSNAV APAR = SE09628 CA400EXP-2-INCORROUT UCW DOES NOT RECOGNIZE D/T2742 APAR = SE09640 CA400EXP-OPNAV-NETWORK-INCORROUT iNav hangs changing SMTP APAR = SE09684 CA400EXP-OPNAV-DBASE-MSGCPF0001 USING ISERIES NAVIGATOR TO D APAR = SE09706 CA400EXP-OPNAV-OUTPUT-MSGCPD0083 Error Moving Printer Output APAR = SE09727 CA400EXP-OPNAV-INCORROUT ADMINISTRATION SYSTEM TAB WITHIN APAR = SE09743 CA400EXP-OPNAV-DBASE-INCORROUT RUN SQL SCRIPTS HANGS WINDOWS APAR = SE09747 CA400EXP-OPNAV-OUTPUT-INCORROUT INTERNET SETUP WIZARD ON FRENCH APAR = SE09826 CA400EXP-OPNAV-DBASE-INCORROUT ADDITIONAL FILES DISPLAYED IN APAR = SE09851 CA400EXP-OPNAV-DBASE-MSGSQL0100 CANNOT UPDATE A TABLE THROUG APAR = SE09915 CA400EXP-OPNAV-NETWORK-MSGTCP2652 ENABLE PROXY ARP ON VIRTUA APAR = SE10078 OSP-IMPORT OF OVERLAY FAIL USING AFP MANAGER APAR = SE10161 CA400EXP-OPNAV-OUTPUT Error copying multiple spooled files APAR = SE10222 OSP FAILURE TO ACCESS THE PM400 TREND ANALYSIS DATA ON THE W APAR = SE10229 CA400EXP-OPNAV-OUTPUT-INCORROUT OUTPUT QUEUE DELETE ERROR APAR = SE10562 CA400EXP-OPNAV-NETWORK-INCORROUT Subsystem name discarded APAR = SE10565 CA400EXP-OPNAV-NETWORK-INCORROUT Can't add SMTP RR address APAR = SE10566 CA400EXP-OPNAV-NETWORK-UNPRED Improve diagnostics DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE09811 CA400EXP-DTRANSFER-INCORROUT WRONG MBR DISPLAYED IN BROWSE DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE09057 CA400EXP-ODBC SQLFETCHSCROLL DOESN'T RETURN CORRECT NUMBER O APAR = SE09116 CA400EXP-ODBC-INCORROUT DATA RETURNED FOR CLOB FIELDS APAR = SE09139 CA400EXP-ODBC-MSGERROR IN ROW ODBC APPLICATION FAILS WHEN ZE APAR = SE09168 CA400EXP-ODBC-MSG7357 (1CBD) OLE DB PROVIDER 'MSDASQL' APAR = SE09180 CA400EXP-ODBC-MSGSQL0666 R520 PERFORMANCE PROBLEM W/ APAR = SE09306 CA400EXP-ODBC-INCORROUT INCORRECT OUTPUT WITH EXTENDED FETCH APAR = SE09746 CA400EXP-ODBC SQLSTATE 22018 ERROR IN ASSIGNMENT APAR = SE09933 CA400EXP-ODBC-INCORROUT STACK OVERFLOW WHEN RETRIEVING CATAL APAR = SE10041 CA400EXP-ODBC-INCORROUT FILE DSN CONFIGURED TO USE WINDOWS U APAR = SE10057 CA400EXP-ODBC-MSGCWB0111 VERSION 2.0 APPLICATIONS AND UNICODE APAR = SE10374 CA400EXP-ODBC-UNPRED ORS DATA IS NOT RELEASED BECAUSE RETURN APAR = SE10563 ODBC XA support ODBC allows the MTS interface for distributed transactions in a Windows environment. However, in certain environments, like Linux, that is not an option. An interface is needed for Linux so that XA APIs can be called to perform distributed transactions. API changes: SQLSetConnectAttr now supports a 2140, 2141, and 2142 option. SQLGetConnectAttr now supports a 2140, 2141, 2142, 2143 option. Attribute: 2140 Description: An unsigned integer value that specfies the amount of time (in seconds) that an XA transaction will wait until it times out. A value of 0 indicates to wait indefinitely for the transaction to finish. Setting this overrides any value that was set for the XATIMEOUT connection string keyword. The default value for this attribute is 0. Setting this value at the present time will have no effect. Atribute: 2141 Description: An unsigned integer value that specfies the maximum amount of time (in seconds) that an XA transaction will wait on a lock request before timing out. A value of 0 indicates to use the default system settings. Setting this overrides any value that was set for the XALOCKTIMEOUT connection string keyword. The default value for this attribute is 0. Setting this value at the present time will have no effect. Attribute: 2142 Description: An integer value that specifies the RMID to use for XA transaction work. This can be set at anytime. The RMID that is set must be unique for the process. If this value is set to 0 it indicates that any current XA transaction work has been completed for this connection. The default value for this attribute is 0. Attribute: 2143 Description: A character string that identifies the iSeries Access driver to call into for XA calls. This string is only valid if the 2142 connection attribute has been set. This string is set after the connection is established. The default value for this attribute is an empty-string. SQLDriverConnect now supports the XATXNTIMEOUT and XALOCKTIMEOUT connection string keywords. See Attribute 2140 and 2141 for a description of what these attributes set. - xa_open is only called by the application for recovery purposes. When connecting through the ODBC API SQLConnect or SQLDriverConnect the xa_open is done automatically if the RMID was set via the 2142 connection attribute. - The connection attribute SQL_ATTR_AUTOCOMMIT must be set as SQL_AUTOCOMMIT_ON. - If an application wishes to start an XA transaction and then do some non-XA transaction work, one must set the RMID to 0 to indicate to the driver that the XA work is completed. - To do XA recovery an application calls xa_open with a string of "SYSTEM=mySystem;UID=myUserID;PWD="myPassword";DATABASE=myDatabase;" where mySystem is your system name, myUserID is your user ID on that system, and myPassword is that user ID's password. Note the string must be specified exactly as above or as "SYSTEM=mySystem;". Those two strings are the only two strings that will work. Below is the basic scenario on how an application calls into the driver to do a distributed transaction: 1. Application calls SQLSetConnectAttr and specifies the 2142 option indicating the RMID to use 2. Application calls SQLConnect / SQLDriverConnect (the driver does an xa_open) Optional: Application calls SQLGetConnectAttr to get the DLL name needed to make the xa_open call for recovery 3. Application calls ODBC APIs like normal and calls XA APIs to coordinate the transaction by calling into the iSeries Access DLL that supports the xa_switch. 4. Application calls SQLDisconnect (the driver does an xa_close) OLE DB PROVIDER --------------- APAR = SE09140 CA400EXP-OLEDB-INCORROUT AD400SEEKLASTEQ PARTIAL SEEK FAILS AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI08536. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE08385 CA400EXP-PC5250 IME_AUTO_START_N FUNCTION INCORROUT APAR = SE08553 CA400EXP-TERMEMUL-MSGPCSWS044 PCSWS044 PREVENTS PC FROM This issue affects laptops- the laptop cannot enter sleep mode without the user responding to this message- PCSWS044. Would like a way to turn it off. A keyword setting has been provided to control this behavior. The keyword should be added to the pcswin.ini file. PromptBeforeSleep=Y This is the default setting. When the keyword is set to Y, PC5250 will will prompt the user about whether to go into power saving mode if the session is connected. If the session is not connected, permission for Windows to go into power saving mode will be granted without prompting. PromptBeforeSleep=N When the keyword is set to N, permission for Windows to go into power saving mode will always be granted without prompting. APAR = SE08696 CA400EXP-TERMEMUL-INCORROUT PCSWS.EXE FAULTS STOPPING A SESSION APAR = SE08902 CA400EXP-TERMEMUL-INCORROUT UNABLE TO TYPE KATAKANA "WO" APAR = SE08973 PC5250 CAN'T TYPE N-TILDE IN ALPHABETIC FIELD IN DSPF, WHICH APAR = SE08975 CA400EXP-TERMEMUL-PERFM RUNNING MACROS IN MORE THAN 1 PC5250 APAR = SE09006 CA400EXP-TERMEMUL-PERFM PC5250 DISPLAY SESSION HANGS & LOOSE APAR = SE09016 CA400EXP-TERMEMUL-INCORROUT KEYBOARD MAPPING PROBLEM WITH GREEK APAR = SE09349 CA400EXP-PRINTEMUL-INCORROUT PC5250 PRINTER CAUSES FONT APAR = SE09502 CA400EXP-PRINTEMUL-INCORROUT AFTER APPLYING SI06631 THE FONT APAR = SE09761 CA400EXP-PRINTEMUL-INCORROUT PC5250 UNICODE CHARACTERS ARE APAR = SE09776 CA400EXP PC5250 INPUT INHIBIT DISPLAY SESSION APAR = SE10023 CA400EXP-PRINTEMUL DBCS COMPUTER OUTPUT REDUCTION PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE09791 CA400EXP-OPCON-UNPRED CWBOPCON.EXE ERRORS AFTER APPLY OF APAR = SE10250 OpConsole - CA400EXP-OPCON-UNPRED REMOTE CONTROL PANEL VIA CABLE WILL NO APAR = SE10315 CA400EXP-OPCON-INCORROUT SELECTING THE AUTO CONNECTION OPTION --------------------------------- Service Pack Level = SI07675 Build date = February 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE08411 CA400EXP-INSTALL-UNPRED INSTALL OF AFP/SCS PRINT DRIVERS ON WIN XP SP1 Installing the AFP or SCS Printer Drivers drivers included with V5R2 of iSeries Access for Windows, or V5R1 of Client Access Express, on a PC with Windows XP and XP Service Pack 1, generates a Windows Logo Testing warning/error during installation. With Windows XP SP1, Microsoft enforced the Driver Signing warn and block options, where previously, install programs could bypass these settings. Users can avoid this problem by not selecting the AFP and SCS Printer Driver components for installation. These components are in a Typical Install, so the user should select a Custom Install, and de-select the AFP and SCS Printer Driver components, if those components are not needed. If the user needs AFP and SCS Printer Driver components, then answer the Microsoft Driver Signing Option warning box with the Continue option to continue with the install. In addition, the user can specify to Ignore Driver Signing via the Windows Control Panel, System applet, Hardware tab, Driver Signing button. After the install, the setting can be restored to its previous value by the user. APAR = SE09143 CA400EXP-AFPVIEWER-INCORROUT CWBNP1019 RESOURCE AFP OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR = SE08698 CA400EXP-INRMTCMD-UNPRED USE WINDOWS LOGON DOES NOT WORK WITH IRC iSeries NAVIGATOR ----------------- APAR = SE08264 OSP-F/QCARULE-MSGCPD0039-T/QSQCALL APAR = SE08543 CA400EXP-OPNAV-DBASE-UNPRED SAVED DATABASE MAP CANNOT NOT BE APAR = SE08599 CA400EXP-OPNAV-MSGCWBUN0148 CWBUN0148 MESSAGE IS RECIEVED WH APAR = SE08724 CA400EXP-OPNAV-DBASE DETAILED SQL PERFORMANCE MONITOR FAILS APAR = SE08845 CA400EXP-OPNAV-PERFM OPS NAV APPEARS TO HANG OR IS SLOW TO APAR = SE09107 CA400EXP-OPNAV-FILESYS-MSGCPFA0A9 Permissions problem DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE08489 CA400EXP-ODBC ADO ERRORS 2147217887 AND 2147467259 IN CA APAR = SE08671 CA400EXP-ODBC-INCORROUT SQLGETINFO CATALOG_USAGE VALUE RETUR APAR = SE08715 CA400EXP-ODBC-INCORROUT ODBC RETURNS INCORRECT DATE, TIME, A APAR = SE08723 CA400EXP-ODBC CLOB FIELDS AND NULL VALUES APAR = SE08942 CA400EXP-ODBC-MSGSQL0551 MSGSQL0551 QSYS/QADBKFLD ODBC APP APAR = SE09104 CA400EXP-ODBC-PERFM PERFORMANCE PROBLEM WITH V5R2 ODBC OLE DB PROVIDER --------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI05645. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE08554 CA400EXP-PRINTEMUL-INCORROUT OUTPUT CHANGED ON R520 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE08827 CA400EXP-OPCON-UNPRED OPERATIONS CONSOLE SETUP HANGS AT MODE APAR = SE09008 CA400EXP-OPCON-INCORROUT HOST FILE ON THE PC IS NOT UPDATED --------------------------------- Service Pack Level = SI06631 Build date = November 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE07361 CA400EXP-DTRANSFER-INCORROUT TRANSFERRING TO CCSID 13488 APAR = SE07669 OSP-PAR CLIENT ACCESS LICENSE NOT ALWAYS RELEASING AFTER SET APAR = SE07950 CA400EXP-TERMEMUL-MSGCWBLM0011 CWBLM0011 ERROR WITH CLIENT APAR = SE08029 CA400EXP-DTRANSFER-WAIT CWBLMSRV.EXE INHERITING THE FILE APAR = SE08320 CA400EXP-CONNECTIONS-INCORROUT cwbcfg configs not changed; add /ipaddr modes When cwbcfg is run, even when /r is specified, not all existing user profiles are updated with the specified configuration information. Users created after cwbcfg is run do get the configuration information, as desired. Also, the only IP Address setting possible using cwbcfg is to specify the IP Address explicitly, which implicitly sets the IP Address Lookup Frequency to Never. The other lookup frequencies cannot be set. The /ipaddr parameter now can be used with any of the following: n.n.n.n If the actual IP address is specified in the format n.n.n.n, it will be set, and will never be looked-up. *ALWAYS The IP address will be looked-up every time a connection is attempted. *HOURLY The IP address will be looked-up only if an hour has passed since the last lookup. *DAILY The IP address will be looked-up only if a day has passed since the last lookup. *WEEKLY The IP address will be looked-up only if a week has passed since the last lookup. *STARTUP The IP address will be looked-up only if Windows has been shutdown and re-started since the last lookup. For example, the following command will not only set the default user ID of system MySys to Frank, it will also set the IP Address Lookup Frequency so the address is looked-up only if at least a day has passed since the last lookup. Because /r is used, it will modify even existing MySys configurations. cwbcfg /host MySys /ipaddr *DAILY /uid Frank /r APAR = SE08343 CA400EXP-2-LOOP ByteStream type 1 directories with large number of entries will hang iNav IFS OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE06986 OSP-AFP-PRT UNABLE TO USE IMPORT OVERLAY FUNCTION OF AFP MAN APAR = SE07200 TCPIP-SMTP OP NAV FAILURE ATTEMPTING TO CHANGE/DISPLAY SMTP APAR = SE07618 OSP-MSGCPD0104-PAR-CA400EXP-OPNAV CANNOT ENROLL TO DOMAIN APAR = SE07701 CA400EXP-OPNAV-INCORROUT ISERIES NAVIGATOR GETS AN INVALID P APAR = SE07991 OSP-DB VISUAL EXPLAIN HANGS WITHOUT DISPLAYING RESULTS APAR = SE08031 CA400EXP-OPNAV-NETWORK-INCORROUT UNIVERSAL CONNECTION WIZARD APAR = SE08075 CA400EXP-OPNAV-DBASE-MSGSQL0615 VISULAEXPLAIN GOT SQL EXCEPT APAR = SE08101 CA400EXP-OPNAV-DBASE-INCORROUT OPERATIONS NAVIGATOR "RUN SQL APAR = SE08145 CA400EXP-OPNAV-DBASE-INCORROUT SQL SCRIPT SAVE AS SHOWS AN APAR = SE08162 CA400EXP-ODBC FAILURE. ERROR "DESCRIPTOR INDEX NOT VALID" IS APAR = SE08220 OSP-DB CA400EXP-OPNAV SQL EXCEPTION DURING CREATE LIBRARY APAR = SE08329 CA400EXP-OPNAV-INCORROUT Numeric at start domain name APAR = SE08346 CA400EXP-OPNAV-NETWORK-UNPRED Add new 2793 modem for UCW APAR = SE08403 CA400EXP-OPNAV-INCORROUT RESOURCEBUNDLEERROR RECEIVED IN OPN DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE07804 CA400EXP-DTRANSFER NATIVE SQL STATEMENT FAILS ON WINDOWS 98 DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE07497 CA400EXP-ODBC-INCORROUT STORED PROCEDURE EXPECTED TO RETURN APAR = SE07922 CA400EXP-ODBC-INCORROUT UNABLE TO LINK TO SPECIFIC LIBRARY APAR = SE07999 CA400EXP-ODBC-INCORROUT MS EXCEL 2000 GIVES ERROR IN ASSIGNM APAR = SE08021 CA400EXP-ODBC-INCORROUT MS ACCESS 2000 LINK EXTERNAL TABLE APAR = SE08207 CA400EXP-ODBC-INCORROUT - ODBC Driver uses too much memory OLE DB PROVIDER --------------- APAR = SE08268 CA400EXP-OLEDB-INCORROUT SEEK FUNCTION USED WITH IBMDA400 OL AFP WORKBENCH VIEWER -------------------- APAR = SE08202 CA400EXP-AFPVIEWER ERROR OCCURS USING *VIEW FROM AFPU TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI05645. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE06873 OSP-PAR PCSWS IPF IN MODULE UNKNOWN WHEN STARTING RUNNING VB APAR = SE07574 CA400EXP-TERMEMUL-INCORROUT BACKSPACE IN A WORD WRAPPABLE FI APAR = SE07671 CA400EXP-TERMEMUL-INCORROUT UNABLE TO USE SYSREQ ON PC5250 APAR = SE07743 CA400EXP-TERMEMUL-INCORROUT PC5250 HANGS WHEN USING SYSREQ APAR = SE07771 CA400EXP-PRINTEMUL-MSGPCSWS.EXE ERROR INTEGER DIVISION BY 0 APAR = SE07847 CA400EXP-TERMEMUL-INCORROUT NO ALARM ON ICF CLIENTS WHEN APAR = SE08022 CA400EXP-TERMEMUL-INCORROUT CURSOR DOES NOT POSITION PROPERL APAR = SE08139 CA400EXP-PRINTEMUL-MSGPCSWS PAGE FAULT WINDOWS 2K DESKJET APAR = SE08188 CA400EXP-PC5250 FILE TRANSFER FAILS WITH 'APPLICATION ERROR' APAR = SE08283 OSP-PAR V5R2M0 C2260 5722XE1 WITH PTF SI05853 ON MS WINDOWS APAR = SE08322 CA400EXP INCORECT FONTS FOR VIETNAMESE CAPS 5250 DISP EMU APAR = SE08323 CA400EXP-PRINTEMUL-UNPRED PC5250 IS RESTORING DEFAULT PAGE PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. --------------------------------- Service Pack Level = SI05853 Build date = September 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE06839 CA400EXP-OLEDB-MSGCWBDB0052 OLEDB APP CANNOT FIND CONVERSION TBL APAR = SE07116 OSP-PAR CWBCO1004 MESSAGE RETURNED FOR LOCAL PORT LOOKUP OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE05818 OSP-DB DATABASE NAVIGATOR 'ADD TO MAP' FUNCTION FAILS IF APAR = SE06093 OSP-AFP-PRT IMPORT OF OVERLAY ONLY WORKS FOR ENGLISH CA APAR = SE06804 CA400EXP-OPNAV-SECPOL-UNPRED ADD BUTTON DOES NOT SHOW UP APAR = SE06921 CA400EXP-BOOTP OPERATIONS NAVIGATOR LIMITS RANGE OF MAC ADDR APAR = SE07405 OSP PROBLEM WITH LOADING OF USER LIST WHEN WORKING WITH THE DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE06350 CA400EXP-DTRANSFER-INCORROUT ASCII TEXT WITH ZERO PAD DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE06149 CA400EXP-ODBC-INCORROUT INVALID LENGTH REPORTED ON CATALOG APAR = SE06414 CA400EXP-ODBC-MSGSQL0181 AND MSGCPF5035 RC18 ON ODBC TIMESTA APAR = SE06447 CA400EXP-ODBC-INCORROUT - ODBC FAILS TO RETURN FULL STORED PROCEDURE RESULT SET APAR = SE06802 CA400EXP-ODBC-INCORROUT RIGHT TRUNCATION ON CHAR DATA APAR = SE07095 CA400EXP-ODBC-INCORROUT PROBLEM IS RELATED TO EMBEDDED NULLS APAR = SE07172 CA400EXP-ODBC-INCORROUT NULL OUTPUT PARAMETERS RETURNING APAR = SE07583 CA400EXP-ODBC-INCORROUT - SQLProcedureColumns results incorrect OLE DB PROVIDER --------------- APAR = SE06106 CA400EXP-OLEDB-INCORROUT SINGLE PRECISION DEC INCORRECTLY INSERTED APAR = SE06588 CA400EXP-OLEDB-UNPRED EXECUTING A PREPARED CALL STATEMENT APAR = SE07584 CA400EXP-OLEDB-INCORROUT Better support for LOB bindings and SQL Server AFP WORKBENCH VIEWER -------------------- APAR = SE07260 CA400EXP-OPNAV Viewer Process Fails to end when error occurs TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR = SE03962 CA400EXP-DBCS PRINTED AS GARBAGE BY PRINTER SESSION APAR = SE04192 CA400EXP-SECURITY-MSG656 UNABLE TO CONNECT PC5250 WHEN PASSW APAR = SE05180 CA400EXP-TERMEMUL PCSCM.EXE-APPLICATION ERROR. THE INSTRUCTI APAR = SE06164 CA400EXP-TERMEMUL-MSGMCH0601 CSRINPONLY SPECIFIED IN DSPF APAR = SE06296 OSP-PAR PC5250 PROCESSING OF FIELD WITH WORD WRAP AFTER SI02 PC5250 processing of a field with continuous input and word wrap ( CNTFLD WRDWRAP ) has changed. 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 change was made, 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 APAR = SE06719 CA400EXP-PC5250-INCORROUT VIETNAMESE 5250 DISPLAY EMULN APAR = SE06869 CA400EXP-TERMEMUL-INCORROUT SESSION HANGS ON EXIT IF CHANGES APAR = SE06871 CA400EXP-TERMEMUL-INCORROUT UNABLE TO SPECIFY A SECURE WEBSI PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE04218 CA400EXP-TERMEMUL-INCORROUT CLIENT ACCESS EXPRESS V5R1M0 EZ-SETUP -------- Non-APAR fixes. --------------------------------- Service Pack Level = SI04684 Build date = June 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE03830 CA400WINOPT IBMDA400 PARAMETER BIDI TRANSFORM IGNORED APAR = SE03863 CA400WINOPT - ARABIC TRANSLATION LAM-ALEF CHARACTER NOT GET APAR = SE05333 OSP-INCORROUT UNABLE TO USE DBCS SPECIFIC CHARACTER ON MS AC APAR = SE06009 CA400EXP-OLEDB-INCORROUT IBMDA400 MIXES DATA IN BIDI APAR = SE06195 INCORROUT UNABLE TO USE THREE THAI CHARACTERS WITH MS ACCESS OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE06470 OSP-PAR CLIENT ACCESS V450 OPERATIONS NAVIGATOR FATAL EXCEPT DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE04511 CA400EXP-DTRANSFER-UNPRED UPLOADING BIFF8 FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE06297 CA400EXP-ODBC-PERFM PARAMETER MARKER DESCRIPTION APAR = SE06298 CA400EXP-ODBC-INCORROUT - Miscellaneous ODBC problems APAR = SE06344 CA400EXP-ODBC-INCORROUT - Tool to update DSN information The CursorSensitivity keyword was added late in the V5R2 release. Consequently, it does not show up on the ODBC DSN Setup GUI. To better handle situations like this in the future a tool is needed to make it easier to update DSN information for new keywords. The current method for handling new keywords is to manually go edit the registry for User or System DSNs or the file for file DSNs. Also, another change in V5R2 was to have two ODBC driver names. ODBC DSNs created using the new driver name of "iSeries Access ODBC Driver" will not work with older versions of Client Access. To handle this compatibility issue, the tool being created should also provide a way to change the driver name to the old name of "Client Access ODBC Driver (32-bit)". The tool that is created is called cwbODBCreg.exe and is installed when ODBC is installed as part of Client Access. The tool resides in the \Program Files\IBM\Client Access directory. The syntax for running the tool can be found by running cwbODBCreg from a DOS command prompt without any parameters. APAR = SE06546 CA400EXP-ODBC-MSGCWB0111 CHARACTER DATA RIGHT TRUNCATION WIT OLE DB PROVIDER --------------- APAR = SE06083 CA400EXP-OLEDB-INCORROUT NUMBER OF ROWS AFFECTED IS INCORRECT APAR = SE06468 CA400EXP-OLEDB-UNPRED Adjust block factor to 1 for LOBs APAR = SE06469 CA400EXP-OLEDB-INCORROUT IBMDA400 RETURNS EMPTY RESULT SET F AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. EZ-SETUP -------- Non-APAR fixes. 4.0 INSTALL/UNINSTALL CONSIDERATIONS ------------------------------------- The following sections describe additional support and known problems that you may notice while using the Install/Uninstall function. 4.1 REMOVING THE SERVICE PACK ------------------------------ To remove this service pack from your PC: 1. Click the Windows Start button, click on Settings, and then click on Control Panel. 2. Double-click on the Add/Remove Programs icon. 3. Click on the Install/Uninstall tab, click on IBM iSeries Access for Windows SI14294 item, and then click on the Add/Remove button. 4. Follow the instructions on the screen. 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- InstallShield is the tool used to provide the install support for iSeries Access for Windows. The same tool is used for installing service packs. Setup.exe has a 2 minute timeout to initialize to the first wizard panel, which could expire when installing service packs over very slow communication lines. The suggested way of installing the service pack in this case is: 1) A setting has been added to the iSeries Access for Windows Properties Service tab that will copy the service pack image to the PC's temporary directory, install the service pack, then remove the copied files. To use this support you will need to specify this setting ("Copy install image to PC before installing"). STATUS: No status information is displayed while the files are copied. To determine if the transfers are progressing, look in the 'CA400CKV' temporary directory (beneath the PC temporary directory, for example C:\Documents and Settings\username\Local Settings\Temp). You should see new files appear periodically. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator can set the Install Service Pack policy restriction, or can use the SP.TXT file. If the administrator places a file named SP.TXT (with a 'N' in the first position of the first line) in the service pack installation image directory, the service pack will not be installed. 5.0 DATA TRANSFER CONSIDERATIONS --------------------------------- The following sections describe additional support or known problems that you may notice while using the Data Transfer function. 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 ----------------------------------------------------------- WHY DOES MY DATA LOOK LIKE GARBAGE WHEN I PERFORMED A DOWNLOAD? By default, the Data Transfer function will not convert data between EBCDIC and ASCII if the data is tagged with a CCSID of 65535. In older versions of the Win 95/NT Client Access product, the 65535 conversion was controlled by the CWBTFR.INI file. This process has been changed, and the conversion is now controlled by the Data Transfer user interface. Once the setting has been made in the user interface, it is then stored in the transfer request. This is only true for .TTO and .TFR files. .RTO and .DT files are still controlled by the CWBTFR.INI file. The conversion setting for .RTO and .DT files can be modified in the Data Transfer user interface, but the setting will not be saved. The setting to control the conversion is found in the File, Properties information. WARNING: This feature is designed as a workaround for people that can not change the CCSID of their files. In order for this translation to work properly, you must be confident the data in the file matches the CCSID of your user profile. The design of the iSeries is that data with a 65535 CCSID are not to be converted. This feature will attempt to do a conversion of the data from the job CCSID to the PC CCSID. This conversion may not work if the data in the file does not match the user profile/job CCSID. The correct solution to this problem is to appropriately tag the data with the correct CCSID. One way of doing this is by using CHGPF. For more information on the 65535 CCSID, please reference the iSeries National Language Support Manual.