============================================================================
       Readme File for iSeries Access for Windows Service Packs
            5722-XE1 V5R4M0 Cumulative Service Pack Level
                            -------------
                               SI20465
                            -------------
       (c) Copyright IBM Corporation 2005.  All rights reserved.
========================================================================

NOTICE:                                                                        
-------                                                                        
   Application of this PTF may disable or render ineffective programs that
   use system memory addresses not generated by the IBM translator,            
   including programs that circumvent control technology designed to limit
   interactive capacity to purchased levels. This PTF may be a prerequisite 
   for future PTFs. By applying this PTF you authorize and agree to the 
   foregoing. 

   This PTF is subject to the terms of the license agreement which
   accompanied, or was contained in, the Program for which you are obtaining
   the PTF.  You are not authorized to install or use the PTF except as part 
   of a Program for which you have a valid Proof of Entitlement.

   SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
   AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
   AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
   INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF 
   MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
   REGARDING THE PTF.

   The applicable license agreement may have been provided to you in printed
   form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
   CL command.                                                      
   
-----------------
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  RECOMMENDATIONS/RESTRICTIONS
 2.1  iSeries SERVER FIXES
 2.2  APPLICATION DEVELOPMENT FUNCTION WITHIN iSeries NAVIGATOR
 2.3  iSeries NAVIGATOR DATABASES COMPONENT 
3.0  AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS
      - SERVICE PACK LEVEL = SI20465 (October 2005)
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
   via a download from IBM's FTP site.

   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 tailored the iSeries Access for Windows 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 directory on your PC or server.
   2.  Run PTFFORM.EXE to automatically expand the service pack image files 
       to a temporary directory.  
   3.  You will then be prompted via a wizard panel to select the 
       iSeries Access for Windows install image directory to update 
       to the new service level.
   4.  The components that are contained in the target install image will be automatically
       updated to the new service level from the files in the temporary directory,
       and then the temporary directory will be removed.
   5.  After completion, you can delete the downloaded PTFFORM.exe file, as it is
       no longer needed.

   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 5-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  RECOMMENDATIONS/RESTRICTIONS
---------------------------------

 2.1  iSeries SERVER FIXES
--------------------------
   In addition to installing the iSeries Access for Windows Service Pack, 
   all servers should stay current on the latest Cumulative PTF Package, HIPER Group PTF, 
   and Database Group PTF. Refer to
   IBM eServer iSeries Technical Support: Recommended fixes at
   http://www-912.ibm.com/s_dir/slkbase.nsf/recommendedfixes

 2.2  Application Development function within iSeries Navigator
---------------------------------------------------------------
   The Application Development folder within iSeries Navigator
   is added when the iSeries Navigator Network component 
   is installed.  
   Application Administration can be used to restrict 
   the display of the Application Development folder 
   to certain users or groups of users. 

 2.3 iSeries NAVIGATOR DATABASES COMPONENT 
