============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R3M0 Cumulative Service Pack Level ------------- SI30707 ------------- (c) Copyright IBM Corporation 2008. All rights reserved. ======================================================================== SI30707 can be installed on any PC/server that is at V5R3 service level SI10817 or newer. See iSeries Access for Windows Properties in the IBM iSeries Access for Windows folder to determine current service level. 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 RECOMMENDATIONS/RESTRICTIONS 2.1 iSeries SERVER FIXES 2.2 APPLICATION DEVELOPMENT FUNCTION WITHIN iSeries NAVIGATOR 2.3 UNIVERSAL CONNECTION WIZARD WITHIN iSeries NAVIGATOR 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 2.5 iSeries NAVIGATOR DATABASES COMPONENT 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI30707 (February, 2008) 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-03.ibm.com/servers/eserver/iseries/access/casp.html 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 being added back in V5R3 when the iSeries Navigator Network component is installed. All help and panels associated with Application Development functions will appear in English language only. To see the Application Development folder within the iSeries Navigator hierarchy, perform either of the following: -- Selectively Install (or initially install) the Network component of iSeries Navigator from an installation image containing V5R3 service pack SI13587 or newer. -- If the Network component is already installed on the PC, install service pack SI13587 or newer to receive the Application Development folder in the hierarchy. Application Administration can be used to restrict the display of the Application Development folder to certain users or groups of users. If secondary languages are installed on the PC, the Application Development English help and panels will be copied to each installed language directory. If a subsequent secondary language is installed, install service pack SI13587 or newer to copy the Application Development English help and panels into the new language directory. 2.3 Universal Connection Wizard within iSeries Navigator ---------------------------------------------------------- Running the Universal Connection Wizard to a V5R3M0 server that has not had PTF SI15166 for 5722SS1 installed could produce non-working universal connections in some scenarios. 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 ------------------------------------------ PTF 5722XE1 V5R3M0 SI16716 contains Java Runtime Environment (JRE) 1.4.2 which will replace version 1.4.1, which was on the original iSeries Access for Windows V5R3M0 media. The following APARs are fixed in JRE 1.4.2: APAR SE17968: CA400EXP-OPNAV USER-DEFINED CHARACTERS HALT STARTUP When a user-defined character(GAIJI) is created on the Windows client, iSeries Navigator does not start. The window screen appears a moment, but it ends immediately. This problem occurs on Windows XP and doesn't occur on Windows 2000. This problem disappears if we delete the GAIJI file named EUDC.EUF and EUDC.TTE from the C:\Windows\Fonts directory. A problem was found in the version of the Java Runtime Environment (JRE 1.4.1) that is shipped with iSeries Navigator. An update of the JRE to 1.4.2 is being provided to solve this problem. CIRCUMVENTION: Remove private characters to continue using iSeries Navigator without this fix. APAR SE18028: CA400EXP-OPNAV-WAIT ISERIES NAVIGATOR HANGS WITH IPV6 When Microsoft Extended TCP/IP Version 6 (IPV6) protocol is configured on the PC, iSeries Navigator Basic Operations, Printer Output never displays, and the user gets a message that iSeries Navigator is no longer responding. A problem was found in the version 1.4.1 of the Java Runtime Environment (JRE) that is shipped with iSeries Navigator. An update of the JRE to version 1.4.2 is required to solve this problem. CIRCUMVENTION: Remove Microsoft Extended TCP/IP Version 6 (IPV6) protocol by running the following from a PC Command Prompt: ipv6 uninstall If SI16716 is applied to the iSeries, and a service pack install is run from that iSeries image, the service pack install will upgrade the JRE level, if needed. Subsequent service packs will not reinstall the JRE if the latest level already exists on the PC. A new install, reinstall, or upgrade from an install image with SI16716 applied, will install the new JRE 1.4.2. For best results with reinstalls, apply PTF 5722XE1 V5R3M0 SI17496 (APAR SE19431) so that you don't have any obsolete files left over after the reinstall. A JRE 1.4.2 install package will also be provided on the IBM FTP site in a subdirectory off of the service pack FTP directory, for those users that prefer to get their service packs from the IBM FTP site. The following APAR addresses a side-effect of JRE 1.4.2 which will be fixed in the next release of iSeries Access for Windows: APAR SE19540: CA400EXP-OPNAV-INCORROUT JRE 1.4.2 INSTALL DIRECTORY When iSeries Navigator (with Java Runtime Environment (JRE) 1.4.2) is installed into a PC directory with a parenthesis '(' or ')' in the directory name, unpredictable results occur with Java operations. In particular, this is a problem with the default installation directory name on 64-bit Windows servers: C:\Program Files (x86)\IBM\Client Access This will be fixed in the iSeries Access for Windows release following V5R3M0. CIRCUMVENTION: Install into a PC directory that does not contain a parenthesis character '(' or ')'. If the PC already has iSeries Access for Windows installed into such a directory, uninstall iSeries Access for Windows, and install it again into a PC directory with no parenthesis character, prior to using iSeries Navigator with Java Runtime Environment 1.4.2. 2.5 iSeries NAVIGATOR DATABASES COMPONENT ------------------------------------------ The following documents a condition that is a permanent restriction, however, a circumention does exist: APAR SE25179: CA400EXP-OPNAV-DBASE-MSGMCH0602 VISUAL EXPLAIN Visual Explain fails with 'Boundary alignment of pointer or template not valid' error message. You may see this error when you use iSeries Navigator for V5R4 against a v5r3 or v5r4 system and try to run Visual Explain. This may happen if the QIWS.QQQDBVE2 stored procedure has been created incorrectly. CIRCUMVENTION: Recreate the QIWS.QQQDBVE2 stored procedure using the following steps: 1) In STRSQL, Run SQL Scripts in iSeries Navigator, or any SQL interface, execute the following statement: DROP SPECIFIC PROCEDURE QIWS.QQQDBVE2 2) From iSeries Navigator, go to Databases > DatabaseName > Schemas > QIWS > Procedures and then Delete the QQQDBVE2 procedure. If the QIWS is not listed on schemas, you can add it through 'Select Schemas to Display' option of the context menu of the Schemas folder. 3) iSeries Navigator is responsible for creating this procedure. The next time Visual Explain is used it will recreate the QQQDBVE2 procedure. 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 = SI30707 Build date = February, 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE29543: CA400EXP-NLS INCORROUT CONVERSION FROM CCSID 935 TO UNICODE Some DBCS characters of CCSID 935 Simplified Chinese can not be converted correctly to Unicode. Example of character that was unable to convert: 0xB9F9 RESOLUTION: When using the cwbnltbl tool to download the .tbl files that support the conversion from 935 to Unicode we use a hardcode range of characters and this range was increased to support new characters that were recently added on the host. To support the conversion of these Chinese characters to Unicode, you will need to download the .tbl files from the host. The .tbl files that need to be updated are: - 03a734b0.tbl // 935 -> 13488 - 34b003a7.tbl // 935 -> 13488 The tables are normally stored in the following path on the client: %ALLUSERSPROFILE%\Documents\IBM\Client Access but may also exist elsewhere. If they are not there, search your PC to find them. When you find them, open a command prompt to their location. If you do not find them, search for other files whose names are similar and have a .tbl extension, and open a command prompt there. If these two tables already exist, rename them from the command prompt as follows: ren 03a734b0.tbl 03a734b0.tbl.bak ren 34b003a7.tbl 34b003a7.tbl.bak Download new versions of these 2 tables by typing the following at the command prompt: cwbnltbl 935 13488 cwbnltbl 13488 935 Verify that the two new tables were created on the client. dir 03a734b0.tbl dir 34b003a7.tbl Restart all applications using iSeries Access to have the new tables take effect. APAR SE30681: CA400EXP-NLS-INCORROUT CONVERSION FROM CCSID 5035 TO 932 Incorrect mapping occurred when converting from CCSID 5035 to CCSID 932. RESOLUTION: The correct CCSID mapping has been restored. APAR SE29534: CA400EXP-INCORROUT APPLICATION ADMINISTRATION PROMPT An environment is set up to use Kerberos principal name, no prompting to connect to the server. The client is also configured to automatically start the iSeries Access for Windows Remote Command (IRC) service. Because the IRC service runs under the System account by default, it is causing a problem with the Application Administration function that results in a prompt for user ID and password. This prompt only appears once after the client has been restarted. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE30805: CA400EXP-INRMTCMD-INCORROUT EXECUTING GRAPHICAL APPLICATIONS Sometimes when using the Incoming Remote Commands function and interact with the desktop option is enabled, it fails with a "ghost window" that is, only the window frame is displayed. iSeries NAVIGATOR ----------------- APAR SE31949: CA400EXP-OPNAV-DBASE-MSGCWBNL0107 EDIT TABLE CONTENTS When trying to edit the contents of a table, iSeries Navigator may show several MSGCWBNL0107 error messages before the dialog is displayed. This may happen with database monitor data files or any table that has X'00's (nulls) as data. Each column in each row that exists in the table that has X'00's will display an error dialog and therefore the user will need to click the OK button for each dialog. RESOLUTION: When the table has at least one character field with X'00's, only one error message dialog will be displayed and the Edit Contents dialog will not be displayed. CIRCUMVENTION: 1) Edit the ODBC Data Source corresponding to the system the error is occuring on. It should be a QDSN_xxxx entry, where the xxxx is the system name configured in iSeries Navigator. On the Conversions tab, press the Advanced button and check the 'Allow unsupported character' check box. Then edit the table. ODBC will return embedded nulls in the column data and not display error messages. 2) Use the View Contents option to see the contents for read-only. APAR SE31950: CA400EXP-OPNAV-DBASE VISUAL EXPLAIN PREFERENCES LOST When using the Visual Explain window, the window preferences, including the window size, are not saved. Before closing the window, if the user changes some attributes such as window size, graphic detail, attributes detail, show messages, and arrow labels, the application does not remember the preferences of these values the next time the Visual Explain window is displayed. APAR SE31951: CA400EXP-OPNAV-DBASE-MSGCWB0111 UPDATING A CHARACTER COLUMN When updating a character column within the Edit Contents dialog in iSeries Navigator, the user may get a MSGCWB0111 error message. One way to recreate is if the user updates a value where the actual value is larger than the column length. The next attempt to update the value will fail with the MSGCWB0111 error message. It is possible to set a value larger than the column length by: 1. Having significant (non-blank) characters up to the maximum column length. 2. Adding blank spaces at the end, so the sum of the significant plus the blank characters is greater than the column length. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: The problem is because of the mismatch between the server value and the overflowed client value. So using the Refresh action will reload the data from server and the user will not end up with the error on the next update. APAR SE31952: CA400EXP-OPNAV-DBASE-INCORROUT UPDATE NOT SAVED INTO SERVER When the user updates a row through Edit Contents dialog, the data is not saved on the server and no error is signaled to the user. This is possible if the user repeatedly updates the same row and commits the change without moving between rows and using the File -> Save menu option. The dialog shows the new value, but the server does not reflect the change. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Move to another row to submit the change to the server. Then the user should use the File -> Save menu option to commit the transaction. APAR SE31158: CA400EXP Error changing properties of virtual IP interfaces Network->TCPIP Configuration->IPv4->Interfaces After change the properties of a virtual IP interface, the error "MSGTCP2652 RC1" is displayed when using the japanese version of client access. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE29150: CA400EXP-ODBC-MSGSQL0104 INCORRECT ERROR DUE TO SQL PACKAGE An ODBC application is getting an erroneous error message from the iSeries. The application was receiving an SQL0104 error message when preparing an SQL statement that appeared to have a null character embedded in the middle of a column name. The actual problem was much more complex. The connection is not using extended dynamic (package) support but the job was reused and the previous use of the job had used an SQL package for extended dynamic support. The host attempted to use extended dynamic on the prepare of the statement because the ODBC driver passed the code for an SQL package name, but it didn't actually send a package name. This code point should not have been sent at all. The problem can easily recreated in the lab using the ODBCTest program and performing the following steps: Make a full connect with odbctest using a DSN with extended dynamic turned off. Perform and SQLExecDirect on the following statement: "Set transaction isolation level none" Then peform an SQLPrepare on the following statement: "Select * from qiws.qcustcdt where lstnam = ?" Next bind some data like 'Jones' to the parameter marker and execute the statement. APAR SE29339: CA400EXP-ODBC-WAIT VARIABLE FIELD COMPRESSION The V5R4 ODBC driver when connected to a V5R4 i5/OS will request and get data back with variable field compression. In some cases, the ODBC driver cannot parse the compressed data correctly. This failure will result in a hang in the ODBC driver, the application using the ODBC driver will likely appear to have stopped responding. This problem can be circumvented by adding a keyword to the data source or connection string. The ODBC driver supports a number of features through the use of a keyword, DEBUG, which works like a bitmap value. If the debug value is already set to add 1024 to that value. If the keyword doesn't exist on the connection string, you need to add it and set its value to 1024. This change cannot be made through the ODBC data source setup program, it has to be done either programmatically if DSN-less connections are used. If a file DSN is being used, modify the data source file with a text editor and add a new line to the data source: DEBUG=1024 If a machine data source is being used, then the data source will have to be changed by updating the windows registry. We do not advocate directly editing the registry though. The iSeries Access for Windows product provides a console application, cwbodbcreg, that can be used to modify the data source from a windows command line. As an example of how to use this tool, imagine that you have a data source named "My iSeries ODBC DSN". To update the data source, run the following command at a Windows command prompt (DOS prompt): cwbodbcreg "My iSeries ODBC DSN" debug 1024 RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Disable variable length compression setting the debug keyword to: "DEBUG=1024" APAR SE30295: CA400EXP-ODBC-INCORROUT INCORRECT TYPE CONVERSION USED A PC application is using the iSeries Access for Windows ODBC driver through Microsoft's MSDASQL OLEDB provider. Because of this configuration, the application is not making ODBC API calls directly, they are using ADO and the MSDASQL provider determines which ODBC APIs to call and how to call them. When a query returns a LOB type followed by a numeric type it was discovered that the MSDASQL provider will not bind the non-LOB columns or even use the SQLGetData and specify a data type to return the data as. Instead they are defining a descriptor using the SQLSetDescField function to define the column type and size as numeric then later calling the the SQLGetData function specifying SQL_ARD_TYPE for the target type. Tracing and re-creates showed that the iSeries Access ODBC driver is returning the data as character rather than the ARD type which was defined as numeric. This may ultimately result in another error such as a truncation error or data out of range type of error but that error is because of what the application does with the data that was returned to them in the incorrect format. APAR SE30749: CA400EXP-ODBC-WAIT HANG ENDING XA ENLISTMENT iSeries Access for Windows ODBC driver is being used in conjunction with Microsoft's Distributed Transaction Coordinator in Microsoft SQL Server environment with an ODBC connection pool. The first use of the ODBC connection enlists the ODBC driver in a distributed transaction and uses the connection without commiting or rolling the the transaction back. The connection is returned to the connection pool and sits idle until the next use. The second use first has to end the existing transaction. The ODBC driver enters into the function to un-enlist it from the existing distributed transaction. The ODBC driver never returns back from that function. To the SQL Server application it appears to be hung. OLE DB PROVIDER --------------- APAR SE31868: CA400EXP-OLEDB-INCORROUT ADSCHEMACOLUMNS FOR OPENSCHEMA METHOD RETURNS NO RESULTS WHEN USING CLIENT SIDE CURSOR. Microsoft ADO OpenSchema method using adSchemaColumns as the QueryType returns empty results instead of a list of columns when using iSeries Access for Windows OLE DB provider. This issue only occurs when using a client side cursor, adUseClient. Using a server side cursor, adUseServer, returns the correct results .NET DATA PROVIDER ------------------ No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.0 (08/20/2007) and the equivalent of PTF 5722JC1 SI28310. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.7 Level 20080124 APAR SE31946: CA400EXP-TERMEMUL-INCORROUT THE CURSOR DOES NOT APPEAR ON THE FIELD IF THAT IS DEFINED DSPATR(BL HI). The cursor does not appear on the field If that is defined dspatr(BL HI). Blink atribute. For instance: there are three field as FA(first) FB(second) FC(third) FA _____ FB ____ FC ____ FA and FB do not show up the cousor but FC can see it Any condition: This happens on V5R3 as well. APAR SE31947: CA400EXP-PRINTEMUL PRINTER EMULATION ENDS ABNORMALLY WITH PDT CONTAINING START_JOB WITH MORE THAN 255 BYTES A pdt table is created from custom source. The source contains a START_JOB tag with more than 255 bytes of data. When put in use, the printer emulation session ends abnormally. APAR SE31948: CA400EXP-TERMEMUL-INCORROUT PC5250 DOES NOT SUPPORT GREEK ALPHABETIC CHARACTERS IN AN ALPHABETIC ONLY FIELD. iSeries Access for Windows PC5250 display emulation flags a status bar message 'Field requires alphabetic characters' when Greek alphabetic characters are typed into an alphabetic only input field. The PC5250 session is correctly setup for a Greek environment. APAR SE30508: CA400EXP-TERMEMUL-UNPRED IN A KOREAN INSTALL ENVIRONMENT, SWITCHING BETWEEN APPLICATIONS CAUSES THE EMULATOR TO CLOSE. When a user with a Korean installation of iSeries Access opens multiple sessions and attempts to switch between them, all sessions close without warning. APAR SE31693: CA400EXP-PRINTEMUL LATIN 2 CHARACTERS NOT PRINTED CORRECTLY USING PC5250 PRINTER EMULATION Customer is printing spooled files that contain print data from code page 870. They have created a PC5250 printer emulation session using iSeries Access for Windows. They are not using pdt or host print transform support. The PC is setup to be using a proper Latin 2 language in its regional settings. However, the special Latin 2 characters are not printing correctly. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. 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 = SI28055 Build date = August, 2007 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE29368: CA400EXP-NLS-INCORROUT Japanese character conversion Some characters are corrupted when converting the data from Unicode (UCS-2) to mixed-EBCDIC (5026/5035). The affected characters are: X'815C' (HORIZONTAL BAR) X'8160' (FULLWIDTH TILDE) X'8161' (PARALLEL TO) X'817C' (FULLWIDTH HYPHEN-MINUS) RESOLUTION: To support the conversion of these Unicode characters to mixed-EBCDIC, you will need to perform two tasks, one on the host side and one on the client side. 1. Install the iSeries PTF that matches the i5/OS release level - V5R3 PTF SI25845 - V5R4 PTF SI25738 2. The client has 2 tables that need to be updated. The file names are: - 04b013ab.tbl //DBCS 1200 -> 5035 - 04b013a2.tbl //DBCS 1200 -> 5026 The tables are normally stored in the following path on the client: %ALLUSERSPROFILE%\Documents\IBM\Client Access but may exist elsewhere. If they are not there, search your PC to find them. When you find them, open a command prompt at their location. If you do not find them, search for other files whose names are similar and have a .tbl extension, and open a command prompt there. If these two tables already exist, rename them from the command prompt as follows: ren 04b013ab.tbl 04b013ab.tbl.bak ren 04b013a2.tbl 04b013a2.tbl.bak Download new versions of these 2 tables by typing the following at the command prompt: cwbnltbl 1200 5035 cwbnltbl 1200 5026 where is the host where the iSeries PTFs were installed. Verify that the two new tables were created on the client. dir 04b013ab.tbl dir 04b013a2.tbl Restart all applications using iSeries Access to have the new tables take effect. APAR SE28646: CA400EXP-LICMGMT-MSGCWB0999 RC 9052 274D LICENSE MANAGEMENT ERROR. Intermittent CWB0999 RC 9052 274D License Management error. APAR SE29369: CA400EXP-NLS-INCORROUT PRE-FORMATTED TEXT BIDI TRANSFORMS Bidirectional scripts transformations can fail when transforming specifically formatted text such as XML or HTML data, and cause incorrect output. RESOLUTION: Via the iSeries Properties one can enable bidirectional script transformations. When this box is checked, all data in any BIDI Coded Character Set ID (CCSID) will be right-to-left transformed for proper viewing. Sometimes data in a BIDI CCSID is already properly formatted, and applying the right-to-left transformation breaks this. An example would be a database record with one field containing names, which should be right-to-left transformed, and another field containing XML or HTML data, which should not be transformed. Now we provide a way to enable/disable BIDI transformations per CCSID value via a registry key. This registry key overrides the "Enable Bidirectional script transformations" checkbox. This allows BIDI transformations to be enabled or disabled for specific CCSIDs while continuing to transform all other BIDI CCSIDs as usual. If the "BIDI Transform Override" is set in the registry with the specific CCSID and BidiTransform = 0, then data in that CCSID will not be transformed. But If the "BIDI Transform Override" is set in the registry with the specific CCSID and BidiTransform = 1, then data in that CCSID will now be transformed. The override will be only used when CCSID conversions are done and when the "BIDI Transform Override" registry key has been set. To set the registry key follow these steps: 1. Create a file named BIDI_Transform_Override.reg 2. Copy the next 4 lines (including the blank line) into the new file: Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\IBM\Client Access Express\CurrentVersion\NLS] "BIDI Transform Override"="62235,0" 3. Remove the "62235,0" text and replace it with the right values: The format is: "CCSID,0|1[,CCSID,0|1[, ...]] " where: CCSID = the BIDI CCSID value (for example, 62235) 0 for no transform and 1for transform 4. Save the changes 5. Double click the BIDI_Transform_Override.reg file to enable the override in the registry. 6. Restart applications for this to take effect. Note that this registry key is in the user-specific part of the registry, so it will affect only the current user. Each user who wants to use the BIDI Transform override must create this registry value while logged on to Windows. CIRCUMVENTION: Re-tag the data as non-bidi in the database. APAR SE28143: CA400EXP-INCORROUT CCSID override needed for 300 and others Some users have CCSID values hardcoded in their application, but they would like their CCSID values to be overridden by a better one. For example the CCSID 300 is an old, unchanging CCSID, where CCSID 4396 is a newer and growing CCSID. Some users have the CCSID 300 hardcoded, but they would like to have CCSID 4396 used instead. RESOLUTION: We are going to provide a way to override a CCSID value. The override will be only used when CCSID conversions are done. The override is done using a registry key entry in the string format oldCCSID,newCCSID. Under the registry path: HKLM\Software\IBM\Client Access\CurrentVersion\NLS you can add the following entry of type string: Name = "CCSID-Override" Value= "OldCCSID,newCCSID,oldCCSID,newCCSID,..." For example: CCSID-Override = 300,4396 Restart applications for this to take effect. CIRCUMVENTION: Applications need to use more up-to-date CCSIDs, and should move toward using Unicode. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE29547: CA400EXP-OPNAV-DBASE CANNOT UPDATE DBCS BLANK-ENDED COLUMN Using iSeries Navigator the user may not be able to edit the contents of a table. This only occurs when trying to edit the data in an existing column where the column's CCSID is DBCS, such as 5035 or 5026, and if the value ends with DBCS blank like X'0E42C140400F'. The user may see the error message 'Either the row you attempted to change no longer exists in the table, or, if you inserted this row, a defaulted field does not match what is being displayed. Select Refresh from the File menu to update the data being displayed'. APAR SE28046: CA400EXP-OPNAV-FILESYS Drag and drop causes lost focus The problem may result when the user does the following within iSeries Navigator: expands File Systems, Integrated File Systems and Root, navigates to a subdirectory with a long list of elements and then drags and drops a file into that subdirectory. The resulting problem is the window refreshes and displays the root directory closing the subdirectories and forcing the user to re-navigate down for subsequent drags and drops. APAR SE28009: CA400EXP-NETWORK-INCORROUT Incomplete UCW phone list Universal Connection Wizard under "phone number" and "backup phone" panels doesn't display the complete service phone number list. APAR SE27882: CA400EXP-NETWORK-INCORROUT wrong username on UCW profiles Universal Connection Wizard doesn't add the ATT/ prefix to QLCLDIAL01 and QRMTDIAL01 profiles when the direct dial-up phone number is from China or when the country selected is China for remote dial-up. Communication won't be established when dialing numbers within China without the ATT/ prefix. RESOLUTION: This PTF fixes the reported problem, as long as the following i5/OS PTF is also installed: 5722SS1 V5R3M0 SI26385 5722SS1 V5R4M0 SI26560 DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE28290: CA400EXP-DTRANSFER DOWNLOAD GUI FAILS TO APPEND TO BIG FILES Data Transfer from GUI fails to append to big files and displays the following error message: Incorrect parameter. This problem has been reported with files over 4Gb. in size. APAR SE28396: CA400EXP-DTRANSFER-PERFM TRANSFERS SLOW WITH SI25949 SI26600 iSeries Access for Windows data transfer downloads to the PC are considerably slower with service pack SI26600 (V5R3) and SI25949 (V5R4) than they are with previous service packs. APAR SE28716: CA400EXP-DTRANSFER-INCORROUT HANG DOWNLOADING FILE Data Transfer from iSeries hangs when downloading a file to the PC. The display of the number of records transfered stops increasing and the process must be stopped by pressing the Cancel button. The QZDASOINIT joblog displays a data mapping error. Message CPF5035 (MSGCPF5035) with reason code 181, "Value in date, time, or timestamp string not valid.", followed by an SQL0181 (MSGSQL0181), meaning that the actual error will be returned on the next stream fetch. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE28396: CA400EXP-DTRANSFER-PERFM TRANSFERS SLOW WITH SI25949 SI26600 iSeries Access for Windows data transfer downloads to the PC are considerably slower with service pack SI26600 (V5R3) and SI25949 (V5R4) than they are with previous service packs. ODBC ---- APAR SE28376: CA400EXP-2-MSG "Enlist with DTC phase failed. 2" failure in distributed transaction An Application that uses the MSDASQL provider is receiving the "ODBC 32-bit : err: [IBM][iSeries Access ODBC Driver]Enlist with DTC phase failed. 2" error message in a distributed transaction. The trace shows that the userID is getting truncated sometimes when a new connection is being started, causing the failure. APAR SE28373: CA400EXP-ODBC-MSGSQL0180 SQLDescribeParam problem The ODBC driver is incorrectly reporting a timestamp field as a character field when the SQLDescribeParam API is called. This behavior can cause applications to provide invalid data for a timestamp field resulting in an SQL0180 error. APAR SE28524: CA400EXP-ODBC-INCORROUT ODBC DRIVER KEYWORD TRIMMING OPTION The ODBC driver does not have a connection string option to allow trimming of spaces off of CHAR fields retrieved from the iSeries. This APAR is a request for an ODBC connection string keyword to take advantage of functionality available in the SQLSetConnectOption api for trimming spaces from CHAR fields. RESOLUTION: A option for DEBUG keyword has been added to ODBC driver in order to allow trimming of spaces off of char fields. The behavior of this option will be the same to the SQLSetStmtAttr(ATTR_TRIM_CHAR_FIELDS) API. The value for DEBUG Keyword to do this work is: 0x00002000 or 8192. OLE DB PROVIDER --------------- APAR SE27877: CA400EXP-OLEDB-INCORROUT MS SQL SERVER 2005 SP1 DTS Wizard Microsoft SQL Server 2005 service pack 1 DTS Wizard is unable to import data from System i5/OS DB2 using the IBM DB2 for i5/OS IBMDASQL and IBMDA400 OLE DB Provider. The problem exists only if the Service Pack 1 is applied to MS SQL Server 2005, it is because of Microsoft added support for a new TABLE_TYPE called SYNONYMS which is not supported in DB2 and the error is not handled correctly by the OLE DB provider. The following error is recorded in the OLEDB provider log: CSession::GetRowset() - p400SchemaRowset() returned: 80070057 Also, data is not imported when "Write a query to specify the data to transfer" option is selected in DTS Wizard. The next error occurs when trying to import data: No error message available, result code: DB_E_CANTCANCEL(0X80040E15). APAR SE27941: CA400EXP-OLEDB-INCORROUT Error 0x80040E00 in SQLServer SSIS The IBM DB2 for i5/OS IBMDASQL OLE DB Provider fails while Using Visual Studio 2005 to create an SSIS package for use with MS SQL Server 2005, if a Data Flow task using IBMDASQL is set to use SQL Command, the task fails with: Error: An OLE DB error has occurred. Error code: 0x80040E00. Error: The PrimeOutput method on component "OLE DB Source"(1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. APAR SE28443: CA400EXP-OLEDB-INCORROUT LEADING WHITE SPACE NOT IGNORED The iSeries Access for Windows OLEDB providers do not ignore leading spaces in the SQL statement or command text when using it for a connection to iSeries through a SQL linked server when using a select statement for open query. This causes the OLEDB provider to not execute the statement or command text when it is preceded by tabs, carriage returns and line feed characters and the following error: Msg 7357, Level 16, State 2, Line 1 Cannot process the object Select * From ". The OLE DB provider "IBMDASQL" for linked server "" indicates that either the object has no columns or the current user does not have permissions on that object. .NET DATA PROVIDER ------------------ APAR SE28398: CA400EXP-IDB2DATA-INCORROUT DESERIALIZING IDB2EXCEPTION OBJECT FAILS WITH EXCEPTION. Attempting to serialize/deserialize an IDB2Exception object fails during deserialization with an exception - The constructor to deserialize an object of type 'IBM.Data.DB2.iSeries.iDB2SQLErrorException' was not found. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.2 (08/28/2006) and the equivalent of PTF 5722JC1 SI25173. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.7 Level 20070718 APAR SE29615: CA400EXP-2-PERFM MEMORY LEAK WHEN RUNNING VB MACRO Running a Visual Basic (VB) macro causes a memory leak. APAR SE28231: CA400EXP-TERMEMUL-INCORROUT YEN SIGN IS CHANGED TO THE MIDDL The yen sign is changed to the middle dot by STRPCCMD. This problem is unique to the Japanese DBCS environment. APAR SE28504: CA400EXP-TERMEMUL-UNPRED FILE RUN THE SAME CAUSES PROMPT When a connection is configured in iSeries Navigator to use the "Prompt every time" option but the PC5250 session is configured for "Use Windows username and password, no prompting", Using File--> Run the same causes new sessions to prompt for the user name and password anyway. APAR SE28541: CA400EXP-TERMEMUL-INCORROUT HACL SCREEN RECOGNITION EVENT HACL (Host Access Class Library) event notification of screen recognition events are not funtioning in a .net environment. APAR SE28564: CA400EXP-TERMEMUL-PC5250 SBCS in DBCS field hangs session Entering Single Byte Character Set (SBCS) data into a Double Byte Character Set (DBCS) data field on user menu causes the PC5250 session to hang with X-II (in red) in the Operator Interface Area (OIA) status display. Neither pressing the reset key nor system request help. APAR SE28682: CA400EXP-SECURITY-UNPRED USER PROFILES BELONGING TO MULTIPLE ACTIVE DIRECTORY GROUPS MAY FAIL WITH PC5250 KERBEROS SSO. Users with multiple groups and/or subgroups assigned to their Active Directory account and using iSeries Access for Windows PC5250 configured for Kerberos single signon may fail to bypass the signon screen APAR SE28732: CA400EXP-APIS-OTHER-PERFM CUSTOM PROGRAM USING AUTSESS.DLL, CAUSES A PC5250 PERFORMANCE ISSUE After installing iSeries Access Service Pack SI26600, a customer creates an external program with Visual Basic 6. This program creates an instance of type PCOMM.autECLSession (autsess.dll). While the program is running the first time, no problem exists and the performance is fine. After ending this external program, iSeries Access PC5250 sessions run very slowly. This situation is worsened by starting and ending the external program again. This problem can be solved by uninstalling the service pack SI26600. APAR SE28893: CA400EXP-TERMEMUL-MSGCPIAD06 FAILURE IN APAR SE27644 STILL OCCURS WITH PTFS SI26600 OR SI26879 IF USING MULTIPLE SESSIONS. The failure described in APAR SE27644, where a CPIAD06 invalid password error is generated in the QTVDEVICE job if an iSeries Access for Windows PC5250 session configured for Bypass Signon and Auto-reconnect reconnects after a communications failure, still occurs even with PTFs SI26600 (V5R3) or SI26879 (V5R4) applied. The problem only still occurs if there are multiple sessions open. APAR SE28940: CA400EXP-PRINTEMUL SLOWER PRINTING WITH ESC_P.PDT A printer session is setup to use the esc_p.pdt. After install of service pack level SI24723, SI25949, or SI26879, printer performance was slower. APAR SE29104: CA400EXP-PRINTEMUL FONT IS PRINTED TOO SMALL PC5250 printer session is created that does not use Host Print Transform and does not use PDT. Under File/Page Setup... they have disabled automatic page orientation and selected portrait for both drawers. BestFit is not used. The file should print in the font specified in the printer file, but PC5250 is shrinking the font. APAR SE29388: CA400EXP-TERMEMUL-UNPRED PCSWS.EXE EXITS WHEN WINDOWS REGIONAL SETTINGS ARE VIETNAMESE. PCSWS.EXE crashes when setting Windows Regional settings to Vietnamese. PC5250 is configured for Vietnamese. The issue occurs both at V5R3 and V5R4 version of the client. APAR SE28195: CA400EXP-TERMEMUL-INCORROUT IN A CL PGM THE COMMAND STRPCCMD The command STRPCCMD PCCMD('PAUSE') PAUSE(*NO) is used in a CL program. During executing the Pause command (or any long running PC program), the PC5250 session is not input inhibited. The CL program will not wait until the PC command finishes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE29546: CA400EXP - XDA stack corruption problem number 2 XDA has intermittent problem when running heavy ISV workloads that causes memory corruption. The problem occurs on three-tier environment due to data intensive workload. The result is that the ISV work process abort and need to be restarted. RESOLUTION: XDA was fixed for a memory corruption problem and was also fixed for DBCLOB access. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI26600 Build date = February, 2007 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE26420: CA400EXP-INCORROUT CWBNL0101 FOR CODEPAGE 1386 to 937 OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE27306: CA400EXP-NETWORK-INCORROUT DNS autostart checkbox not saved APAR SE27316: CA400EXP-OPNAV-DBASE-INCORROUT VARYING DATA SIZE DESC DIALOG APAR SE27357: CA400EXP associate "None" to physical interfaces APAR SE27844: CA400EXP-OPNAV-DBASE-INCORROUT SHOW ACTIONS OVER MQTs IN VE APAR SE27845: CA400EXP-OPNAV-DBASE-INCORROUT JDBC ESCAPE SEQUENCE IN RSS APAR SE27850: CA400EXP-OPNAV-DBASE-MSGSQL0501 SCROLLING RESULT SET VIEWER APAR SE27871: CA400EXP-OPNAV-NETWORK-INCORROUT ATT prefix problems DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE26929: CA400EXP-DTRANSFER RXFERPCB & ACTIVEX NOT REPORTING ERRORS APAR SE27233: CA400EXP-DATAXFER MEMBER AND FILE TEXT DO NOT SUPPORT DBCS APAR SE27880: CA400EXP-DTRANSFER BATCH APPS CRASH WITH EMPTY LIST FILES APAR SE27881: CA400EXP-DTRANSFER FIELD LENGTH IS INCORRECTLY VALIDATED DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE27102: CA400EXP-DTRANSFER EXCEL ADD-IN CONVERTS TABS TO SPACES APAR SE27553: CA400EXP-DTRANSFER COMMA NOT SUPPORTED AS DECIMAL SEPARATOR APAR SE27739: CA400EXP-DTRANSFER EXCEL ADDIN DOWNLOAD FAILS IN EXCEL 2007 APAR SE27879: CA400EXP-DTRANSFER PROTECTED SHEETS CAUSE EXCEL TO CRASH ODBC ---- APAR SE26605: CA400EXP-ODBC-INCORROUT - CORRUPTS PARAMETER MARK APAR SE26738: CA400EXP-ODBC-PERFM - Several ODBC driver performance fixes APAR SE26785: CA400EXP-ODBC-INCORROUT INTERNAL DRIVER ERROR WHEN CACHE APAR SE27506: CA400EXP-ODBC-INCORROUT BLOCK UPDATABLE CURSOR BEHAVIOR WITH ADO/ODBC APAR SE27524: CA400EXP-ODBC-INCORROUT AUTOCOMMIT AND ISOLATION LEVEL NOT OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE27502: CA400EXP-IDB2DATA-MSGSQL0470 Don't set null for output-only parameters APAR SE27503: CA400EXP-IDB2DATA-MSGSQL0502 after calling SP using ExecuteNonQuery APAR SE27521: CA400EXP-IDB2DATA-UNPRED IDB2DATAADAPTER METHOD LEAKS MEMORY LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.2 (08/28/2006) and the equivalent of PTF 5722JC1 SI25173. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.7 Level 20070104 APAR SE25556: CAEXP-PC5250-PRINT-INCORROUT SPOOL FILE IS HELD WITH MSGCPF5 APAR SE26231: CA400EXP-TERMEMUL Macro prefix with space hides others APAR SE26558: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION IS INCORRECT AFT APAR SE26717: CA400EXP-TERMEMUL-MSGECL37180 THE '@' KEY STROKE THROWS AN APAR SE27542: CA400EXP-PRINTEMUL-PERFM SLOW PERFORMANCE OR FAILURES USING APAR SE27549: CA400EXP-OUTPUT-INCORROUT COMMAND LINE OR UNDERLINE DISAPPEA APAR SE27562: CA400EXP-TERMEMUL Unique session ID limit too small APAR SE27620: CA400EXP-2-INCORROUT TERMINAL SERVER ENVIRONMENT DOES NOT APAR SE27644: CA400EXP-COMM-MSGE004 AUTO RECONNECT WITH BYPASS SIGNON PASS APAR SE27733: CA400EXP-PRINTEMUL-UNPRED PRINTER SETUP WINDOW ALWAYS DISPLA PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE27504: CA400EXP-DTATRANS-INCORROUT ZonedConverter FromBytes fails APAR SE27888: CA400EXP - Update XDA Windows client VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI24723 Build date = August 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE25413: CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION SIGNON APAR SE25775: CA400EXP - LOB optimization in XDA OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE25206: CA400EXP-OPNAV-FILESYS UNABLE TO ADD HOST TO NETGROUP BY IP APAR SE26200: CA400EXP-OPNAV-OUTPUT-INCORROUT PAGES PER COPY DOES NOT SORT APAR SE26273: CA400EXP-OPNAV-OUTPUT-INCORROUT SHORTCUTS TO PRINTER OUTPUT APAR SE26341: CA400EXP-OPNAV-DBASE-INCORROUT BLANK LINES PASTING FROM RSS DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE25348: CA400EXP-DTRANSFER-INCORROUT PASTING DATA AS LINK IN EXCEL APAR SE25421: CA400EXP-DTRANSFER-INCORROUT WRONG COLUMN SORTING IN DISPLAY APAR SE26348: CA400EXP-DTRANSFER CREATE HOST FILE WITH EMPTY COLUMNS FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE26329: CA400EXP-DTRANSFER EXCEL ADD-IN HANGS AFTER DOWLOADING FILE ODBC ---- APAR SE25951: CA400EXP-ODBC-INCORROUT - SQLTABLES PROBLEM WITH MQT APAR SE26325: CA400EXP-ODBC-MSGERROR IN HOST SERVER DATASTREAM MS ACCESS 9 OLE DB PROVIDER --------------- APAR SE25454: CA400EXP-OLEDB-UNPRED WHEN IN PARM IS DEFINED AS IN/OUT APAR SE25755: CA400EXP-OLEDB BLANK PROPERTY IN EXTENDED PROPERTIES FAILS .NET DATA PROVIDER ------------------ APAR SE25710: CA400EXP-IDB2DATA Read & Write LOB data in chunks more often LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.1.1 (05/17/2006) and the equivalent of PTF 5722JC1 SI23753. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.7 Level 20060629 APAR SE24106: CA400EXP-OPCON-HOST PRINT FAILS WITH MSGMCH0601 OR MSGCPF519 APAR SE25092: CA400EXP-TERMEMUL-INCORROUT PC5250 WINDOW DISAPPEARS WHEN APAR SE25262: CA400EXP-PRINTEMUL-INCORROUT PRINT SAME SPOOLED FILE TWICE I APAR SE25697: CA400EXP-COMM-UNPRED PC5250 HANGS AFTER HITTING RESET KEY APAR SE26108: CA400EXP-OUTPUT-INCORROUT DISPLAY FIELDS ARE NOT PRESENTING APAR SE26139: CA400EXP-TERMEMUL-INCORROUT IN A CL PGM THE COMMAND STRPCCMD PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE25845: CA400EXP-OPCON-INCORROUT cpanel src changes not displayed 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 = SI23492 Build date = April 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE24282: CA400EXP-OPNAV HANDLE LEAK IN APPLICATION ADMINISTRATION APAR SE24598: CA400EXP-OPNAV-INCORROUT extended attributes trap in IFS APAR SE24713: CA400EXP-INSTALL-INCORROUT INSTALL SAME SERVICEPACK TWICE APAR SE25099: CA400EXP-COMM-MSGCWBSY1040 Windows credentials not found OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE22926: CA400EXP-OPNAV-MSGCWBNL0107 EDIT TABLE CONTENTS DBCS BLANKS APAR SE23833: CA400EXP-OPNAV-DBASE-UNPRED EXPLAIN SQL FROM VE EMPTY ERROR APAR SE24007: CA400EXP-OPNAV-DBASE-INCORROUT ACCESS PLAN REBUILD COUNT APAR SE24220: OSP-DB-MSGCPFA0A2 ACCESSING PERMISSIONS FROM ISERIES NAVIGAT APAR SE24548: CA400EXP-OPNAV-DBASE-INCORROUT REORGANIZE TABLE INFORMATION APAR SE24766: CA400EXP-INCORROUT WHEN EXPORTING SYSTEM MONITOR DBCS DATA APAR SE24819: CA400EXP-OPNAV-NETWORK-MSGDATA DATA ENTRY ERROR MESSAGE APAR SE24880: CA400EXP-OPNAV-JOBS-INCORROUT CURRENT SQL STATEMENT STATUS APAR SE25013: CA400EXP-OPNAV-DBASE-INCORROUT TIMESTAMP ON SHOW INDEXES APAR SE25067: CA400EXP-OPNAV-DBASE-INCORROUT INVALID COLUMN ID ON INDEXES DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE24030: CA400EXP-DTRANSFER A CRASH OCCURS WHEN BROWSE FOR LIBRARIES APAR SE24081: CA400EXP-DTRANSFER INCORRECT CELL TEXT ALIGNMENT IN HTML APAR SE24961: CA400EXP-DTRANSFER USERID NOT SAVED CORRECTLY IN DTT FILE APAR SE25102: CA400EXP-DTRANSFER INCORRECT ERROR MESSAGE DISPLAYED DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE24170: CA400EXP-DTRANSFER USERID TRUNCATION IN EXCEL ADD-IN ODBC ---- APAR SE00013: CA400EXP-ODBC FETCH PROBLEMS WITH SQL_ATTR_ROW_ARRAY_SIZE APAR SE24755: CA400EXP-ODBC DRIVER CRASH WITH LARGE SQL_C_DOUBLE VALUES APAR SE25100: CA400EXP-ODBC-INCORROUT FIRST CHAR OF LIBRARY NAME REPLACED BY BLANK OLE DB PROVIDER --------------- APAR SE24629: CA400EXP-OLEDB-MSGSQL0104 Problems with long database names .NET DATA PROVIDER ------------------ APAR SE24436: CA400EXP-IDB2DATA-INCORROUT CLOB LENGTH SET INCORRECTLY WITH APAR SE24985: CA400EXP-IDB2DATA-INCORROUT NullReferenceException in GetDcRow LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.0 and the equivalent of PTF 5722JC1 SI21370. Also includes the equivalent of PTF 5722JC1 SI23152: APAR SE24779: CA400EXP-OPNAV-INCORROUT Prompting problem with CALLPRC 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.7 Level 20060320 APAR SE22922: CA400EXP-TERMEMUL-INCORROUT CURSOR DOESN'T MOVE TO THE FIRST APAR SE23600: CA400EXP-TERMEMUL-INCORROUT EVENT NOTIFICATION NOT WORKING APAR SE23782: CA400EXP-TERMEMUL-INCORROUT HACL NOTIFYKEYEVENT The Host Access Class Library automation object autECLPS includes functionality for event-driven keystroke notification from a presentation space. In order to use this functionality, a function NotifyKeyEvent has to be created and it will be called once event notification has been enabled by calling the RegisterKeyEvent method on the presentation space automation object. The documentation for the NotifyKeyEvent parameters is incorrect in the object and the manual. No combination of types similar to those documented were found to work. APAR SE24597: CA400EXP-TERMEMUL-INCORROUT STRPCCMD FAILS WITH BATCH FILES APAR SE24958: CA400EXP-PRINTEMUL-INCORROUT EXTRA SPACE CHARACTER INVALIDAT APAR SE25088: CA400EXP-TERMEMUL-INCORROUT Keyword support for color settings on 5250 The emulator screen color should come in 2 choices: the traditional green screen or black text on white background. RESOLUTION: We will provide the keyword ScreenColor in both pcswin.ini and .ws files for specifying the color mode. For pcswin.ini, ScreenColor should be placed in the [Session] section. For a .ws file, ScreenColor should be placed in the [Colors] section. There will be four color key values: 1. UseDefault - Default green text on black background (Multi-color mode). 2. WhiteBoard - Black text on white background. 3. BlackBoard - White text on black background. 4. SystemDefault - Take foreground & background colors specified for 'Window' Item on Display Properties or Advanced Appearance dialog ('Control Panel -> Display -> Appearance tab -> Advanced button for Windows XP). The value specified in the .ws profile will take precedence over the pcswin.ini value. This way, Administrators can specify an alternative default color mode in pcswin.ini (system-wide color mode setting). So when the user configures a new session, admin-specified alternative default value will be picked up. If the user wishes to override admin-specified alternative default value then, they can specify it in the .ws. This would be per session. If nothing is specified in either pcswin.ini or in the .ws, the default display text will be traditional green screen (multi-color mode). Example for pcswin.ini: [Session] ScreenColor=WhiteBoard Example for a .ws file: [Colors] ScreenColor=SystemDefault CIRCUMVENTION: The colors can be changed/personalized on the menu Edit->Preferences->Appearance->Color Mapping. The color changes will be saved into the .ws if the current session is saved. Also, the color key value will be set to UseDefault (multi-color mode) in the saved .ws file by the application. APAR SE25221: CA400EXP-TERMEMUL-INCORROUT Not using iNav default SSL port The communications port on a PC5250 emulation session created by iSeries Navigator should automatically change to match any subsequent port change in the iSeries Navigator connection. This way, when the user chooses to connect with iSeries Navigator using SSL (Port 992), the port should be automatically changed on the PC5250 emulation session to the iSeries Navigator defined port rather than having the user enter the configuration for that emulation session and change the port manually, since by default it is always port 23. RESOLUTION: If the host port number is defaulted (i.e. no port specified in .ws file), and if SSL Security is enabled, then the user can specify a port number to be used by doing the following: 1) Edit the services file in the Windows System drivers directory. For example, edit: C:\WINDOWS\system32\drivers\etc\services 2) At the end of this services file, add a new service name and port. The text line should be: telnet-ssl-pcomm 992/tcp 3) Save the services file 4) Start Pc5250 again via Display Emulator in iSeries Navigator Pc5250 will now look up the port number 992 in the services file, and connect using that port over SSL. APAR SE25222: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window size In V5R3,PC5250 when the Poppad (Pop-up Keypad) size is decreased below a certain width/height, the horizontal and vertical scroll bars are displayed while the button size inside the poppad remains constant. As a result, the number of visible buttons decreases as the size of the poppad window is decreased. When there is a lot of buttons mapped to macros, scroll bars are used to browse and display all the buttons, making it more difficult for the user to find the button needed. RESOLUTION: The PC5250 macro poppad needs to have all of the buttons visible at all times without scroll bars on the window. In V5R2 PC5250, all buttons are resized so they fit into the poppad. For V5R3 and V5R4 to operate without scrollbars on the poppad, add the following keyword to the workstation file (.ws) under the [Poppad] section: ShowScrollBars=FALSE The default value for ShowScrollBars is TRUE, which will show scrollbars on the poppad. APAR SE25223: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window focus On V5R2,PC5250 the user would work on the active principal window (focused) having the macro poppad window posted in a permanent way but out of focus. The user would select a macro from the poppad while the principal window would remain active (focused), this way the user could keep on working on the principal window. With V5R3 PC5250, when the user clicks on a macro inside the poppad window, the principal window would lose the focus and then pass it on to the poppad, thus the user has to click on the principal window to make it active again. In other words, on V5R2 PC5250, the poppad window never became active unless the user clicked inside it on a zone that is not a macro button. RESOLUTION: The PC5250 macro poppad window will stay focused by default, when a user clicks on a macro within a poppad window. For V5R3 and V5R4 to operate similar to V5R2 where the principal window retains focus even when the user clicks on a macro within the poppad window, add the following keyword to the workstation file (.ws) under the [Poppad] section: Focus2PS=TRUE The default value for Focus2PS is FALSE, which will bring the focus to the poppad window when the user clicks on a macro within the poppad. APAR SE25224: CA400EXP-TERMEMUL-INCORROUT Collect and Print PC5250 jobs The printing options do not have a feature to send all print jobs to a single file for storage/distribution or printing. RESOLUTION: To enable PC5250 to collect print jobs and merge them on a single file, three new functions will be added: 1. Switching to Collect Mode. All host print jobs will be saved in a file instead of sent to physical printer. 2. Printing all the collected jobs. All host print jobs saved in the file will be sent to physical printer. 3. Purge collected jobs. The file containing all the print jobs will be deleted. The user can create keyboard shortcuts for these functions using the keyboard re-map utility and also add them as an item in the Toolbar. By default the Collect mode will create the .scs file in the user profile directory by the convention MACHINE NAME_USER_TIME_WS THREADID_DATE_TIME.SCS. -- If the user wants to change the file name, he can use the keyword:SCSFile=.scs in the [printers] section of the ws profile of the printer session. -- If the user wants to change the directory, he can use the keyword:SCSPath= in the [printers] section of the ws profile of the printer session. -- Also there will be an option of printing all the jobs as individual jobs. i.e., if user wishes to, save all the host sent jobs, send them to physical printer without combining all as a single job, but as separate jobs with the advantage of user going to the physical printer only once for collecting printouts. This will be enabled using a .WS keyword "CombineJobs=N" under the [printers] section. This enhancement is available for English National Language Versions (NLVs) only. This includes: -- English (2924) -- English Uppercase DBCS (2938) -- English Mixed Case DBCS (2984) In addition, to enable this function fully, pcsmgres.dll must be downloaded from this site: For V5R3: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r3m0/files/pc5250/standard/se25224 For V5R4: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r3m0/files/pc5250/standard/se25224 The above addresses should all be on one line for your browser URL. Please consult the readme located in the FTP directory for install instructions. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE24807: CA400EXP-OPCON-INCORROUT File access failure causes fault APAR SE24809: CA400EXP-OPCON-INCORROUT Control Panel close may fault APAR SE25097: CA400EXP-OPCON-INCORROUT Device id out of sync APAR SE25176: CA400EXP-OPCON-INCORROUT gui hang during close APAR SE25177: CA400EXP-OPCON-INCORROUT cwbopcon.exe ends 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 = SI21917 Build date = January 2006 --------------------------------- REQUIRED PROGRAMS ----------------- 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 APAR SE23024: CA400EXP-ODBC-INCORROUT UTF8 to ME Linux PWS0006 OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE21464: CA400EXP- Scheduled LPAR resource moves showing wrong data APAR SE21740: CA400EXP-OPNAV-DBASE-INCORROUT GENERATE SQL MISSING BLANKS APAR SE22073: CA400EXP-OPNAV-INCORROUT CHANGE GRAPH INTERVAL MAKES CRASH APAR SE22346: CA400EXP-OPNAV-DBASE-INCORROUT NULL DEFAULT FOR COLUMN APAR SE22370: CA400EXP-OPNAV-INCORROUT SYSVAL International page fails APAR SE22447: CA400EXP-OPNAV-DBASE-INCORROUT INFO IN ROW ACCESS PER MON APAR SE22581: CA400EXP-OPNAV-NETWORK-INCORROUT Directory Server properties fails using IPV6 loopback address APAR SE22711: CA400EXP-OPNAV-MSGCPF2422 Wrong reply with message monitor APAR SE22927: CA400EXP-OUTPUT-INCORROUT Precache causes cwbundbs.exe hang APAR SE23219: CA400EXP-OPNAV-NETWORK UCW support for ECC connectivity This fix corresponds with V5R3 iSeries PTF SI19413 to provide support for ECC connectivity on the iSeries. APAR SE23234: CA400EXP-OPNAV-INCORROUT iSeries Navigator hangs when started from a shortcut APAR SE23347: TCPIP-MSGCPF3CF1 CREATING THE PPP PROFILE FAILS WITH CPF3CF1 APAR SE23499: CA400EXP-OPNAV-DBASE-MSGSQL0443-MSGCPF3224 INDEX ANALYZER APAR SE23525: CA400EXP-OPNAV DDM SERVER PROPERTIES ON JAPANESE DBCS APAR SE23564: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY APAR SE23386: CA400EXP-OPNAV-NETWORK Missing Virtual Ethernet Ifc Support APAR SE23601: CA400EXP-OPNAV-DBASE-PERFM RSS NO BLOCKS RECS ON CALL PARAMS APAR SE23677: CA400EXP-OPNAV-INCORROUT LIST VIEW SORTING DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE22760: CA400EXP-DTRANSFER - Vertical aligment incorrect for HTML APAR SE23381: CA400EXP-DTRANSFER-INCORROUT DATA TRANSFER TO PRINTER APAR SE23668: CA400EXP-DTRANSFER Customized sheet names for Excel files User's application requires Microsoft Excel sheet names to be sheet1, sheet2, etc. but iSeries Access uses the file name as sheet names. This PTF fixes the reported problem. Considerations: - By activating this feature it's possible to customize the name of the sheets of Excel files generated through the Data Transfer From GUI ONLY. - This feature is available ONLY for biff5, biff7 and biff8 formats. - Customized names can ONLY be ANSI strings. UNICODE strings are NOT SUPPORTED. Instructions: This feature is activated through an INI file (plain text) named CWBTFR.INI. It must reside in the Windows directory (which may be c:\windows, c:\winnt, etc., depending on how and what version of Windows is installed) and it must contain a section like this: [Client Access Data Transfer] BaseSheetName=custname where custname can be any string of up to 10 VALID CHARACTERS. Create the file if it doesn't exist or just add the above section if it already exists. NOTE.- Characters such as \,/,?,[,] or * are not allowed. This is an Excel restriction. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE23267: CA400EXP-DTRANSFER-WAIT DATA TRANSFER EXCEL ADD-IN HANGS ODBC ---- 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 possible change the application to convert from SQL_C_FLOAT to SQL_DECIMAL APAR SE22732: CA400EXP-ODBC-PERFM RESULTS SETS ARE RETURNED WITH BLOCKING Currently, when using a Sensitive cursor type in an iSeries Access ODBC application, results sets will be returned with blocking of one row. This can negatively impact performance. This change will allow the iSeries Access ODBC provider to do block fetches of data when the attribute SQL_ATTR_CONCURRENCY is set to SQL_CONCUR_LOCK and the Database host server indicates that the cursor is Read-only. APAR SE23227: CA400EXP-ODBC-INCORROUT POUND STERLING SYMBOL IN ODBC DS OLE DB PROVIDER --------------- APAR SE21950: CA400EXP-OLEDB-INCORROUT SETTING PROPERTIES WITH SQL SERVER .NET DATA PROVIDER ------------------ APAR SE22266: CA400EXP-IDB2DATA Item has already been added to collection APAR SE22506: CA400EXP-IDB2DATA .NET Provider with .NET Framework 2.0 APAR SE23880: CA400EXP-IDB2DATA-MSGCPD0005 Trace - wrong decimal separator APAR SE24056: CA400EXP-IDB2DATA Server trace fails with system naming LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.0 and the equivalent of 5722JC1 SI21370. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.7 Level 20051212 APAR SE23207: CA400EXP-TERMEMUL-INCORROUT SPECIFIC CHARACTERS GET GARBAGE APAR SE23367: CA400EXP-TERMEMUL-UNPRED LONG NAME MACRO IN .PMP APAR SE23503: CA400EXP-TERMEMUL-INCORROUT DBCS PASTE ADDS SBCS BLANK PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. 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 = SI20055 Build date = September 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE20480: CA400EXP - XDA Windows and Linux client compatibility enhancements APAR SE20695: CA400EXP-OPNAV SSO SIGNON TO ADMINISTRATION SYSTEM REQUIRED In a SSO/EIM environment user is required to supply password when Application Administration scans the Central Settings. Application Administration was changed to not prompt for password when using SSO/EIM. However, the currently signed on user must match the Current administration user as configured on the Application System tab of iSeries Access for Windows Properties. APAR SE21177: CA400EXP-INCORROUT cwbback.exe faults on some PCs APAR SE21440: CA400EXP-ODBC-INCORROUT INSERT OR UPDATE FROM PC UNICODE TO APAR SE21823: CA400EXP-INSTALL-INCORROUT AFP VIEWER ON 64BIT OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE19803: CA400EXP-OPNAV-DBASE-INCORROUT EXPLAINING QUERIES IN SCRIPT APAR SE20794: CA400EXP-OPNAV-DBASE-MSG3014 STATEMENT NOT EXPLAINABLE APAR SE20813: CA400EXP-OPNAV-DBASE-MSGSQL0205 INCORRECT COLUMN ALTERED APAR SE20816: CA400EXP-OPNAV-DBASE-INCORROUT NEW TRIGGER ALWREPCHG VALUE APAR SE21090: CA400EXP-OPNAV ISERIES NAVIGATOR FAILS WITH "CWBUNNAV.EXE HA APAR SE21111: CA400EXP-OPNAV-DBASE REORGANIZE STRING INDEX OUT OF RANGE 42 APAR SE21112: CA400EXP-OPNAV-DBASE IDENTITY COLUMN VALUES TO CACHE IS 20 APAR SE21323: CA400EXP-OPNAV-NETWORK Radius Authentication Failure APAR SE21609: OSP CUSTOMER IS AT V530 AND SERVICE PACK LEVEL SI18398. APAR SE21739: CA400EXP-OPNAV-DBASE RETURN FOCUS TO RSS AFTER CLOSING VE APAR SE21752: CA400EXP-OPNAV-NETWORK RAS connections don't display APAR SE21857: CA400EXP fix autostart flag for telnet and ftp servers DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE20765: CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD OF MS EXCEL APAR SE21329: CA400EXP-DTRANSFER-INCORROUT WARNING MESSAGES STOP RFROMPCB APAR SE21880: CA400EXP-DTRANSFER-INCORROUT SENDS MULTIPLE SHEETS APAR SE22045: CA400EXP-DTRANSFER INCORRECT TRANSLATE FROM VALUE DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE21228: CA400EXP-DTRANSFER-WAIT MS EXCEL TRANSFER FROM HANGS ODBC ---- APAR SE20631: CA400EXP-ODBC-INCORROUT BLOCK UPDATE FAILS WITH NO MESSAGE APAR SE20801: CA400EXP-ODBC-INCORROUT SPORADIC CONVERSION ERROR 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 APAR SE21505: CA400EXP-ODBC-MSGSQL0100 PRE-FETCH OF DATA APAR SE21580: CA400EXP-ODBC-MSG7399 DISTRIBUTED TRANSACTION FAILS WITH ERR APAR SE21773: CA400EXP-ODBC-WAIT A CALL TO A PROCEDURE CONTAINING BLOB OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE20843: CA400EXP-IDB2DATA DataAdapter with LOB locators fail 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 LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE20279: OSP-PAR PRINTER SESSION, FILE, PAGE SETUP, FORMS SETTING APAR SE20629: CA400EXP-PRINTEMUL-MSGCPF5261 ERROR PRINTING WITH RHM WITHIN APAR SE20734: CA400EXP-PC5250 KANA MODE INPUT INCORROUT ON CP1399 SESSION. APAR SE20890: CA400EXP-TERMEMUL-INCORROUT FUNCTION KEY NOT ALLOWED WHEN US 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 SE21630: CA400EXP-PRINTEMUL-INCORROUT STARTING PRINTER EMULATION VIA APAR SE21646: CA400EXP-TERMEMUL-INCORROUT POPUP MENU BAR OPERATION PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE21607: CA400EXP-OPCON-INCORROUT OpNav service functions unavailable 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 = SI18651 Build date = June 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE18981: CA400EXP-PC5250-INCORROUT INCOMPATIBILITY WITH PCOMM COMBO APAR SE19493: CA400EXP-INCORROUT CWBDB APIs not using extended formats The customer's application uses the cwbDB APIs. If a general server warning (return code 6407) occurs when cwbDB_StartServer is called, the cwbDB APIs fail to set the "use extended formats" in the initial server attributes. This results in errors or incorrect behavior when executing statements that require the extended formats. Errors could include incorrect handling of LOB data, incorrect handling of the ROWID data type, and incorrect handling of any other type of data that requires the extended formats. CIRCUMVENTION: Examine the host server job (QZDASOINIT) joblog for warnings and errors that occur when your connection is opened. Take action to ensure the warnings or errors are resolved and no longer occur. APAR SE19733: CA400EXP-APIS Some cwbx (ActiveX) API names changed case In V5R3, some iSeries Access for Windows ActiveX symbol (property, method, and parameter) names changed case. For example, instead of program.LibraryName (as in the V5R2 client), cwbx.dll now exports program.libraryName. This causes problems when using case-sensitive programming languages. This problem occurred because of a side-effect of the Microsoft MIDL compiler. This PTF fixes the reported problem by working around the side-effect. However, this fix may cause applications written to work specifically with V5R3 iSeries Access for Windows to fail if they use the symbols whose names have been restored to their previous case. Such applications will need to be changed to use the updated case for these symbols. Once the fixed names are used, the application should work with both V5R3 iSeries Access for Windows and with earlier supported versions. The symbols whose names have changed are as follows: Name of symbol: - in V5R2 : Type - in V5R3, before this PTF : type - in V5R3, with this PTF : Type Name of symbol: - in V5R2 : pcFile - in V5R3, before this PTF : PCFile - in V5R3, with this PTF : pcFile Name of symbol: - in V5R2 : fileDescriptionFile - in V5R3, before this PTF : FileDescriptionFile - in V5R3, with this PTF : fileDescriptionFile Name of symbol: - in V5R2 : LibraryName - in V5R3, before this PTF : libraryName - in V5R3, with this PTF : LibraryName APAR SE19809: CA400EXP-INSTALL-INCORROUT SELECTIVE FROM PREVIOUS SP LEVEL APAR SE19880: CA400EXP-ODBC-INCORROUT - MTS FAILURE IN ODBC/OLE DB ON XA_START APAR SE20136: CA400EXP-DTRANSFER-INCORROUT UTF8 PADDING TOO MUCH APAR SE20196: CA400EXP-SERVICE-INCORROUT ADD REMOVE SERVICE PACK ICON APAR SE20324: CA400EXP - Enhance XDA header file with 64-bit BLOB support OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE19783: CA400EXP-INRMTCMD IRC shutdown vulnerability iSeries NAVIGATOR ----------------- APAR SE19153: CA400EXP-OPNAV USER IS NOT ALLOWED TO ADD CONNECTIONS TO ENVIRONMENT APAR SE19538: CA400EXP-OPNAV-NETWORK DHCP Deletes config file APAR SE19550: CA400EXP-OPNAV-NETWORK-INCORROUT Rules editor fix for NLS APAR SE19732: CA400EXP-OPNAV-DBASE-MSGSQL0204 CALLING EXTERNAL PROGRAM APAR SE19801: CA400EXP-OPNAV-OUTPUT DATA NOT VALID IN 'USERS:' ERROR APAR SE19802: CA400EXP-OPNAV-DBASE DISABLE SUSPEND FOR EXISTING REORGANIZE APAR SE19804: CA400EXP-OPNAV-DBASE TRAVERSE PREVIOUS EXPLAINABLE STATEMENTS APAR SE20003: CA400EXP-OPNAV-INCORROUT MONITOR LOSES TIME SLICE ON RESTART APAR SE20034: CA400EXP start checkbox in Director Server does not work APAR SE20035: CA400EXP-OPNAV-JOBS Refresh loses customization APAR SE20231: CA400EXP- Parity problems in Service Tools APAR SE20248: CA400EXP- Unable to perform exclude using service tools gui APAR SE20276: CA400EXP Description is wrong for Sign On server APAR SE20396: CA400EXP-OPNAV-NETWORK-INCORROUT DNS NOT SAVING TIME UNITS APAR SE20600: CA400EXP-OPNAV-INCORROUT EIM WIzard fails joining a domain with authentication problem APAR SE20674: CA400EXP-COMM ISERIES NAV CRASHES WHEN SCROLLING DOWN TO VIEW APAR SE20678: CA400EXP-OPNAV MGTC CONNECTION DELAY OR FAILURE APAR SE20685: CA400EXP-CUSTCONTROLS-INCORROUT CONTEXT MENU HANDLERS DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE19537: CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD WITH NO CONVERSION APAR SE19586: CA400EXP-DTRANSFER FILE IN USE MSG NOT DISPLAYED APAR SE19590: CA400EXP-DTRANSFER-UNPRED WARNING BEHAVIOR APAR SE19604: CA400EXP-DTRANSFER-MSGCWBDB0014 VIA ACTIVEX INTERFACE useConnectedSystemObject was not being enabled correctly in the Data Transfer layer. This caused previously working applications coded to the cwbDB APIs to start failing with CWBDB0014. APAR SE19746: CA400EXP-DTRANSFER-MSGCWBDB0014 INITIAL LIBRARY LIST *NONE APAR SE19774: CA400EXP-DTRANSFER INCORRECT DATA INSERTED INTO FILE iSeries Access for Windows Data Transfer is incorrectly setting the NULL indicator for open columns on the EXECUTE request. The data transfer program sends data to the iSeries, as seen in the CWBCOTRC, but since the null indicator is enabled for the column the data is ignored by DB. No error message is issued since DB has no way of knowing anything is wrong with the request. APAR SE19871: CA400EXP-DTRANSFER CRFF not treated as EOL With iSeries Access for Windows V5R1 original media level, user data could contain both 0x0D0A and 0x0D0C as EOL markers and they would be treated as such. When the first service pack for V5R1 was installed, 0x0D0C was no longer accepted as an EOL marker and was instead treated as data and sent to the host. The change that was made to not accept EOL markers other than 0x0D0A was deemed correct, and matched the industry standard. Unfortunately it broke some customer applications. A circumvention would be to modify existing data and replace the 0x0D0C with 0x0D0A. But given the amout of data that would need to be changed in this particular case, it was not feasible. Instead a flag has been added to the CWBTFR.INI file to allow 0x0D0C to also be allowed as an EOL marker. In order to activate this fix, the CWBTFR.INI file must be create/modified to include the following lines [Client Access Data Transfer] AlternateEOL=1 If the CWBTFR.INI file already exists on the PC, then only the second line needs to be added. The location of the CWBTFR.INI file, by default, would be in C:\WINNT on WinNT and Win2000, and in C:\WINDOWS on WinXP. This fix only applies to files of type "ASCII Text" as defined in the Data Transfer to iSeries GUI. APAR SE19882: CA400EXP-DTRANSFER WARNINGS NOT SUPRESSED IN EXCEL APAR SE19885: CA400EXP-DTRANSFER EXCEL SCAN DEFAULTS TO UNICODE Prior to V5R3 iSeries Access for Windows, when the Excel Add-in scanned the excel spreadsheet, the field types would default to CHAR for character data. With V5R3, they default to UNICODE (GRAPHIC). Some applications on the host can not handle GRAPHIC data, so the user has to manually change the field types on the PC prior to the transfer beginning. This can be rather labor intensive for spreadsheets with mulitple columns. A new .exe file is being supplied along with internal code changes. To activate this fix, invoke cwbtfdft.exe. This file will reside, by default, in C:\Program Files\ IBM\Client Access. Specify cwbtfdft /? for a list of options. This fix only applies to the Excel add-in. APAR SE19921: CA400EXP-DTRANSFER CWBTF0012 FOR PROTECTED WORKSHEET APAR SE20069: CA400EXP-DTRANSFER EXCEL NUMERIC TO CHAR User has an iSeries file containing a CHAR(10) field. The field contains a value of 1234567890. User downloads the data to an Excel (biff8) file. User opens the file with Excel and changes the cell format from General to Numeric. User then uploads the file to the iSeries specifying the "Allow numeric data in character columns to be converted to character data". The resulting data on this host is 1.23457E+0. The data is in scientific notation with the last 2 bytes truncated. This is working as designed, but the conversion makes the data unusable in this scenario. When Data Transfer asks Excel for the contents of a cell whose format is Number, Excel returns it as a double. For 1234567890, Excel would return 1234567890.0000. Data Transfer then calls a Windows API to format the double as a character, and the result is 1.23457E+009. Since the host field is only defined as CHAR(10), the last 2 bytes are truncated. Even if the host field was defined as CHAR(12), the scientific notation would still be used, based on the format specification we use. The format specification chosen was done so based on customer input. Unfortunately, it does not work for all customers. This PTF will allow the user to specify a format specification for formatting Excel Numbers (which Excel stores as Doubles) when used in conjunction with the "Allow numeric data in character columns to be converted to character data" option of iSeries Access for Windows Data Transfer to iSeries. Details on format specification strings can be found at http://msdn.microsoft.com/library/default.asp?url=/library/en-us /vccore98/HTML/_crt_format_specification_fields_.2d_.printf_and_wprintf_functions To activate the PTF, creation/modification of cwbtfr.ini is required. This file is located in c:\winnt on WinNT and Win2000 and c:\windows on WinXP. If the file does not exist on the PC, create the file and add the following lines: [Client Access Data Transfer] ExcelNumericFormatter=%.10G If it does exist, merge in the following line ExcelNumericFormatter=%.10G In this example, the field on the host is defined as a CHAR(10) and the numbers in Excel range up to 10 digits (i.e. 1234567890). Without this format specification, the numbers are converted to scientific notaion with possible rounding and truncation. With this format specification, the numbers are converted to the form 1234567890. The format specification must be in the form of %[flags] [width] [.precision] [{h | l | I64 | L}]type as defined at the URL supplied above. Maximum length is 20 characters. Only 1 format specification is allowed. If the Excel spreadsheet has a combination of different numerical value formats (i.e 123456, 1234.56, 123456.1234), an ideal format specification may not be possible. A tool, cwbtftstfmt.exe, is included and can be used to test different format specifications. All instances of Data Transfer and Excel must be ended and then restarted for modifications to cwbtfr.ini to take affect. APAR SE20247: CA400EXP-DTRANSFER-UNPRED SETTING DEFAULT USERID IN DATA APAR SE20257: CA400EXP-DTRANSFER DESCRIPTION NOT DISPLAYED FOR DETAILS APAR SE20527: CA400EXP-DTRANSFER UNICODE DATA WITH X'1A' IN THE DATA DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE19889: CA400EXP-ODBC-INCORROUT - END DISTRIBUTED TRANSACTION FAILURE When ending a distributed transaction through ODBC, a call to SQLSetConnectAttr is made for the SQL_ATTR_ENLIST_IN_DTC option. The parameter passed in on the call is a NULL transaction ID. The distributed transaction coordinator normally calls xa_end before asking for the unenlist to happen. However, in some cases it does not. The driver should do an xa_end before moving out of distributed transaction mode on that connection. The current behavior results in a "SQL0428 - SQL statement cannot be run" error being reported. APAR SE20073: CA400EXP-ODBC - ODBC REPORTING OF UTF8 FIELDS On V5R3 iSeries, there is a UTF-8 Unicode CCSID that can be applied to character data types. If someone creates a table with a CHAR(10) CCSID 1208, the ODBC driver currently does the following: - If the SQLColumns API is called, the string "CHAR() CCSID 1208" is returned for the data type string. - If the SQLGetTypeInfo API is called, "CHAR() CCSID 1208" is being reported as a valid data type for SQL_CHAR. Due to the way the driver is behaving, tools like SQL Server end up creating tables with UTF-8 fields. Since that is different behavior than in past ODBC drivers, a change is required. There are two changes being made to handle this problem: 1) The ODBC driver will not return additional rows through SQLGetTypeInfo for the UTF-8 fields. 2) The ODBC driver will now externalize a REPORTTYPES keyword. ReportDataTypes also can be used. This keyword affects how the catalog APIs (like SQLColumns, SQLProcedureColumns, ...) report data types. This option has the following values: 1 = Report all CHAR fields the same way regardless of the CCSID (Default) 2 = Report UTF-8 fields differently than other CHAR fields Note: CCSID 65535 is one exception for both cases. Character fields tagged with CCSID 65535 are reported differently depending on the setting of the "Convert binary data (CCSID 65535) to text" DSN option. APAR SE20125: CA400EXP-ODBC-INCORROUT getting SQL0302 when passing zero-length to Packed Decimal APAR SE20243: ODBC - CALL TO SQLPROCEDURES THROWS 'ACCESS VIOLATION IN MOD APAR SE20344: CA400EXP-ODBC-PERFM - REVISE CHECKING FOR DOWN CONNECTIONS In V5R3 Service Pack SI17411, a change was introduced to allow the ODBC driver to better detect connections when the SQL_ATTR_CONNECTION_DEAD connection attribute was called. Due to performance problems in an ADO.NET environment with this fix, a change is needed. The SQL_ATTR_CONNECTION_DEAD behavior will be modified to work closer to how it worked in previous Windows ODBC drivers. The ODBC driver will still periodically do a more thorough check to verify if a connection is up or down, but that will mainly be for cases where a connection has been idle for some time. APAR SE20395: CA400EXP-ODBC-INCORROUT -SQL0332 on Length function Call There is problem with the way we are handling the escape syntax for the length function. As an example that demonstrates that problem, you can run the following statement: SELECT {fn LENGTH( CAST( GX'BB88' AS VARGRAPHIC( 10000 ) ) )} AS GLEN FROM QIWS.QCUSTCDT It seems we could convert the length function a bit better and still return the length of the actual data. Right now we convert this to: LENGTH(STRIP(CAST( GX'BB88' AS VARGRAPHIC( 10000 ) ),T,' ')) And that fails of course because the literal space value will be interpreted in the job ccsid and the string is a double byte string. If we just dropped that optional literal value, the strip function will default to using a space of the appropriate type (documented in the SQL reference under the TRIM function, STRIP just says it works the same as TRIM). So if we converted this to : LENGTH(STRIP(CAST( GX'BB88' AS VARGRAPHIC( 10000 ) ),T)) It will work. OLE DB PROVIDER --------------- APAR SE19872: CA400EXP-OLEDB CANNOT DERIVE PARAMETER INFORMATION APAR SE20376: CA400EXP-OLEDB SQL0518 WHEN EXECUTE HAPPENS IN MIDDLE OF APAR SE20510: CA400EXP-OLEDB SQL0104 with updateable cursor .NET DATA PROVIDER ------------------ APAR SE19683: CA400EXP iDB2DATA Recycled kerberos connection fails APAR SE19924: CA400EXP IDB2DATA CMDBLDR FAILS W/ROWID, IDENTITY, AND VIEWS Programs using the native iSeries .NET managed provider (IBM.Data.DB2.iSeries) to update a data set using the command builder and data adapter will get an error if the table contains an identity column or rowid which specifies the GENERATED ALWAYS identifier. The update statement generated by the command builder will attempt to update the identity or rowid column which is normally a read-only column in this case, resulting in SQL0798. Another problem exists with the command builder. If the select statement does not include the schema name, then the command builder does not include the schema name when it builds commands. This can result in an SQL0204 if the select statement selects from a view whose based-on schema name is different from the view schema name. The command builder should always include the based-on schema name when it builds commands. APAR SE20479: CA400EXP-IDB2DATA Add security asserts and demands to .NET LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.8 and the equivalent of 5722JC1 SI17821 and SI18394. APAR SE19847: CA400EXP-2-UNPRED Mouse events blocked when PDML show help APAR SE20441: TOOLBOXJAVA-JT400-ACCESS-JDBC DESCRIPTOR INDEX INVALID APAR SE20442: TOOLBOXJAVA-JT400-ACCESS-JDBC ALLOW ALIAS TABLES 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE19142: CA400EXP-DTRANSFER-INCORROUT PC5250 INITIATED DATA TRANSFER APAR SE19423: CA400EXP-TERMEMUL-INCORROUT DUTCH MRI2923 STRPCCMD APAR SE19583: OSP-PAR ISERIES ACCESS FOR WINDOWS PC5250 MACROS WITH CERTAI APAR SE19884: CA400EXP-TERMEMUL-INCORROUT EHLLAPI CONNECT PRESENTATION SPA APAR SE20385: CA400EXP-TERMEMUL PRINTER DEVICE ASSOCIATION SUPPORT Provide a way to associate a printer device on the iSeries server with a Pc5250 display device session, so that all output from the display session goes to a specified printer device. With this fix, the Workstation Profile (.ws file) can be edited to specify a printer device name on a V5R3 or beyond iSeries server. In iSeries Access for Windows releases after V5R3, a configuration panel interface will be provided to specify the printer device name. In the .ws file, add a "EnablePrinterAssociation" keyword in the "Telnet5250" section. Valid values for "EnablePrinterAssociation" are: "Y" which enables the feature "N" which disables the feature (Default) In addition, add the keyword "AssociatedPrinterDeviceName" in the "Telnet5250" section. Valid values for "AssociatedPrinterDeviceName" are: Any string that follows these rules: -- No imbedded blanks -- Cannot start with a number -- Contains letters A-Z, numbers 0-9, and symbols #, @. All other symbols are not valid. If the string fails validation, printer association will be disabled. Any string of more than 10 characters will be truncated to the 10 character maximum length. If the "EnablePrinterAssociation" keyword is specified, then "AssociatedPrinterDeviceName" keyword must also be specified. When the Pc5250 display session is started, the printer association will only work if the printer device name specified is present on the iSeries server. 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. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. 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 = SI17742 Build date = March 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE18332: CA400EXP-2-UNPRED MEMORY LEAK IN CWBDATAQUEUETEXTBOX ACTIVE APAR SE18533: CA400EXP-OPNAV-INCORROUT NOT ALL COMPONENTS LISTED UNDER APAR SE18852: CA400EXP-SECURITY-MSGCWBSY1040 Cannot find Windows logon information APAR SE18899: CA400EXP-OPNAV-INCORROUT TIME MGMT UNAVAIL WITH SSL APAR SE19086: CA400EXP-OPNAV-INCORROUT ez prerequisites not passed APAR SE19141: CA400EXP-OPNAV-MSGCWBAD1003 ACCESS IS NOT RESTORED CORRECTLY OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE19438: CA400EXP-INRMTCMD-PERFM CWBRXD.EXE USES TOO MUCH CPU iSeries NAVIGATOR ----------------- APAR SE16931: CA400EXP-OPNAV-DBASE-LOOP LIST EXPLAINABLE STATEMENTS PERF APAR SE18365: CA400EXP-OPNAV-ONBACKUP MISSING WHERE PANEL ON PROPERTIES APAR SE18421: CA400EXP-CUSTCONTROLS-INCORROUT CONTEXT MENU HANDLERS APAR SE18471: CA400EXP-OPNAV-NETWORK DHCP incompatibility within versions APAR SE18661: CA400EXP-OPNAV-NETWORK UCW Rollback of IES changes in v5r1,v5r2,v5r3 APAR SE18790: CA400EXP-OPNAV-DBASE MSGSQL0444 INDEXES FAILS ON V5R2 SERVER APAR SE18804: CA400EXP-OPNAV-DBASE CHANGE COLUMN LENGTH DOES NOT WORK APAR SE18862: CA400EXP-OPNAV-NETWORK-INCORROUT IPv6 incompatibility APAR SE18977: CA400EXP-OPNAV-DBASE ALIAS DISPLAYED INCORRECTLY APAR SE19071: CA400EXP-OPNAV-INCORROUT IASP properties option not saved APAR SE19129: CA400EXP-OPNAV-DBASE GENERATE SQL DOES NOT APPEND TO PC FILE APAR SE19139: CA400EXP SNTP ok button not working inside Time Management APAR SE19140: CA400EXP-OPNAV-NETWORK-INCORROUT Poll interval not displayed APAR SE19149: CA400EXP-OPNAV-NETWORK UCW Remote Dial for Service Agent fails APAR SE19203: CA400EXP-OPNAV-NETWORK-INCORROUT DHCP denies valid address APAR SE19214: CA400EXP-OPNAV Add option to Run SQL Scripts window to allow deferring messages in the Run History pane Users of the Run SQL Scripts window in the iSeries Navigator database need the ability to defer messages from appearing in the output pane (the Run History) to improve the performance when executing large numbers of statements, and the ability to see messages immediately as statements are executed, so the user can know right away if a statement failed. The new option DEFER RUN HISTORY will be provided on the Options menu of the Run SQL Scripts window. It will be provided with English-only text, since translated text cannot be changed after a release has shipped. APAR SE19269: CA400EXP-OPNAV-DBASE-INCORROUT UPDATE STATISTICS APAR SE19369: CA400EXP-OPNAV-DBASE-INCORROUT SQL STATEMENT TRUNCATED APAR SE19420: CA400EXP DNS does not allow zone forwarders DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE18219: CA400EXP-DTRANSFER-INCORROUT RFROMPCB FAILS WITH /I SWITCH APAR SE18429: CA400EXP-DTRANSFER-MSGCWBTF0005 WHEN EXCEL FIELD CONTAINS $ APAR SE18555: CA400EXP-DTRANSFER-MSGCWBTF0009 DBCS DATA TRUNCATION APAR SE18657: CA400EXP-DTRANSFER-INCORROUT ASCII FILE PADDING ERROR APAR SE18994: CA400EXP-DTRANSFER-INCORROUT HTML DOWNLOAD INCOMPLETE APAR SE19191: CA400EXP-DTRANSFER-INCORROUT ZEROS UPLOADED INSTEAD OF MESSAGE APAR SE19249: CA400EXP-DTRANSFER-INCORROUT ADDIN SCANS CHAR FIELD AS DATE APAR SE19296: CA400EXP-DTRANSFER-INCORROUT COPY FROM DISPLAY TO EXCEL FAILS APAR SE19306: CA400EXP-DTRANSFER-INCORROUT WIZARD SETS TRANSLATION FROM ASCII APAR SE19307: CA400EXP-DTRANSFER-INCORROUT MISSING VALUE FOR HTML TEMPLATE APAR SE19416: CA400EXP-DTRANSFER-INCORROUT ISERIES LIBRARY BROWSE BEHAVIOR APAR SE19596: CA400EXP-DTRANSFER-INCORROUT UPLOAD OF ASCII FILE FAILS WITH CWBDB0052 and CWBTF0020 DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE18494: CA400EXP-ODBC-INCORROUT - Miscellaneous ODBC fixes APAR SE18606: CA400EXP-ODBC-INCORROUT - CONNECTION POOLING ISSUES APAR SE19073: CA400EXP-ODBC-MSGSQL0206 COLUMN SQL_DATE NOT IN SPECIFIED Lotus Approach is used with the iSeries Access for Windows ODBC driver to build and execute a query with a selection criteria specified on a date field. When the the SQL statement built by Approach is run it receives an error message, 'SQL0206-Column SQL_DATE not in specified tables.' The query built by Approach is invalid and this really is a defect in the Approach product. The same query used to work with the V4R5 version of the ODBC driver, though. Traces of the V4R5 client revealed that Approach never put any selection criteria on the SQL statement that was passed to the ODBC driver when using the V4R5 driver. The reason for the change in application behaviour appears to stem from the value they get from the ODBC driver when they query the driver's ability to provide conversions from one type to another. SQLGetInfo's SQL_CONVERT_TIMESTAMP option returns an incorrect value with the V4R5 driver. The newer driver is returning the correct value but that causes Approach to build an incorrect SQL statement that is overly complex: WHERE ({fn CONVERT("EBONY"."GLFILE"."GLPOSTP".GPD_ENTDAT,SQL_DATE)} = {fn CONVERT({d '2004-07-09'},SQL_DATE)}) This could have been as simple as: WHERE GPD_ENTDAT = '2004-07-09' In order to allow Lotus Approach to continue working with the latest versions of the iSeries Access ODBC driver, the ODBC driver was changed to optionally return the V4R5 values when using SQLGetInfo() with Infotype SQL_CONVERT_TIMESTAMP. To configure the ODBC driver to return this value, set the DEBUG keyword to 2048. Contact IBM Support if you need assistance setting this special flag. APAR SE19091: CA400EXP-ODBC SQLSETCONNECTATTR FAILED WITH CONNECTION POOL APAR SE19359: CA400EXP-ODBC-MSGSQL0104 USER() FUNCTION OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE18503: CA400EXP IDB2DATA INCORROUT .NET provider quotes names w/@#$ APAR SE18607: CA400EXP IDB2DATA InvalidOperationException after ExecuteScalar APAR SE18608: CA400EXP IDB2DATA Null Provider type fails on GetHashCode APAR SE18811: CA400EXP IDB2DATA MSGSQL0206 if CommandBuilder used on View APAR SE19150: CA400EXP IDB2DATA WAIT DELAY INITIALIZING NUMERIC VARIABLES APAR SE19262: CA400EXP IDB2DATA MSGIDB2COMMERROREXCEPTION - Add property to verify pooled connections on Open When iSeries server jobs get recycled (ENDPJ, ENDJOB, ENDSBS, or IPL), .NET connections receive a comm error the next time that connection is used: iDB2CommErrorException: A communication error occurred. When this happens, the normal recovery is for the application to close and then reopen the connection. In cases where ALL or MANY pooled connections are ended (for instance, during an IPL), the application could continue to get communication errors even after reopening the connection. New functionality is needed to give applications a better way to recover from this condition. This PTF gives applications a way to have the provider check pooled connections for validity before using them on a connection.Open request. To validity check pooled connections during Open, add the following to your ConnectionString: CheckConnectionOnOpen=true; This causes the provider to send a small flow to the host in order to see if the connection is still active. If the connection is no longer active, the provider reconnects to the host server before returning from the Open request. By default, the CheckConnectionOnOpen property is set to false, meaning pooled connections are not checked for validity during Open. APAR SE19266: CA400EXP IDB2DATA MSGPWS0006 Error reading CLOB and DBCLOB LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.7 (2/24/2005) and the equivalent of 5722JC1 SI17296 and SI17439. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE16441: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION PROBLEM AFTER APAR SE18210: CAEXP PC5250-BEHAVIOR OF IME IS INCORRECT WHEN CURSOR IS APAR SE18245: CA400EXP-PRINTEMUL-MSGPCSCM.EXE APPLICATION ERROR PCSCM.EXE APAR SE18385: OSP-MSGPCSERR100 PCSERR100 WITH PC5250 APAR SE18436: CA400EXP-TERMEMUL PCSBAT.EXE CAN'T RUN *.LNK FROM BCH FILE APAR SE18821: CA400EXP-TERMEMUL-INCORROUT NO SOUND ON PC AFTER UPGRADING APAR SE18841: CA400EXP-PRINTEMUL-INCORROUT GAIJI CHARACTER WRONG SIZE WITH APAR SE18842: CA400EXP-PRINTEMUL-INCORROUT DBCS DASH CHARACTER PRINTS APAR SE18848: CA400EXP-TERMEMUL HIGHER RESOLUTION DISPLAY SUPPORT PC5250 does not display its screen properly at high resolutions. PC5250 works best with lower resolutions like 1024x768. At higher resolutions, much of the emulator screen is blank and the text displayed is centered. PC5250 needs to use most of the available window space, and display the text as large as possible with good quality. 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. -- Monotype Sans Duospace WT (mtsansdw.ttf) (for displaying text) -- IBM3270APL5 (pcommapl.ttf) (for displaying APL characters like box drawing, scrollbars, etc) IBM3270 will still be the default font. The new Monotype Sans Duospace WT font (mtsansdw.ttf) will need to be selected by the user via the Select Display Font dialog. Whenever the Monotype Sans Duospace WT font is selected, PC5250 will automatically select IBM3270APL5 (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 SE19080: CA400EXP-PRINTEMUL-INCORROUT INCORRECT FONT SIZE WHEN ROTATI APAR SE19101: OSP-PAR PCSWS026 ERROR WHEN SAVING .WS PROFILES AFTER APAR SE19188: CA400EXP-TERMEMUL-INCORROUT COPY FAILS TO COPY NEW DATA TO PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE18498: CA400EXP-OPCON-INCORROUT autostart doesn't start 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 = SI16496 Build date = December 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE17422: CA400EXP-OPNAV-INCORROUT FUNCTIONS UNAVAIL WITH SSL APAR SE17423: CA400EXP-ODBC-INCORROUT LARGE VARCHAR DOESNT SHOW DBCS DATA APAR SE17688: CA400EXP IDB2DATA INCORROUT LibList added in wrong order APAR SE17943: OSP-DB ODP NOT REUSED. APAR SE17955: CA400EXP - XDA Windows client enhancements APAR SE18001: CA400EXP-TERMEMUL-INCORROUT CWBLM0040 with multiple sessions APAR SE18197: CA400EXP-TERMEMUL-INCORROUT HMC connection timeouts APAR SE18389: CA400EXP IDB2DATA PWS0043 stored procedure with parameters OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE16054: CA400EXP-OPNAV-DBASE VE SHOW RELATED OPTION MISSING APAR SE16574: CA400EXP-OPNAV CAN'T REFLECT A COLUMN HEADING VALUE IN ADD N APAR SE16800: CA400EXP-OPNAV CWBUNNAV.EXE Error on browsing long directory APAR SE17023: CA400EXP-OPNAV-INCORROUT Server browse button in New Cluster wizard fails to refresh APAR SE17085: CA400EXP-OPNAV UNIVERSAL CONNECTION WIZARD RESOURCE ERROR APAR SE17092: QPWFSERVSO job hangs around after iSeries Navigator closes APAR SE17205: CA400EXP-OPNAV-INCORROUT- CPF9810 confusing message when Licensed Option 12 is not installed APAR SE17213: CA400EXP-OPNAV-DBASE-MSGSQL0109-MSGSQL0190 ALTERING COLUMNS APAR SE17322: CA400EXP-OPNAV-NETWORK-INCORROUT ISERIES NAVIGATOR TELNET APAR SE17396: CA400EXP-OPNAV-NETWORK-INCORROUT single quotes in RMTSYS APAR SE17398: CA400EXP-OPNAV-NETWORK-INCORROUT DNS SOA serial number APAR SE17405: CA400EXP-OPNAV-NETWORK-INCORROUT SOCKS Domain name server not saved APAR SE17503: CA400EXP-OPNAV Inav Parity option fails to mark all options in Availability when "CHECK ALL" box is checked APAR SE17521: CA400EXP-OPNAV-NETWORK-INCORROUT allow to configure zone TTL APAR SE17574: CA400EXP-OPNAV-MESSAGES SQL0107 when do Analyze Results on German SQL performance monitor APAR SE17654: CA400EXP-OPNAV-DBASE-INCORROUT IDENTITY COLUMN ORDER APAR SE17709: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DOUBLE $ORIGIN STRING APAR SE17769: CA400EXP-OPNAV-OUTPUT-MSG INVALID DATA INCLUDE CRITERIA APAR SE17793: CA400EXP-OPNAV INCORROUT Gui Graphics fails to show all dasd APAR SE17794: CA400EXP-OPNAV-NETWORK-INCORROUT CHILD ZONE CREATION APAR SE17854: CA400EXP-OPNAV Cannot change order of nodes in recovery domain of a CRG APAR SE17869: CA400EXP-OPNAV-NETWORK-INCORROUT Dbg Server not started APAR SE17880: CA400EXP-OPNAV-INCORROUT Standard Service Port set incorrectly for Java APAR SE17883: CA400EXP-OPNAV INCORROUT Images missing on Properties APAR SE17996: CA400EXP-OPNAV-DBASE INDEXES SUPPORT ON V5R2 APAR SE18006: CA400EXP-OPNAV-DBASE-INCORROUT TEMPORARY INDEXES APAR SE18049: CA400EXP-OPNAV-MSGCPF3342 DRAG AND DROP OF SPOOLED FILE APAR SE18070: CA400EXP-OPNAV-DBASE TABLE NAME LOST WHEN CREATING ALIAS APAR SE18109: CA400EXP-OPNAV-NETWORK UCW update to state list use APAR SE18110: CA400EXP-OPNAV-DBASE MULTIPLE INDEXES ADVISED PER TABLE APAR SE18216: CA400EXP-OPNAV-INCORROUT SSL Icon not displayed correctly. APAR SE18247: CA400EXP-OPNAV-NETWORK-INCORROUT iNav hangs, SMTP properties APAR SE18254: CA400EXP-OPNAV-INCORROUT Function Availability prompting incorrect name DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE16662: CA400EXP-DTRANSFER-INCORROUT EXCEL WITH MULTIPLE SHEETS FAILS APAR SE16753: CA400EXP-DTRANSFER-MSGCWBDB0014 WHEN DOING A DATA TRANSFER APAR SE17556: CA400EXP-DTRANSFER-MSGSQL5016 CONTAINING DOT IN FILE NAME APAR SE17875: CA400EXP-DTRANSFER-INCORROUT EXCEL EMPTY CELLS AS UNICODE DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE17733: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS APAR SE18215: CA400EXP-ODBC-UNPRED - VARIABLE LENGTH COMPRESSION ENHANCEMENT The driver's fetching of data from variable-length fields (VARCHAR, VARBINARY, VARGRAPHIC,... ) can be inefficient in some cases. An enhancement is being provided that will help with performance when using forward-only cursors. To take advantage of this enhancement, the application must be using the 'Block if fetch of 1 row' DSN option (or the BLOCKFETCH=1 keyword). That setting is enabled by default. Note, to get this enhancement to work a V5R3 iSeries server and some additional server PTFs are required. As the server PTFs become available they will be documented at: http://www-1.ibm.com/servers/eserver/iseries/access/servernotes.html APAR SE18251: CA400EXP-ODBC - IIS HANG DUE TO CLOSE CURSOR OLE DB PROVIDER --------------- APAR SE17223: CA400EXP-OLEDB-MSGCWBZZ5014 CWBZZ5014 WHEN USING IBMDA400 .NET DATA PROVIDER ------------------ APAR SE17385: CA400EXP IDB2DATA Incorrect result data on 2nd call to Execute APAR SE17432: CA400EXP IDB2DATA MSGSQL0519 after failed Execute APAR SE17639: CA400EXP IDB2DATA MSGSQL0518 Select statement parsed as a stored procedure APAR SE17960: CA400EXP IDB2DATA INCORROUT FAILURE W/RESTRICTED PERMISSIONS LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.6 (10/29/2004) and the equivalent of 5722JC1 SI16227. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE15390: CA400EXP-PRINTEMUL-INCORROUT PC5250 BESTFIT OPTION CANNOT BE APAR SE15842: CA400EXP-TERMEMUL-INCORROUT PC5250 CROSSHAIR FLICKER APAR SE15974: CA400EXP-TERMEMUL-INCORROUT MACRO RECORDING CAUSES INSTRUCTI APAR SE16377: CA400EXP-TERMEMUL-INCORROUT PCSWS ERROR ON WIN2003 PC APAR SE16461: CA400EXP-TERMEMUL-INCORROUT WS FILE STORED ON NETWORK DRIVE APAR SE16941: CA400EXP-TERMEMUL-MSGPCSWS PLAYBACK OF A MACRO CAUSES PCSWS APAR SE17146: CA400EXP-PRINTEMUL-INCORROUT INCORRECT OUTPUT WHEN USING APAR SE17386: CA400EXP-TERMEMUL-INCORROUT PC5250 DISPLAY MOSTLY BLANK FIEL APAR SE17656: CA400EXP-TERMEMUL-INCORROUT BATCH FILE PROCESSING APAR SE17658: OSP CAEXP-DSP-INCORROUT SHAPE OF YEN: AND DOLLAR:$. APAR SE17835: OSP-PAR PCSWS026 ERROR WHEN SAVING .WS FILES AFTER LOADING APAR SE17843: CA400EXP-TERMEMUL-INCORROUT HACL AUTOMATION OBJECT EVENTS NO APAR SE17965: CA400EXP-TERMEMUL-INCORROUT PC5250 PUSH BUTTON NOT RETURNING APAR SE18068: CA400EXP-TERMEMUL-WAIT EXIT HANGS WITH READ-ONLY .WS PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE17216: CA400EXP-OPCON-INCORROUT some signon failures not displayed APAR SE18139: CA400EXP-OPCON-INCORROUT RCP listed as not authorized APAR SE18189: CA400EXP-OPCON-MSG Virtual Control panel CWBOPAOC.EXE fault APAR SE18351: CA400EXP-OPCON-INCORROUT AFTER RCS TO LCS CONNECTION FAILURE 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 = SI15176 Build date = September 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE15339: CA400EXP-DTRANSFER-MSGCWBDB0052 DATA TFR DOWNLOAD TO HTML APAR SE16157: CA400EXP-SSL-INCORROUT MANDATING SSL FAILS 5250, VERIFY APAR SE16446: CA400EXP-OPNAV-INCORROUT DISCOVERY OF ADMINISTRATION SYSTEM PROBLEM APAR SE16477: CA400EXP-OPCON-INCORROUT LAN CONSOLE NOT CONNECTING ANYMORE APAR SE16866: CA400EXP-OPNAV-MESSAGES-INCORROUT MULTIPLE SEND MESSAGE ITEMS APAR SE16920: CA400EXP - Multiple Platform XDA APAR SE17036: CA400EXP-2-MSGCWB4028 RMTCMD REJECTS RESTRICTED USERS The RMTCMD program in the V5R3 iSeries Access for Windows client behaves differently than previous versions did. If the user has limit capabilities set to *YES on their user profile, RMTCMD is now rejecting attempts to run commands with a message CWB4028. It makes no difference if the command is allowed by restricted users or not, it is rejecting all commands with this message. The change was made to the client without any notification in the Memo To Users for V5R3 and is causing existing customer programs to fail and if this function does not revert back to the old behavior, those programs will need to be rewritten. The RMTCMD program will be changed back to it's previous behavior of allowing iSeries profiles with limited capabilities to execute commands. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE14716: LIC OPS NAV WAIT CONDITION APAR SE15235: OSP-DB TIME LABEL INCORRECT ON TOTAL RUNTIME LABEL IN INAV APAR SE15469: CA400EXP-OPNAV-INCORROUT Sys Monitor crash when edit values APAR SE15492: CA400EXP-OPNAV-DBASE-INCORROUT Canceling insert of a row into table causes following row to be deleted APAR SE15899: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DELETE HOST DYNAMIC APAR SE15911: CA400EXP-OPNAV-DBASE-INCORROUT SORT EXPLAINABLE STMTS LIST APAR SE15929: CA400EXP-OPNAV-NETWORK-INCORROUT DNS needs to validate subnet field APAR SE15947: CA400EXP-OPNAV-DBASE-WAIT Run SQL Scripts Save changes dialog does not appear APAR SE15975: CA400EXP-OPNAV INCORROUT create of new ASP fails to display 2105 type ESS LUNS APAR SE15985: CA400EXP-OPNAV-DBASE-UNPRED CLICKING JOURNALING CAUSES ABEND APAR SE16000: CA400EXP-OPNAV-WAIT Two TaskActionEvents for a shared propertysheet causing a hang in iNav APAR SE16041: CA400EXP-OPNAV-DBASE-INCORROUT CANNOT CREATE RANGE PARTITION APAR SE16053: CA400EXP-OPNAV-DBASE VE INDEX ADVISOR COLUMNS INFO TRUNCATED APAR SE16055: CA400EXP-OPNAV-DBASE DBNAV SCHEMA IN PROPERTIES INCORRECT APAR SE16056: CA400EXP-OPNAV-DBASE F4 KEY DOES NOT LAUNCH SQL ASSIST APAR SE16075: CA400EXP-OPNAV HAT V5R3 GEO mirroring returns inappropriate message for error condition APAR SE16130: CA400EXP-OPNAV Send SNA panel hangs APAR SE16141: CA400EXP-OPNAV SQL7008 WHEN EDIT TABLE IN CHINESE APAR SE16167: OSP SI13587 CAUSED DATE/TIME FORMAT CHANGE IN OPSNAV APAR SE16458: CA400EXP-OPNAV-MSGJAVAX.SWING.JLABEL WHEN VIEWING PERMISSION APAR SE16475: CA400EXP-OPNAV-INCORROUT SMTP SERVER NAME GETS CHANGED TO APAR SE16486: CA400EXP-OPNAV-INCORROUT Preferred node status change - error for site name APAR SE16561: CA400EXP-OPNAV Inserting rows into table with default values for DATE field produces "Error in assignment" APAR SE16646: CA400EXP-OPNAV-NETWORK-INCORROUT Can't create 1GB ifc w/5700 APAR SE16647: CA400EXP-OPNAV-NETWORK-INCORROUT NAS Batch file NET USER password should not be random string APAR SE16661: CA400EXP-OPNAV-USRGRP-INCORROUT Add LCLPWDMGT parameter The Local password management (LCLPWDMGT) parameter is not available when using iSeries Navigator Users and Groups to create or change a user profile. A checkbox needs to be added to the Users and Groups Capabilities->Password tab display panel to allow IBM Integration for Windows Server users to decide if they want to "Manage this password locally". For more information regarding the changes to iSeries Navigator for managing your IBM Integration for Windows Server users go to http://www.ibm.com/servers/eserver/iseries/navigator/faqs.html#lclpwdmgt APAR SE16751: CA400EXP-OPNAV-NETWORK UCW support for backup VPN to Rochester SDC This Universal Connection Wizard update corresponds with host PTF 5722SS1 SI15166 to configure a backup VPN universal connection. This fix affects the output of the Universal Connection Wizard to support a backup service data center for downloading fixes. The wizard will create a second dial profile in the VPN scenario QTOCL2TP2. To complete creation of the second VPN connection there will be an additional VPN connection QIBMSERVICE52 and a corresponding IKE policy. The Universal Connection Manager on the iSeries will use the backup VPN connection should the primary be unavailable. APAR SE16752: CA400EXP-OPNAV-DBASE-INCORROUT CREATE ADVISED INDEX SCHEMA APAR SE16762: CA400EXP-OPNAV-INCORROUT System status field 'Shared processor pool usage' shows incorrect data APAR SE16838: CA400EXP-OPNAV-DBASE-INCORROUT COLUMN WITH NO DEFAULT APAR SE16926: CA400EXP-OPNAV CPFB957 Endpoint system not found APAR SE17022: CA400EXP-OPNAV CTL-C of spooled file Followed by Paste Fails APAR SE17045: CA400EXP-OPNAV-FILESYS-INCORROUT OSP COPY/PASTE FROM QTCPTMM IN OPS NAV PUTS FILES IN ROOT OF APAR SE17082: CA400EXP-OPNAV-MESSAGES String index out of range when execute blank statement in Run SQL Scripts DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE15149: CA400EXP-ODBC-UNPRED - ROW-WISE BINDING PROBLEM 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 APAR SE15895: CA400EXP-ODBC-MSGINTERNAL DRIVER ERROR INTERMITTENT FAULT IN APAR SE16131: CA400EXP-ODBC-UNPRED - PACKAGE PROBLEM WITH STATEMENT IN USE APAR SE16287: CA400EXP-ODBC-MSGSQL7008 AUTOCOMMIT OFF COMMIT MODE CHANGED APAR SE16834: CA400EXP-ODBC-INCORROUT INCORRECT DECIMAL PARAMETER VALUES APAR SE16919: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS OLE DB PROVIDER --------------- APAR SE15785: CA400EXP-OLEDB-INCORROUT ADO ActualSize wrong for LOBS. APAR SE15809: CA400EXP-OLEDB-MSGCPF9810 TABLE NAME LISTED AS THE LIBRARY APAR SE16302: CA400EXP-OLEDB-MSGCWBZZ5014 INSERT/UPDATE TABLE WITH LOB APAR SE16667: CA400EXP-OLEDB-INCORROUT SQLSTATE NOT SET FOR COMM ERROR .NET DATA PROVIDER ------------------ APAR SE15897: CA400EXP IDB2DATA Add iDB2ProviderSettings class A new class is needed to enable static, process-wide settings for the IBM.Data.DB2.iSeries .NET provider. The following new class will be created: Class name: iDB2ProviderSettings Description: Provides a way to set process-global provider settings. This class cannot be inherited. Property name: static string ProviderVersion (read-only) Description: Returns a string containing the IBM.Data.DB2.iSeries .NET provider's AssemblyFileVersion. Method name: static void CleanupPooledConnections() Description: Performs orderly cleanup of pooled connections. Calling this method just before your process terminates will ensure pooled iDB2Connections get cleaned up properly. Make this method the last call you make before your process terminates. This ptf adds the new iDB2ProviderSettings class. APAR SE16002: CA400EXP IDB2DATA CommandBuilder fails with WHERE clause APAR SE16003: CA400EXP IDB2DATA Exception with Decimal/Numeric result data APAR SE16036: CA400EXP IDB2DATA Fix incorrect parameter handling for Stored Procedures APAR SE16951: CA400EXP IDB2DATA Add support for LOBs and Library List Add support for LOBs and Library List to the .NET provider. The following new data types are added: iDB2Blob - represents a binary large object iDB2Clob - represents a character large object iDB2DbClob - represents a double byte character large object A new iDB2NamingConvention enum is created that allows the application to select SQL naming or System naming. The iDB2Connection class has the following new properties: Naming - to control the naming convention (SQL or System). Value is specified as either SQL or System. MaximumInlineLobSize - to control the threshold at which LOB data is transferred using LOB Locators, instead of as inline data. Value is an integer in the range 0-15360 which specifies the maximum size (in kilobytes) of a LOB which can be retrieved from the host server in a single operation. LibraryList - allows the application to set the user portion of the host server job's library list. If the application wants the DefaultCollection included in the library list, it must include it in the LibraryList property. LibraryList is a comma-delimited list of library names which may contain the special name *USRLIBL, which is a placeholder to indicate the host server job's current user portion of the library list. By placing other library names before or after *USRLIBL, the application can control where the libraries get added in relation to the job's current user library list. If *USRLIBL is not specified in the LibraryList, the specified libraries will replace the server job's current user library list, so applications that wish to add to the library list should be sure to specify *USRLIBL somewhere in the LibraryList. The iDB2DataReader class has the following new methods: GetiDB2Blob(int index) GetiDB2Clob(int index) GetiDB2DbClob(int index) This ptf adds LOB and Library List support to the .NET provider. APAR SE17162: CA400EXP IDB2DATA Decimal/Numeric digits truncated LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.5 (07/30/2004) and the equivalent of 5722JC1 SI14873. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE14730: CA400EXP-TERMEMUL-INCORROUT PC5250 NEGOTIATES WRONG KBDTYPE APAR SE15297: OSP PCSERR101 ERROR WHEN A COPY/PASTE FUNCTION IS PERFORMED. APAR SE15562: CA400EXP-TERMEMUL-MSGPCSERR999 MACRO LIMITED TO 64KBYTE APAR SE15735: CA400EXP-PRINTEMUL-UNPRED PRINTER SETUP WINDOW DOES NOT DISP APAR SE15931: CA400EXP-TERMEMUL-INCORROUT AFTER RETURNING TO CALLING PGM APAR SE16801: CA400EXP-TERMEMUL-INCORROUT GERMAN FUNCTION KEY ALT K IS NOT PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE13412: CA400EXP-OPCON-INCORROUT REMOTE CONTROL PANEL FAILS APAR SE16299: CA400EXP-OPCON-INCORROUT wizard hangs in WinNT APAR SE16534: CA400EXP-OPCON-INCORROUT fault RCS to LCS and firewall APAR SE16535: CA400EXP-OPCON-INCORROUT close may hang APAR SE16821: CA400EXP-OPCON-INCORROUT emulator may not start PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- Non-APAR fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI13587 Build date = May 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 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 SE14941: CA400EXP-DTRANSFER Help not displayed APAR SE15016: SSL - Update default key database A VeriSign Global Server Intermediate Root CA certificate has expired on January 7, 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 APAR SE15507: CA400EXP-OPCON-INCORROUT CWBOPAUT.DLL ERROR APAR SE15715: CA400EXP-INCORROUT cwblmsrv background task not exiting OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE12438: CA400EXP-OPNAV-OUTPUT-INCORROUT CWBUN_GETPUBLICLISTOBJECT AP APAR SE12441: CA400EXP-OPNAV-NETWORK-MSGCPI0954 CREATE DISK TO MAX ASP USE APAR SE12774: CA400EXP-OPNAV-DBASE-INCORROUT CREATE NEW VIEW DIALOG MAY NO APAR SE12976: CA400EXP-OPNAV-DBASE-INCORROUT PROMPTING FOR PASSWORD APAR SE13504: CA400EXP-OPNAV-INCORROUT LPAR Create wizard doesn't use regional setting for shared procs APAR SE13614: CA400EXP-OPNAV-NETWORK Universal Connection Wizard modal to frame APAR SE13616: CA400EXP-OPNAV-NETWORK-INCORROUT Leased lines line profile cannot be updated APAR SE13629: CA400EXP-OPNAV-NETWORK Remote support authentication ids to allow connect APAR SE14019: CA400EXP-OPNAV-NETWORK-INCORROUT File extensions corrupted on add share APAR SE14236: CA400EXP-OPNAV ISERIES NAVIGATOR HANG LISTING PRINTER OUTPUT APAR SE14383: CA400EXP-OPNAV-NETWORK Routes not added when configuring an ATT dial connection APAR SE14408: CA400EXP-OPNAV-FILESYS-PERFM LONG DELAYS WHEN MOVING MULTIPL APAR SE14555: CA400EXP-OPNAV-NETWORK-INCORROUT DNS ENABLES ADD HOST APAR SE14558: CA400EXP-OPNAV-NETWORK-INCORROUT SMTP properties update fails APAR SE14569: CA400EXP-OPNAV-INCORROUT MC Task Status window does not always paint APAR SE14570: CA400EXP-OPNAV-NETWORK UCW Qtocl2txx line description wrong APAR SE14574: CA400EXP-OPNAV-INCORROUT Changing Max graph value on graph history takes two refreshes to take effect APAR SE14585: CA400EXP-OPNAV-NETWORK UCW phone5 call list to phone4 APAR SE14644: CA400EXP-OPNAV-NETWORK RAS PPP filter identifier list empty APAR SE14720: LIC-DISK-STG OPS NAV DISK POOLS DISPLAY PROBLEM APAR SE14734: CA400EXP-OPNAV-INCORROUT CURRENT ADMINISTRATION SYSTEM/USER CAN NOT BE REMOVED APAR SE14800: CA400EXP-OPNAV-NETWORK-INCORROUT Webfacing settings not saved APAR SE14802: CA400EXP-OPNAV-NETWORK-INCORROUT Netserver Single Signon failing due to uppercase keytab entries. APAR SE14914: CA400EXP-OPNAV-INCORROUT Capabilities->Auditing page must be hidden for non-administrators APAR SE14968: CA400EXP-OPNAV- PRINTER OUTPUT ACTION ERROR IN OUTQ SHORTCUT APAR SE14983: CA400EXP-OPNAV-NETWORK-INCORROUT QoS Configuration GUI ignores subnet mask input when creating a new Client object APAR SE15045: CA400EXP-OPNAV User registration is not working Service Agent user registration fails using iSeries Navigator. NOTE: In order for this fix works properly you need to install PTF SI13239 for the OS/400 operating system (5722SS1) or one that supersedes it in the iSeries server that is specified as Management Central system. APAR SE15048: CA400EXP-OPNAV ESA Verify connection to IBM is hung Verifying connection to IBM window is hung NOTE: In order for this fix works properly you need to install PTF SI13239 for the OS/400 operating system (5722SS1) or one that supersedes it in the iSeries server that is specified as Management Central system. APAR SE15049: CA400EXP-OPNAV ESA Subsystem jobs window APAR SE15050: CA400EXP-OPNAV ESA License not displayed for any release APAR SE15052: CA400EXP-OPNAV-AUTHLIST-INCORROUT Need to display description of Authority lists in iSeries Navigator Window APAR SE15081: CA400EXP-OPNAV-UNPRED Moving node up to be primary in Recov. Domain doesn't show entire line moving & "ineligible" node status APAR SE15105: CA400EXP-OPNAV-INCORROUT When adding a data port ip address fails, the address still shows up in the gui like it was successful APAR SE15106: CA400EXP-OPNAV-PERFM Occasional Hangs during make available APAR SE15122: CA400WINOPT-OPNAV Support new hardware for V5R3M0 on Graphical Views No graphical views for the new hardware. Graphical views added. Requires PTF 5722999 MF32576 as well. APAR SE15148: CA400EXP-OPNAV-INCORROUT Cannot Display Disk Pool Properties Of Mirrored IASP APAR SE15212: CA400EXP-OPNAV-DBASE-INCORROUT SCHEMA STARTS WITH @ # $ APAR SE15219: CA400EXP-OPNAV-OUTPUT-INCORROUT SPOOLED FILE LIST INCOMPLETE APAR SE15222: CA400EXP-OPNAV-INCORROUT Error removing user in Customize Access dialog APAR SE15282: CA400EXP-OPNAV-INCORROUT Consolidated Hardware File saved to incorrect path APAR SE15308: CA400EXP-OPNAV-INCORROUT Suspend Geographic Mirroring menu item occasionally in incorrect state APAR SE15367: CA400EXP-OPNAV-NETWORK-WAIT Directory Server Propertysheet hangs searching/updating the configuration APAR SE15388: CA400EXP-OPNAV-UNPRED APPLICATION DEVELOPMENT FOLDER MISSING APAR SE15395: CA400EXP-OPNAV-INCORROUT Adding a data port ip address failure still shows up as successful APAR SE15500: LIC-DISK-STG-UNPRED APAR SE15501: CA400EXP-OPNAV Drop down with wrong value on Edit Time Zone APAR SE15511: CA400EXP-OPNAV-INCORROUT Intelligent Agent panel hangs APAR SE15512: CA400EXP-OPNAV-NETWORK Unable to turn off LDAP filter cache support APAR SE15513: CA400EXP-OPNAV-INCORROUT Configuring a V5R2 server that is a replica to a master fails. APAR SE15514: CA400EXP-OPNAV-INCORROUT Directory Server publishing fields not enable/disabled correctly. APAR SE15526: CA400EXP-OPNAV-DBASE-WAIT CANNOT LAUNCH EXPRESSION BUILDER APAR SE15527: osp - Deleting a data port IP address fails APAR SE15528: CA400EXP-OPNAV-INCORROUT Removing a node in a recovery domain handled incorrectly APAR SE15545: CA400EXP-OPNAV Cannot Deconfigure Just A Secondary IASP APAR SE15546: CA400EXP-OPNAV-INCORROUT GUI is partially untranslated APAR SE15748: CA400EXP-OPNAV Site name & membership status incorrect in recovery domain when moving nodes DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE15025: CA400EXP-DTRANSFER - UTF-8 ALWAYS TRUNCATES SPACES APAR SE15133: CA400EXP - DTRANSFER - trap opening TTO file APAR SE15135: CA400EXP-DTRANSFER UNICODE AND UTF8 PROBLEMS APAR SE15716: CA400EXP-DTRANSFER trailing blanks cause CWBLM0040 APAR SE15767: CA400EXP-DTRANSFER THE BROWSE FILES AND MEMBERS WINDOW FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE15356: CA400EXP-DTRANSFER-INCORROUT FDF DATE/TIME SETTINGS RESET WHEN USING USING EXCEL WIZARD ODBC ---- APAR SE13347: CA400EXP-ODBC-UNPRED SQLCOLATTRIBUTES SQL_COLUMN_SEARCHABLE APAR SE14242: CA400EXP-ODBC-MSGCPF5035 OVERLAY OF PARAMETER DATA ON SECON APAR SE14415: CA400EXP-ODBC-INCORROUT - RETURN TIME, DATE, TIMESTAMP AS SQL_CHAR APAR SE14963: CA400EXP SQLEXTENDEDFETCH RETURNS PWS0001 RETURNING DATA FRO APAR SE15056: CA400EXP-ODBC-INCORROUT - OVERRIDE PASSWORD ENHANCEMENT When connecting with ODBC and your password is expired on the server, an error or a dialog asking the user to change the password is returned to the application. To avoid the error and possible dialog, an enhancement is being provided to allow an application to programmatically change the user's password. An example scenario on how this might be used is listed below: The application calls SQLDriverConnect with the SQL_DRIVER_NOPROMPT DriverCompletion option and the userid (UID keyword) and password (PWD keyword) specified in the connection string. Since the userid and password combination is expired, an error (SQL_ERROR) is returned to the application. No prompts are returned because of the SQL_DRIVER_NOPROMPT option. The application calls SQLError (or SQLGetDiagRec) to get back the NativeError. If the native error is 8003 then this is the case where the userid/password combination was expired. The application calls SQLDriverConnect with the userid (UID keyword), current password (PWD keyword), and the new password (NEWPWD keyword) specified in the connection string. The driver will change the password for that user profile to the new password if the current password is valid. APAR SE15502: CA400EXP-ODBC-INCORROUT - FIX SQLPROCEDURECOLUMNS ISSUES THAT COULD CAUSE FAULTS OLE DB PROVIDER --------------- APAR SE14470: CA400EXP-OLEDB-INCORROUT ZERO LENGTH PARAMETER DATA INCORREC APAR SE15283: CA400EXP-OLEDB-UNPRED RLA RANDOM TRACE APAR SE15503: CA400EXP-OLEDB-INCORROUT BLANK STRINGS RETURN INCORRECT DATA .NET DATA PROVIDER ------------------ APAR SE13984: CA400EXP IDB2DATA MSGSQL0501 Cursor not open error APAR SE13985: CA400EXP IDB2DATA INCORROUT iDB2CommandBuilder fails with table created using DDS APAR SE13986: CA400EXP IDB2DATA INCORROUT DeriveParameters not setting Size and IsNullable APAR SE14008: CA400EXP IDB2DATA INCORROUT DeriveParameters not setting ParameterName APAR SE15169: CA400EXP IDB2DATA .NET traces and logs sometimes do not work APAR SE15170: CA400EXP IDB2DATA Fix several problems with .NET provider A new method is added: iDB2DataReader.HasRows(). This method can be called to determine if the iDB2DataReader returned any rows. A final change is made to remove the public constructor for the iDB2ParameterCollection class. The parameter collection is always associated with an iDB2Command and should not be created by an application. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- Non-APAR fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.3 (04/02/2004) and the equivalent of 5722JC1 SI13437. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE12161: CA400EXP-TERMEMUL-INCORROUT IBM3270-1250 FONTS ARE NOT APAR SE12423: CA400EXP-TERMEMUL-INCORROUT CHARACTERS NOT CHANGED TO UPPERC APAR SE12821: CA400EXP-TERMEMUL-UNPRED PC5250 SESSION DROPPING WHEN USING APAR SE13349: CA400EXP-TERMEMUL-DBCS U/3010(EBCDIC:X/4466) CANNOT DISPLAY APAR SE13430: CA400EXP - TERMEMUL - Add support for LotusScript Extension APAR SE13431: TERMEMUL Signed Numeric won't paste to protected fields Currently if you copy and paste numeric fields they will paste into unprotected and protected fields. But if you copy and paste signed numeric fields, they will not paste into protected fields. This fix is enabled when the existing option, "Force Leading +/-", is ON. APAR SE13658: CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE ISSUE ON JAPANESE APAR SE13859: OSP-PAR RUNTIME ERROR. ABNORMAL PROGRAM TERMINATION. APAR SE13964: CA400EXP-TERMEMUL-INCORROUT DATA IN BLINKING FIELDS DOES NOT APAR SE13971: OSP-PAR USING VBSCRIPT MACROS MULTIPLE TIMES IN PC5250 HANGS APAR SE13991: CA400EXP-TERMEMUL-UNPRED FUNCTION AND ENTER KEYS INTERMITTEN APAR SE15134: CA400EXP-TERMEMUL PrintScreen doesn't work PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE14819: CA400EXP-OPCON-INCORROUT GUI can hang when CPU is busy APAR SE15504: CA400EXP-OPCON-INCORROUT cwbopcon fault during disconnect APAR SE15505: CA400EXP-OPCON-INCORROUT 5250 emulator doesn't connect APAR SE15506: CA400EXP-OPCON-INCORROUT status 'connected' but system down 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 You must successfully call cwbCO_VerifyUserIDPassword, cwbCO_Signon, or cwbCO_Connect before calling cwbCO_GetPasswordExpireDate. (Note: CWB_INV_BEFORE_VALIDATE can represent a successful call, if the user profile password is set to never expire (*NOMAX) ) If you want to ensure that the value that is returned is recent, you either must call cwbCO_VerifyUserIDPassword explicitly, or set the Validate Mode to CWBCO_VALIDATE_ALWAYS before you call cwbCO_Signon or cwbCO_Connect. 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 SI24723 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 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.