------------------------------------------
   The Import Data and Export Data wizards in iSeries Navigator use the CPYFRMIMPF 
   and CPYTOIMPF CL commands, respectively.  The commands may function check with an 
   MCH3402 message when executed by iSeries Navigator.  The first time the wizards execute 
   the command it will succeed, but later attempts may fail if the database host server job 
   is reused for a later use of the wizard.  
   The commands may fail with a CPF4248 message with reason code 3 for an ASCII or Unicode CCSID.  
   This is an error in writing data to the error record file (ERRRCDFILE parameter on the 
   CPYFRMIMPF command) if the data file is ASCII or Unicode.
   Lastly, a problem with system names that contain double quote characters has been identified. 
   Apply the latest PTFs for CPYFRMIMPF and CPYTOIMPF on the server if you plan to use the 
   Import Data and Export Data wizards.  At a minimum apply SI17635, SI17385 and SI20204 for 
   product 5722SS1 V5R3M0.

   In V5R4M0, SQL Assist has been changed so that 'smart statement selection' can be used to
   pre-prime the SQL statement at the cursor position into the SQL Assist dialog.  In V5R3M0
   and earlier, the user had to manually select the SQL statement that SQL Assist would use.  
   The new design is similar to using 'smart statement selection' to execute an SQL statement.
   However, when 'smart statement selection' is enabled, the user will be unable to position 
   the cursor at an arbitrary place in the script and start with a default SQL statement in 
   SQL Assist.  The SQL statement nearest the cursor position will be shown in the SQL Assist dialog.  
   If the user wishes to use SQL Assist to insert a new statement into the script, disable 
   'smart statement selection' with the 'Options/Smart Statement Selection' menu item.  
   SQL Assist will appear with a default statement, or with the text that was explicitly selected 
   as it would in V5R3M0.

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 = SI20465
Build date = October 2005
---------------------------------

  REQUIRED PROGRAMS
  -----------------
  APAR SE21177: CA400EXP-INCORROUT cwbback.exe faults on some PCs
    On some PCs, cwbback.exe faults when run.

  APAR SE21440: CA400EXP-ODBC-INCORROUT INSERT OR UPDATE FROM PC UNICODE TO
    A problem has been found in the Unicode to PureDBCS/Graphic
    converter logic where it will not convert characters ending in 0xFF.
    Unicode to DBCS converter will be fixed.

  APAR SE21823: CA400EXP-INSTALL-INCORROUT AFP VIEWER ON 64BIT
    The AFP Workbench Viewer does not launch on 64-bit Windows machines.
    This fix will execute the proper registry updates so the 
    AFP Workbench Viewer will launch on 64-bit Windows machines.

  APAR SE22152: CA400EXP-RMTCMD RMTCMDS WHICH PREVIOUSLY RETURNED ERROR LEVE
    RMTCMD was updated to take advantage of a new message level on
    the host side (x'02' - return all messages).  The return all
    messages option also returns messages from both the server and
    program message queues, whereas previous host levels and message
    levels only returned information from the server queue.
    This additional message source (program queue) can cause a
    previously working RMTCMD to return an error level higher than
    00.  This can cause some client applications to abnormally end.
    The remote command (RMTCMD.EXE) and remote program interfaces 
    (CWBRC.H) have been changed to allow a more complete list 
    of job messages to be returned.  For RMTCMD.EXE, this might 
    cause a different exit ERRORLEVEL to be returned depending 
    on the severity of any newly included job messages.  To 
    enable the old behavior for a given PC process, set up an 
    environment variable called CWB_RMTCMD_V5R2_MSG=*ALL or 
    a process name. For example:
      CWB_RMTCMD_V5R2_MSG=rmtcmd.exe 
    will enable the old behavior for rmtcmd.exe. 
    *ALL would enable the old behavior for all 
    processes within this environment variable scope.

    CIRCUMVENTION:
    Job messages can be removed from the returned list by calling 
    RCVMSG MSGTYPE(*EXCP) RMV(*YES) during normal MONMSG processing routines.

  APAR SE22356: CA400EXP-OPNAV-INCORROUT IFS fault with extended attributes
    iSeries Navigator could fault when browsing the IFS tree if 
    files contain large extended attributes.

  OPTIONAL COMPONENTS
  -------------------
     INCOMING REMOTE COMMAND
     -----------------------
     No fixes.

  iSeries NAVIGATOR
  -----------------
  APAR SE21629: CA400EXP-OPNAV-DBASE-WAIT LOCK NOT RELEASED BY EDIT CONTENTS
    Editing a table in iSeries Navigator may leave a lock on the 
    file that cannot be removed unless iSeries Navigator is closed.  
    1. Right click on a table and select 'Edit Contents'.  
    2. Select the 'Rows/Insert' menu item to insert a row into the 
       table.  Enter data into the columns of the table.  
     a)  Or the user may update existing data or perform other operations.
    3. Save the new data by selecting the 'File/Save' menu item.
    4. Refresh the data by selecint the 'View/Refresh' menu item.  
    5. Exit the Edit Contents dialog.
    6. A shared-read (*SHRRD) lock that iSeries Navigator acquired 
       for the table remains.  The lock will be held by a QZDASOINIT 
       job associated with iSeries Navigator.
    iSeries Navigator will release the lock when the 'Edit Contents' 
    dialog is closed.

  APAR SE22008: CA400EXP-OUTPUT-INCORROUT Change URL of Infocenter
    Infocenter Help points to an internal URL.
    Is going to be fixed, so it points to external URL.

  APAR SE22609: CA400EXP-OPNAV-INCORROUT Problems in some Cluster wizards
    There are problems in the following wizards:
      New Cluster wizard, Specify Node panel.
        - If you click on the Browse button for the Server, you will get 
          an "Unexpected Error" message.
        - If you click on the Browse button for the Cluster interface IP 
          address 1, select an IP address, and click on the OK button,  
          you will get an "Unexpected Error" message.
        - After typing the Node name, Server and Cluster interface IP 
          address 1 fields, if you click Next and the Cluster interface IP 
          address 2 is blank, you will get the message "" is not a valid 
          internet address", although this field is optional.   
      New Switchable hardware group wizard.
        - In the Specify Primary Node panel, if the Site name is blank, 
          you will get the message "Must be at least 1 character",  
          although this field is optional.
        - In the Specify Additional Node panel, if the Site name is 
          blank, you will get the message "Must be at least 1 character", 
          although this field is optional.

    CIRCUMVENTION:
      New Cluster wizard:
        - Do not use the Browse buttons in the Specify Node panel of the 
          New Cluster Wizard.
        - Type in both Cluster interface IP addresses in the Specify 
          Node panel of the New Cluster Wizard, in order to go to the next 
          panel. Both addresses have to be different from each other. The 
          second IP address can be deleted after the cluster has been 
          created by going to the properties of the node.
      New Switchable hardware group wizard:
        - Type in a Site name and add at least one Data port IP address 
          in both Specify Primary Node and Specify Additional Node panels. 
          They can be deleted after the Switchable hardware group has been 
          created by going to the properties of the group.

  DATA ACCESS
  -----------
     DATA TRANSFER
     -------------
         DATA TRANSFER BASE SUPPORT
         --------------------------
         APAR SE20527: CA400EXP-DTRANSFER UNICODE DATA WITH X'1A' IN THE DATA
           Data Transfer will detect EOF when the second byte of a unicode
           word is x'1A'.

         APAR SE20765: CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD OF MS EXCEL
           Uploading an Excel spreadsheet to an existing file and FDF
           generates a CWBTF0005 and message text indicates failure on a
           record number that exceeds the maximum visible number of records in the file.

         APAR SE21329: CA400EXP-DTRANSFER-INCORROUT WARNING MESSAGES STOP RFROMPCB
           Warning messages (Specifically CWBTF0020) cause RFROMPCB to stop
           the Data Transfer when /I switch is used.

         APAR SE21880: CA400EXP-DTRANSFER-INCORROUT SENDS MULTIPLE SHEETS
           When using iSeries Access for Windows Data Transfer to send
           multiple worksheet excel files to the iSeries, a notification
           prompt is sent to the user asking if they wish to send the first
           sheet or all sheets.  Regardless of the selection made, all
           sheets are being sent to the iSeries.
           In this customer's case, a CWBTF0020 and CWBTF0005 were
           resulting from this problem because each worksheet contained
           data formatted in different ways.

         APAR SE22045: CA400EXP-DTRANSFER INCORRECT TRANSLATE FROM VALUE
           The 'Create iSeries Database File' option in iSeries Access for
           Windows V5R3 Data Transfer sets the 'Translate from:' option in
           the 'iSeries File Details' screen differently, depending on
           whether the the ASCII text file that was scanned to create the
           new iSeries file is an even or an odd number of bytes in length.
           Scanned files that are an even number of bytes in length will
           result in a setting of Translate From Unicode, while files that
           are an odd number of bytes in length will result in a setting of
           Translate from Ascii.
           The resulting transfer and and the database file that is created
           appear to be correct.  Unicode is not used even though the
           option says Transfer From Unicode.  The FDF shows that the pc
           file type is ASCII text and it is being treated as such.  A
           SELECT HEX(F1) FROM MYLIB/MYFILE shows that the data is indeed
           single byte and not unicode and the correct values are there.
           However, some user written applications experience problems when
           processing the resulting iSeries database files.  
           MSGCPF5029 'Data mapping error' may be received.

         DATA TRANSFER EXCEL ADD-IN
         --------------------------
         APAR SE21228: CA400EXP-DTRANSFER-WAIT MS EXCEL TRANSFER FROM HANGS
           MS Excel data transfer add-in hangs after data is returned to sheet.

     ODBC
     ----
     APAR SE20631: CA400EXP-ODBC-INCORROUT BLOCK UPDATE FAILS WITH NO MESSAGE
       Even though the iSeries Access for Windows ODBC driver does not support block updates, 
       it still attempts to execute such operation when requested resulting in unexpected 
       results. The driver should be reporting a 'Driver not capable' error when asked 
       to execute block updates.
       The iSeries Access for Windows ODBC driver was fixed to return the 'Driver not capable'
       warning message when attempting block updates.

       CIRCUMVENTION:
       Change the application to do not try block updates.

     APAR SE20801: CA400EXP-ODBC-INCORROUT SPORADIC CONVERSION ERROR
       An intermittent failure in the ODBC driver intermittently causes incorrect 
       output to be generated for packed fields of length 1.  In this particular case, 
       a value of '1' was expected and instead a '10' was returned to the application 
       by the ODBC driver. A TRCCNN shows the correct data of x'1F' being returned to 
       the client. The problem is specific to packed decimal fields with a length of 1.  
       If customers hit that bug a 1 can become a 10, a 2 become a 20, a 3 become a 30,
       ....a 9 become a 90.

     APAR SE20919: CA400EXP-ODBC-INCORROUT STORED PROCEDURES COMPILED WITH *CAL
       In V5R3 a change has been made to have the Stored Procedures compiled to use the 
       *CALLER activation group to run under compiled level for every transaction instead 
       of isolation level set by the application,  As a result, an unexpected isolation level may be used.
       Support has been added to enable Stored Procedures that are compiled to use the 
       *CALLER activation to pick up the isolation level set by the application using SET TRANSACTION.

     APAR SE21192: CA400EXP-ODBC-INCORROUT ODBC RUNNING AT INCORRECT ISOLATION
       Customer is receiving SQL0913 locking errors after upgrading to R530 on an application 
       that changes the isolation level to read committed, but it does not disable autocommit.  
       For this situation, when the job is currently running *NONE, autocommit true, the ODBC driver 
       should not change the isolation level on the server.

     APAR SE21505: CA400EXP-ODBC-MSGSQL0100 PRE-FETCH OF DATA
       Incorrect output may occur if the pre-fetch of data option is
       used in the iSeries Access for Windows ODBC driver.  If a
       function or statement is executed that does not return any rows
       but the ODBC application does not perform a fetch on that
       statement and simply closes it, the next fetch function will
       return the SQL0100 message which was intended for the previous
       statement or function.  The circumvention is simply to turn off the option 
       to pre-fetch data in the ODBC data source.

       CIRCUMVENTION:
       Uncheck the prefetch option.

     APAR SE21580: CA400EXP-ODBC-MSG7399 DISTRIBUTED TRANSACTION FAILS WITH ERR
       Distributed transactions fail with the following:
       Server:  Msg 7399, Level 16, State 1, Line 3
       OLE DB provider 'MSDASQL' reported an error. One or more arguments were
       reported invalid by the provider.
       ODBC:  Msg 0, Level 19, State 1
       SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005
       EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
       OLE DB error trace OLE/DB Provider 'MSDASQL'
       ITransactionJoin::JoinTransaction returned 0x80070057:  One or more
       arguments were reported invalid by the provider.

     APAR SE21773: CA400EXP-ODBC-WAIT A CALL TO A PROCEDURE CONTAINING BLOB
       Calling a stored procedure with a BLOB parameter defined results
       in a hang when using MSDASQL OLEDB provider over the iSeries
       Access for Windows ODBC driver.

     APAR SE21909: CA400EXP-ODBC Character truncation error converting exponential 
                   number from SQL_C_CHAR to SQL_DECIMAL
       Character data right truncation error when iSeries ODBC driver converts  
       an exponential or scientific number from SQL_C_CHAR to SQL_DECIMAL
         Example: 8.16e+007 which equals 81600000.
       The iSeries ODBC Driver does not support the conversion of 
       scientific number from SQL_C_CHAR to SQL_DECIMAL. In order to 
       have same functionality as other DBMS, support to convert 
       exponential or scientific number from SQL_C_CHAR to SQL_DECIMAL was added.

       CIRCUMVENTION:
       If posible change the application to convert from SQL_C_FLOAT to SQL_DECIMAL

     OLE DB PROVIDER
     ---------------
     APAR SE21950: CA400EXP-OLEDB-INCORROUT SETTING PROPERTIES WITH SQL SERVER
       The IBM iSeries Access for Windows OLEDB provider has a number
       of properties which can be used to set connection and usage
       behaviors.  Some of these settings do not work properly.  The
       list below includes some of the problems you may encounter with properties:
         - Force Translate
         - Initial Catalog
         - Sort Table
       Force Translate
       ---------------
         When the Force Translate property is set, the OLEDB Columns 
         Schema Rowset returns incorrect information about character
         CCSID 65535 columns.  When a subsequent query is run through 
         SQL Server using a linked server with Force Translate set, 
         SQL Server may report the following message:
           Server: Msg 7356, Level 16, State 1, Line 1
           OLE DB provider 'IBMDA400' supplied inconsistent metadata for a 
           column. Metadata information was changed at execution time.
       Initial Catalog
       ---------------
         When setting this property on a SQL Server linked server
         using the 'Provider string' text box, the following error is reported:
           Error 7303:  Could not initialize data source object of OLE DB 
           provider 'IBMDA400'.  OLE DB error trace [OLE/DB Provider 
           'IBMDA400' IDBInitialize::Initialize returned 0x80040e21].
         Setting the Initial Catalog using the 'Catalog' text box works without error.
       Sort Table
       ----------
         The provider has an incorrect check for this property, so
         attempting to set the Sort Table property fails.

       CIRCUMVENTION:
       Using the Microsoft OLEDB provider for ODBC drivers in
       conjunction with an iSeries Access for Windows ODBC system data
       source allows the equivalent properties to be set.

     .NET DATA PROVIDER
     ------------------
     APAR SE20843: CA400EXP-IDB2DATA DataAdapter with LOB locators fail
       An application uses iDB2DataAdapter with a result set that 
       contains a Large Object (LOB), and LOB locators are being used.  
       The DataTable returned from calling Fill on the DataAdapter 
       incorrectly fills the table with the LOB locator value, instead 
       of filling the table with the LOB data.  This results in 
       incorrect data, and could result in SQL0423 when attempting to update the table.

       CIRCUMVENTION:
       Do not use locators with LOBs.  Set the MaximumInlineLobSize in 
       your ConnectionString to a value larger than the largest LOB you use.

     APAR SE21919: CA400EXP-IDB2DATA Avoid implicit prepares when not necessary
       The .NET Provider usually does an implicit Prepare of commands 
       when one of the iDB2Command's Execute methods is called.  In 
       many cases, this implicit Prepare is unnecessary, and results in 
       extra data flowing to and from the iSeries server each time a 
       command is executed.  The provider should only implicitly 
       Prepare commands when a Prepare is necessary.
       This PTF fixes the reported problem.  The provider will still 
       implicitly Prepare commands that need to be prepared, but it 
       will no longer implicitly Prepare commands that don't need to be 
       prepared.  If the application repeatedly runs a command and 
       wishes to ensure the command gets Prepared, it can call the 
       iDB2Command.Prepare() method to prepare the command before executing it.

     APAR SE21966: CA400EXP-IDB2DATA-INCORROUT .NET PROVIDER CONNECTION MANAGEMENT
       If an application attempts to connect using a pooled 
       iDB2Connection object, and the first connection attempt fails, 
       then subsequent attempts to connect also fail, even when the 
       original connection problem is fixed.  This happens because of 
       incorrect logic in the .NET provider's implementation of connection pooling.

       CIRCUMVENTION:
       Turn off connection pooling by setting "Pooling=false" in the ConnectionString.

     LOTUS 123 FILE FORMAT SUPPORT
     -----------------------------
     No fixes.

  AFP WORKBENCH VIEWER
  --------------------
  No fixes.

  TOOLBOX FOR JAVA
  ----------------
  Includes JTOpen 4.8 (10/06/2005).

  5250 DISPLAY AND PRINTER EMULATION
  ----------------------------------
  PC5250 Version 5.8 Level 20050818

  APAR SE20279: OSP-PAR PRINTER SESSION, FILE, PAGE SETUP, FORMS SETTING
    Printer session, File, Page setup, Forms Setting, 
    Drawer-one form is not displaying all dimension options that are provided with the 
    printer driver installed on the PC.  This is on V5R1 Client Access with the latest 
    service pack.
    This will be fixed in service packs for V5R2 and beyond of iSeries Access for Windows.

  APAR SE20458: CA400EXP-INCORROUT DISABLE STRPCCMD COMMAND VIA WS KEYWORD
    iSeries Access for Windows PC5250 needs  
    client-side control on commands issued via the 
    STRPCO/STRPCCMD server commands.
    PC5250 will allow users to disable STRPCCMD 
    through a new WS profile keyword, "Ignore_STRPCCMD".
    Users can edit a .ws file to add the following to the 
    [5250] section of the .ws profile to enable/disable 
    STRPCCMD. The keyword can have values 'Y' and 'N' 
    with the default being 'N' to allow the STRPCCMD 
    command.  Users who want to block STRPCCMD will 
    have to set the keyword to 'Y'. The keyword can 
    be set as follows: 
      [5250] 
      Ignore_STRPCCMD=Y 
    When the keyword is set to 'Y', PC5250 ignores the 
    parameters associated with STRPCCMD and simply 
    sends back to the server an Enter key to refresh the screen.

    CIRCUMVENTION:
    Control access to STRPCO and STRPCCMD commands
    via iSeries authority permissions.  

  APAR SE20629: CA400EXP-PRINTEMUL-MSGCPF5261 ERROR PRINTING WITH RHM WITHIN
    A spooled file is created that has data similar to this:
    Shift In, DBCS text characters, Relative Horizontal Move, Shift
    Out.  This will result in a MSGCPF52761 in the writer job for a
    PC5250 D/T5553 printer session that uses the 5575.pdt.

  APAR SE20734: CA400EXP-PC5250 KANA MODE INPUT INCORROUT ON CP1399 SESSION.
    When IME input mode set to 'Kana Input', input DBCS/SBCS KANA
    characters are incorrect.
    Correct HostCode        The result
        X'59'   -------------> X'D8'
        X'62'   -------------> X'D9'
        X'4481' -------------> X'C2'
        X'4482' -------------> X'C4'

  APAR SE20890: CA400EXP-TERMEMUL-INCORROUT FUNCTION KEY NOT ALLOWED WHEN US
    When function key is not defined in submenu, "FUNCTION KEY NOT
    ALLOWED" is displayed in PC5250

  APAR SE20923: CA400EXP-TERMEMUL-INCORROUT LETTER "O" AND ZERO NOT DISCERNA
    When using the Monotype Sans Duospace WT font in a PC5250 session, the capital "O" and 
    number zero cannot be differentiated.
    This will be fixed by providing a new font that differentiates the capital "O" and zero
    characters.  This new font is named "PComm Session" and the file is pcommsess.ttf .
    During install, the previous True Type Font file "Monotype Sans Duospace WT" (file name
    mtsandw.ttf) will be deleted.
    Any users that previously were using the Monotype Sans Duospace WT font for a higher
    resolution display, will automatically be switched to the default IBM3270 font.  
    Those users that want to return to using a True Type Font or start using
    a True Type Font for the first time, need to follow the instructions for the 
    Select Display Font dialog included in the following revised text from APAR SE18848:
    A change from raster (bitmap) fonts to True Type Fonts will be made.   True Type Fonts
    are scalable and display text well at higher resolutions.
    This new feature will be implemented only for English and West European languages 
    (PC codepage 1252).  No other languages will support these higher resolutions.
    New monospaced True Type Fonts containing all the characters from the current IBM3270 raster 
    font will be installed in the PC5250 installation folder. 
    -- PComm Session (pcommsess.ttf) (for displaying text)
    -- PCOMMAPL (pcommapl.ttf) (for displaying APL characters like box drawing, scrollbars, etc)   
    IBM3270 will still be the default font.  The new 
    PComm Session font (pcommsess.ttf) will need to be selected by the user via the 
    Select Display Font dialog.  Whenever the Pcomm Session font 
    is selected, PC5250 will automatically select PCOMMAPL (pcommapl.ttf) as the APL font.
    Note:  Operator Information Area (OIA) fonts will not be changed.  At higher resolutions,
    characters displayed in the OIA might appear smaller than the PC5250 window text.

  APAR SE21646: CA400EXP-TERMEMUL-INCORROUT POPUP MENU BAR OPERATION
    If the Menu-Bar is hidden, and the Popup Menu-Bar is used, duplicate menu items can 
    result.  For instance, if Communication-> Configure is selected, and then the resulting 
    panel is closed, the next time a right click is done on the title bar, multiple Popup 
    Menu-Bar menu items appear, and within those, multiple duplicate menu items.  Also, during 
    this process, if the emulator window is maximized, it will be restored to non-maximized 
    form, rather than staying at the desired maximized position.

  APAR SE21726: CA400EXP-TERMEMUL-INCORROUT KOREAN INPUT ON CODEPAGE 037
    PC5250 session is configured with code page 037 (United States).  When 
    DBCS Korean characters are entered, the PC5250 window abnormally terminates. 
    DBCS Korean characters work OK when configuration switched to host code page 939.
    DBCS on code page 037 should fail with error message or input inhibited, not with
    abnormal termination.
    A fix is provided so that when DBCS characters are input with code page 037,  
    X -S will display in the Operator Information Area (OIA) and the
    emulator session will not terminate.

  SECURE SOCKETS LAYER (SSL)
  --------------------------
  APAR SE22490: CA400EXP-INSTALL-INCORROUT SSL GSKIT 7.0.3.18  
    Update Secure Sockets Layer (SSL) component to level GSkit 7.0.3.18 .
    This PTF updates SSL to the new level.

  PRINTER DRIVERS
  ---------------
     AFP PRINTER DRIVER
     ------------------
     No fixes.

     SCS PRINTER DRIVER
     ------------------
     No fixes.

  OPERATIONS CONSOLE
  ------------------
  APAR SE21607: CA400EXP-OPCON-INCORROUT OpNav service functions unavailable
    The iSeries Navigator provides functions for managing disks and 
    logical partitions.  When iSeries Navigator is used on a PC also 
    running Operations Console with a direct cable console 
    configuration to an iSeries, and the direct console is active, 
    the disk management (DM) and logical partition (LPAR) functions 
    can be accessed by doing the following:
     -- In the "Environment tasks" side of the taskpad, choose "Open 
        iSeries Navigator service tools window".
     -- In the resulting dialog, for the "Name or address" field fill in 
        the name of the connected direct cable console config from Operations Console.
    The user gets "CWBCO1004 Remote address could not be resolved."

    CIRCUMVENTION:
    To avoid the problem, specify the IP address of the direct 
    console config instead of the name.  Usually this will be 192.168.0.2. 
                                                                               
  PROGRAMMER'S TOOLKIT
  -------------------- 
     HEADERS, LIBRARIES, AND DOCUMENTATION
     -------------------------------------
     No fixes.
  
     VISUAL BASIC WIZARDS
     --------------------
     No fixes.

     JAVA PROGRAMMER'S TOOLS
     -----------------------
     No fixes. 

  EZ-SETUP
  --------
  No 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 (if the service pack
   was originally installed with the Enable Service Pack Uninstall option):

   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 Change or Remove Programs button (if necessary), 
      then find and click on the 
      IBM iSeries Access for Windows SI20465 item, and then click on the
      Change/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.

   If installing from a CD or a faster connection is not possible,
   then the service pack could be installed in this manner:

   1)  A setting exists on 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").

   2)  Run Check Service Level (either from the 
       IBM iSeries Access for Windows Service folder shortcut or
       when Check Service Level runs at system boot on 
       its defined schedule)

       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.

   3)   Proceed through the Service Pack install wizard to 
        complete the install.
  
4.3  SERVICE PACK CONTROL
-------------------------
  To prevent users from installing the Service Pack, an 
  administrator 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, .TFR, .DTT, and .DTF 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.



