============================================================================ IBM i Access Client Solutions 5733-XJ1 Cumulative Service Pack Level ------------- LCD8-2010-40 ------------- (c) Copyright IBM Corporation 2026. All rights reserved. ============================================================================= NOTICE: This Service Pack is subject to the terms of the license agreement which accompanied, or was contained in, the Program for which you are obtaining the Service Pack. You are not authorized to install or use the Service Pack except as part of a Program for which you have a valid Proof of Entitlement. SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT, REGARDING THE SERVICE PACK. The applicable license agreement may have been provided to you in printed form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR) CL command. ============================================================================= Latest Updates Fixes will only be provided for the latest update. https://www.ibm.com/resources/mrs/assets?source=swg-ia ----------------------------------------------------------------------------- Version = 1.1.9.11 Build date = January 2026 ESS Level = LCD8-2010-40 ****************************** ATTENTION ****************************** This update includes a critical security fix for CVE-2025-66516 IBM i Access Client Solutions is vulnerable to an attacker carrying out an XML External Entity injection via a crafted XFA file inside of a PDF. Apache Tika is used by the Run SQL Scripts feature to determine the content type of binary column data in a table on the IBM i. IBM strongly recommends upgrading to 1.1.9.11, and discontinuing use of versions 1.1.9.8 through 1.1.9.10. ****************************** ATTENTION ****************************** The following Known Issues (APARs) are included: DT455863 OSP-UNPRED ACS - CURSOR VALUE INCORRECT USING DDS KEYWORD RTNCSRLOC DT457428 OSP-INCORROUT ACS DOES NOT DETECT AVAILABILITY OF VERSION 1.1.9.10 ----------------------------------------------------------------------------- Version = 1.1.9.10 Build date = November 2025 ESS Level = LCD8-2010-39 1. IFS - Added a Favorites menu for keeping track of favorite directories The list can be updated using the new star icon next to the parent icon https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4603 - Added the Move action for files and directories within the same system https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2142 - Support for updating Properties on all files in a directory and subdirectories https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2334 2. Run SQL Scripts: - Added several preferences for customizing what job log messages will be displayed See the General tab at Edit-->Preferences... https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4127 - When connecting, extract error messages from the job log for the ADDLIBLE command, and display them in the Messages tab ahead of the Connected... message. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4528 - Added property com.ibm.iaccess.RSSWrapResultsTabs to revert results tabs from a single scrollable row back to a wrapped stack of rows (pre-1.1.9.0) https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4519 - 12 new Insert from Examples: IBM i Services Security - How many libraries are OPEN for attack? Security - How many libraries are OPEN for attack? (ownership perspective) Security - Which commands can anyone use? Security - Which libraries contain commands that anyone use? Security - What Database triggers exist? Security - What are the IFS home directories, where the owner doesn't match the home dir? Security - IFS directories with a name and owner mismatch not using *PUBLIC *EXCLUDE Security - IFS home directory contents object ownership mismatch (detail report) Security - IFS home directory contents object ownership mismatch (summary report) Security - Data areas where any user can see the value (detail report) Security - Data areas where any user can see the value (summary report) Security - Data areas where anyone can change data area value (detail report) 3. Visual Explain - Enhanced the numeric values in attributes to be formatted based on user locale - Enhanced the "Indexes Considered" dialog to show SQL schema and name when available 4. SQL Performance Center: - Added columns to Index Advisor that display the related MTI info LUG Requirement SM1846 5. Schemas: - Make the RGZPFM command available in the Table Reorganize window https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4613 6. Emulator: - Access to the System Debugger is now available from the Actions menu. It can also be added to the Toolbar, Keyboard..., or Popup Keypad via Edit-->Preferences https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3767 7. Data Transfer: - Support for bold headings when adding new sheets to an existing spreadsheet https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4687 8. Usability improvements including: - Printer Output and IFS now support the delete key to initiate the Delete action and the Enter key to initiate the View action. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2157 https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2234 - When viewing Plan Cache Statements, reduce the scope of when the tooltip of the SQL statement is displayed so the other data columns can be easily read https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4681 The following Known Issues (APARs) are included: DT447641 OSP-UNPRED INCORRECT HANDLING OF 1399 CODEPAGE IN EHLLAPI COPY PS (5) FUNCTION DT449480 F/ACS-NEWPRINTSESSIONS DIALOGUE USED FOR NEW PRINTER SESSIONS IN ACS NOT ALLOWED AT JAVA 21. ----------------------------------------------------------------------------- Version = 1.1.9.9 Build date = July 2025 ESS Level = LCD8-2010-38 1. General: - Added /plugin=script so multiple ACS command-line plugins can be called from a single invocation of ACS. See GettingStarted section 9.1.43 for usage and restrictions. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4379 - Cleaning up temporary files created by ACS has been enhanced to provide 2 options: a. Added property com.ibm.iaccess.DaysTemporaryFilesAllowed b. Added the /cleartempfiles parameter to /plugin=maint See AcsConfig.properties for additional details. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4439 - Added property com.ibm.iaccess.DesktopLocation so that the default Desktop location used by ACS can be overridden. See AcsConfig.properties. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3370 - Added property com.ibm.iaccess.AcsConfig to override location and name of AcsConfig.properties. See GettingStarted section 4.1 for details. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4425 - Show the configured system name for the command-line plugins that check or apply updates https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4488 - Added support for passphrase protected SSH keys used by Open Source Package Management and /plugin=httpproxyui 2. Data Transfer: - Added the /sqlfile parameter to /plugin=cldownload. This parameter will support a UTF-8 encoded file that contains a single SQL query. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4432 3. IFS - Added property com.ibm.iaccess.ifs.VerifyAvailableSpace to enable the checking of available space before doing an IFS send, upload or copy/paste. See AcsConfig.properties for details. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2225 - Added Description as an optional column to display the Text attribute of the file. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3478 4. Schemas: - Added the "Work With-->Journal Receivers" action to provide a complete list of related receivers https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2335 - The Table Definition dialog has been changed to leverage the SUPPRESS_INQUIRY_MESSAGES QAQQINI option when dropping columns (instead of requiring authority to the CHGRPLYE command) https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4194 - Support for "Generate SQL..." to save previous directory paths https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4037 - Additional columns have been added to the Journal and Journal Receiver lists 5. SQL Performance Center: - Added Index Evaluator which prompts for a Schema and Table and then launches Work with Indexes 6. Run SQL Scripts: - Support for 7.6 SQL syntax in the formatter - 16 new Insert from Examples: IBM i Services Security - Audit Journal CD review Security - Auditing configuration for commands Security - Commands that Limited Capabilities can use Security - Db2 for i - Delete attack vector Security - Db2 for i - Insert attack vector Security - Db2 for i - Query attack vector Security - Db2 for i - RENAME attack Security - Db2 for i - Trigger attack vector Security - Db2 for i - Update attack vector Security - IFS home directories (detail) Security - IFS home directories (summary) Security - Library List security review Security - Powerful commands Security - Special Authority and Db2 data Security - User profile attack vector Security - Users with Limited Capabilities https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4531 7. Miscellaneous usability improvements including: - The selected system on the ACS main panel should be in view when entering System Configurations - Corrected the list of entries in the IFS most recently used directories dropdown - Added capability to copy the contents of a terminal session started by Open Source Package Management. Ctrl-a (Windows) and Command-a (Mac) will do a select-all and copy to the system clipboard. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4544 The following Known Issues (APARs) are included: DT436323 OSP-WAIT SLOW RESPONSE WHEN RUNNING QUERIES. 5250 SESSION INACCESSIBLE WHILE QUERIES ARE BEING EXECUTED DT438830 OSP-UNPRED FUNCTIONS ARE NOT WORKING WHEN ACS IS STARTED WITH SYSTEM GROUP VIEW DT440129 OSP-UNPRED INTERNAL MACRO ERROR WHEN PRESSING THE ESC KEY ON THE PROMPT SHOWN BY THE MACRO DUE TO THE ELEMENT DT444495 OSP-DB-OTHER-INCORROUT ACS RSS SQL COMMENT REMOVES WHITE SPACE AND DOES NOT ISSUE SQL0104 DT446221 MAINTAINED TEMPORARY INDEXES' NOT SUPPORTED AT THE CURRENT SERVER RELEASE LEVEL. ----------------------------------------------------------------------------- Version = 1.1.9.8 Build date = April 2025 ESS Level = LCD8-2010-37 1. General: - Support for providing an Additional Factor when MultiFactor Authentication (MFA) is enabled on an IBM i 7.6 partition. See section 9.14 in GettingStarted for additional information. - Keep ACS host server connections from being disconnected due to inactivity. See the property com.ibm.iaccess.ConnectionStayAlive in AcsConfig.properties for additional information. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3973 - Launch ACS showing System Groups when that was the last active view. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4238 2. Data Transfer: - Added the "Update existing file" option to the Details panel for Data Transfer downloads to an existing xls or xlsx workbook. This option will update an existing sheet or add additional sheets without changing the existing data or formatting in the workbook. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2927 https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3911 LUG Requirement SM1659 - Added parameters to the cldownload command-line plugin for specifying the sheet, row, and column. An update parameter was also added so the existing data and formatting would not be changed. - Support for the BOOLEAN SQL data type https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4126 3. Run SQL Scripts: - Support for viewing contents of binary result columns (BLOB, BINARY, VARBINARY). - Support for viewing formatted JSON data. LUG Requirement AD1774 - New Preference added on the General tab for bypassing the "Save As" menu. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2616 - New Preference added on Results tab to format numeric values based on locale. This is also available on the Results context menu as "Format Numeric Values". LUG Requirement SM1813 - Improved behavior for the Toggle Comments action. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2093 - Additional Insert from Examples. 4. SQL Performance Center: - Additional filtering on Index Advisor LUG Requirement SM1846 - Additional filtering on Active Query Info - Individual column values can be copied from Plan Cache Statements by using the "Copy Column" option on the context menu. - Added the "Condense Advised Indexes" option to the Index Advisor button. 5. Visual Explain: - Added an action to view indexes considered during optimization (available on each table and the entire plan). The indexes considered will have a reason code and description of why it was or was not used. LUG Requirement SM1845 6. IFS - A new Duplicate action for files and folders https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3993 7. Key Management - A new option "Open Java default" under menu "Key Database File" makes it easier to view the Certificate Authorities (CAs) in the installed Java truststore and to optionally push them to a Windows environment making them available to the optional ACS Windows Application Package. General Announcement: As previously announced in 1.1.9.3, ACS will no longer support checking for FIPS compliance. The option has been removed from the General tab on the main GUI Preferences panel. The following Known Issues (APARs) are included: DT418608 OSP-DB-OTHER-F/QCANPARS-T/QSQRUN4-MSGCPD0017 ACS DISPLAY JOURNAL RECEIVERS FAIL WHEN THE SCHEMA NAME STARTS WITH 'Ñ' ----------------------------------------------------------------------------- Version = 1.1.9.7 Build date = November 2024 ESS Level = LCD8-2010-36 This update provides the following enhancements: 1. 5250 Display Emulator: - EHLLAPI 64-bit support has been added https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2232 See https://www.ibm.com/support/pages/ehllapi-access-client-solutions-emulator 2. General DB Enhancements: - Set the client special register for application name throughout ACS DB functions. For example: IBM i Access Client Solutions - Run SQL Scripts IBM i Access Client Solutions - Run SQL Scripts - Content Assist IBM i Access Client Solutions - Visual Explain - Provide ability to display SQL used to populate various lists 3. Schemas: - Support for displaying Maintained Temporary Index (MTI) detail via a new Table action. Requires these IBMi PTFs (or later): 7.4 SF99704 Level 20 7.3 SF99703 Level 28 - Ability to perform actions in the context of a list that is displayed in a separate window 4. SQL Performance Center: - Established a launch pad for specific database performance features - Added launch for easier access to Index Advisor - Added launch for access to Maintained Temporary Index (MTI) detail - Added launch for access to Active Query Information The following Known Issues (APARs) are included: DT395262 OSP ACS DB SCHEMA " STATISTIC DATA DETAILS " TEXT IS NOT READABLE WHEN ACS IS SET TO GERMAN DT395897 OSP-UNPRED ACS - RUNSQLSCRIPT - SQL FORMATTER AND SYNAX CHECK ISSUE DT395925 OSP-OSP-UNPRED ACS WARNING DT396274 OSP THE DEFAULT PATH AND NAME USED WHEN USING ACS RUN SQL SCRIPT AND SAVING TO AN IFS FILE IS INCORRECT. DT396414 OSP PRINTER SESSION DOES NOT AUTOMATICALLY CONNECT AT ACS V1.1.9.6 DT397540 OSP-UNPRED IBM I ACS 5250 SESSION MAY ATTEMPT FTP CONNECTION TO NETWORK RESOURCE HOSTING EMULATOR FOLDER DT398408 OSP-UNPRED RSS - CL PROMPT FOR COMMAND ADDLICKEY FAILS WITH CPD0082 DT400313 OSP-UNPRED ACS EMULATION - FIELD SET TO BLINK WITH DBCS CHARACTER THE OTHER FIELDS BEFORE THAT FIELD ALSO BLINKS DT400977 OSP-MSGDB0036 SQL0913 DATA TRANSFER WITH LOCK ON FIRST MEMBER DT406832 OSP WHEN USING ACS RSS 1.1.9.6 ON LINUX USING THE SAVE RESULTS OPTION, GETS NO POP-UP. ----------------------------------------------------------------------------- Version = 1.1.9.6 Build date = August 2024 ESS Level = LCD8-2010-35 This update provides the following enhancements and usability improvements: 1. Run SQL Scripts (RSS): - Complete management of custom user examples in RSS, including https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2908 delete and replace https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2996 - Drag-and-drop of .sql files from IFS panel to RSS panel - Support for Projects in RSS for saving/restoring open tabs https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3540 - Added several Insert from Examples https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4056 - File chooser dialog usability improvements (for Windows only) https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4077 2. Schemas: - Support for PROGRAM_NAME on New Function and New Procedure dialogs 3. IFS: - Drag-and-drop of files on PC to open IFS panel https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-1970 - Double-click to view a file https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4117 4. Data Transfer: - When using "Create IBM i Database File", double-click on scan results to open Details https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4073 5. 5250 Display Emulator: - Added the following Screen History enhancements: a. Time stamp of when screen was added to the archive. It will be visible when using the Archive Viewer https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2478 b. Optionally use time stamp in file name when using "Save screens as images..." https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2478 c. Command-line plugin scrconv for converting a saved archive https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3066 6. General: - Update command-line plugin cfg for supporting console configurations https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4071 - Added /gui option to command-line plugin pwchange https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3217 - Added Description and Group name as sortable columns to the Password https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3368 change panel https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4003 The following Known Issues (APARs) are included: DT380854 WHEN CHANGING THE HOST CODE PAGE IN ACS TO 1130 - VIETNAMESE, IT SHOWS ADDITIONAL CHARACTER ON SCREEN DT380879 OSP-UNPRED ACS "VIEW JOURNAL ENTRIES" FAILS WHEN THE SCHEMA AND/OR TABLE NAME IS BETWEEN QUOTES (") DT381910 ACS SQL PERFORMANCE CENTER APPEARS TO HANG TRYING TO VIEW DETAILS FOR A JOB DT382066 ACS 5250 EMULATION COPY PASTE ISSUE WITH A SESSION USING CP 424 DT389695 OSP-UNPRED ACS - CUSTOMIZE MENU BAR - ACTIONS, WINDOWS AND HELP ARE MISSING FROM "MENU LEVEL 1" DT390063 OSP-UNPRED ACS - 5250 SIZE AND SCRATCHPAD ARE DISPROPORTIONAL WHEN SESSION IS MAXIMIZED DT390446 OSP-OSP ACS OPENING DATA TRANSFER AT MULTIPLE DISPLAY ENV BECOMES A VERY WIDE WINDOW DT390468 OSP-OTHER-INCORROUT ACS HANDLING OF CACHED SST PROFILE CAUSING CONSOLE RECONNECTING ISSUES DT391696 CA400EXP-CA400EXP-APIS-OTHER-SRCPWSI-INCORROUT ACS RUN SQL SCRIPTS IFS STREAM FILE NOT OPENING WITH INTENDED SHORTCUT DT393181 OSP INCORROUT-ACS JAPANESE CHARACTERS PRINT INCORRECTLY THROUGH PRINTER SESSION CONFIGURED TO USE JPS ----------------------------------------------------------------------------- Version = 1.1.9.5 Build date = April 2024 ESS Level = LCD8-2010-34 This update contains several usability enhancements: 1. Run SQL Scripts: - Performance improvements to Content Assist https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2328 https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2512 - Enabled the copying of text from Job Log Viewer https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3969 - When selecting files from PC, the List or Details view is saved https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3666 - Connect to a different database using System Group view https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3584 - Added several Insert from Examples 2. Visual Explain: - Added toolbar buttons for easier adjustments when analyzing queries https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-1617 - Added actions to the diagram legend for changing settings - The actions menu has been rearranged to differentiate between actions for entire graph and those of selected icon - New option (icon) to show object system name - New option (arrow) to show both estimated and actual rows - Graph links with hover text that show all attributes - User adjusted icon spacing is now saved 3. Schemas: - Added actions to generate SQL Data Manipulation Language (DML) statements for tables and view (INSERT, UPDATE, DELETE) - Alias support for *LAST (requires the following PTFs): SF99950 level 7 - IBMi release 7.5 SF99704 level 28 - IBMi release 7.4 4. Data Transfer: - Added option to automatically adjust columns when downloading to xls or xlsx files. From the Data Transfer GUI: select Format Options, Other, Adjust column width From the command-line plugin CLDOWNLOAD, specify /adjustcolumns 5. IFS: - Switch to a different system using System Group view https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3584 6. Printer Output - Support switching to a different system https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3895 7. 5250 Display Emulator: - Support for displaying the Host Code Page as part of the title: https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2942 Edit->Preferences->Appearance->Window Setup... (or) as part of the watermark by using &CODEPAGE in the text field at: Edit->Preferences->Watermark... - Specify the initial macro from 5250 command-line plugin. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3703 See the /macro and /mparms options in GettingStarted section 9.1.13 - Added configured Hardware Management Interfaces to the Actions menu. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2537 They can optionally be configured for the toolbar, pop-up keypad, and keyboard mapping. 8. 5250 Print Emulator: - Enhanced the Automatic Page Orientation for JPS printer sessions to be similar to the Automatic Page Orientation for PC5250 GDI-based printer sessions in Access for Windows. 9. Open Source Package Management: - Added property for adjusting timeout. See com.ibm.iaccess.ospm.RunCommandTimeout in AcsConfig.properties 10. General: - Added CHECKVERSION plugin. See GettingStarted section 9.1.41 https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2896 - Optionally enable checking for updates when plugins are not https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3963 launched from the main GUI. See com.ibm.iaccess.CheckUpdateForPlugins in AcsConfig.properties. - Optionally set the default URL for various Hardware Management https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2395 Interfaces. See the com.ibm.iaccess.hmiUrl.* properties in AcsConfig.properties. - Support additional configuration options from the command-line https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3627 for System Groups and Hardware Management Interfaces. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-1995 See the CFG plugin in GettingStarted section 9.1.4. The following fixes are included: SE81001 OSP-UNPRED INSTALL BOOTSTRAP USING ACS FAILS WITH MESSAGE ERROR: BSH: /QOPENSYS/PKGS/BIN/YUM: NOT FOUND SE81017 OSP ACS 1.1.9.4 5250 MSGSSL002 THE IBM I SERVER APPLICATION IS NOT TRUSTED FOR SECURE SOCKETS CONNECTIONS SE81226 QIWA2-OTHER-DATABASE-MSGCPD0046 SQL0443 CPF0006 CPF0001 SE81240 OSP-UNPRED OPSM - FAILED TO LIST INSTALLED PACKAGES SE81341 OSP-UNPRED SELECT BORDER NOT WORKING IN WINDOW BY DOUBLE-CLICK LEFT MOUSE KEY SE81350 EHLLAPI STARTSESSION INTERMITTENTLY FAILS AFTER /PLUGIN=PCS IS CALLED ----------------------------------------------------------------------------- Version = 1.1.9.4 Build date = November 2023 ESS Level = LCD8-2010-33 ****************************** ATTENTION ****************************** This update includes critical security fixes for the following CVEs: CVE-2023-45182 CVE-2023-45184 CVE-2023-45185 IBM strongly recommends upgrading to 1.1.9.4. It is not recommended to run versions prior to 1.1.9.4. But if you do, you may get unexpected prompts asking for credentials if you are also using a version prior to 1.1.9.4 at the same time (on the same workstation). Special instructions: In addition to updating acsbundle.jar on all platforms, any deployment on Windows that uses acslaunch_win-XX.exe (where XX=32 or 64) to start ACS, will also need to update acslaunch_win-XX.exe, acsnative.dll and acspcoc.exe. acslaunch_win-XX.exe, acsnative.dll and acspcoc.exe will be updated automatically when you use any of the following methods to update ACS: 1. An install script in the Windows_Application folder 2. A configured IBM i location in conjunction with the command-line plugin "installupdates" 3. A configured IBM i location in conjunction with "Install Update" from the ACS main GUI (available from Help->About, "Check for Updates" when an IBM i location has been configured for updates) All other deployments on Windows that use these exe and dll files will need to make sure the most recent versions of these files are being used. Failure to use these updated exe and dll files in combination with acsbundle.jar may result in a failed connection to the IBM i host. ****************************** ATTENTION ****************************** Enhancements: 1. Run SQL Scripts: - Syntax support for ENCRYPT_AES256 scalar function. - Insert from Examples extended for additions to SYSTOOLS - Recent files can be viewed using Alt+F R <#> https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3842 2. Schemas: - Added Details action to SQL Packages. 3. SQL Performance Center: - Improve usability of SQL Performance Monitor wizard when selecting a specific job. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-1624 4. IFS: - Option from GUI to allow Sending and Pasting files to other systems through user's workstation when QFileSvr.400 prevents a direct transfer. - Upload option to Store to UTF-8 text file. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3711 5. Emulator: - Add date and timestamp to Status History Log. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3778 - Automatic copy function should not keep trim rectangle. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3768 6. HMC Probe Utility - When connecting to a 5250 console, allow default SSL setting to be changed. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3813 7. General: - Check for Updates should provide a better error message when an internet connection is not available. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3469 - Support for a larger font size throughout ACS. https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-1567 To enable, set the property com.ibm.iaccess.FontSize. The maximum size allowed is 25. This support is being made available for convenience and AS-IS. IBM is under no obligation to fix rendering issues that occur when setting this property. Some known limitations are: a. text in some combo boxes and tabs may not display the entire text depending on the OS and font size b. text within the 5250 display area is unchanged (use 5250 specific settings) c. text within the Run SQL Script editor pane is unchanged (use View->Font...) d. icons and other graphics remain unchanged This update includes several fixes including: SE80286 OSP-THREADS-UNPRED ACS INTEGRATED FILE SYSTEM HANGS ON QTEMP SYMBOLIC LINK SE80395 OSP-UNPRED MSGGEN005 CHANGING PASSWORD FOR MULTIPLE SYSTEMS SE80407 OSP ACCESS CLIENT SOLUTIONS-INCORROUT- SPOOLED FILE PRINTS INCORRECTLY AT V1.1.9.2 USING JAVA PRINT SERVICE SE80466 OSP RUN SQL SCRIPTS GETTING SQL0312 WHEN USING THE OPERATION BETWEEN IN A WHERE CLAUSE AND TRYING TO PROMPT FOR VARIABLES SE80613 OSP-UNPRED ACS PRINTER OUTPUT USER SECTION BLANK ----------------------------------------------------------------------------- Version = 1.1.9.3 Build date = July 2023 ESS Level = LCD8-2010-32 Here are some no-cost versions of Java: https://developer.ibm.com/languages/java/semeru-runtimes/downloads/ https://aws.amazon.com/corretto/ https://adoptium.net/ For information on cost-effective, enterprise-grade support from IBM for your Java deployments: https://www.ibm.com/cloud/support-for-runtimes For additional information see: https://www.ibm.com/support/pages/java-options-ibm-i-access-client-solutions Enhancements: 1. Run SQL Scripts:: - Search across tabs https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3218 - Updated SQL syntax for formatting and colorization - Performance improvements to Content Assist - Additions to Insert from Examples 2. Schemas: - New actions to generate SQL Data Manipulation Language (DML) SQL statements for tables and views 3. IFS: - Added a preference for specifying an "Upload From Location" https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3476 - Added a preference for specifying the maximum threads allowed for doing concurrent uploads and downloads https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3602 - Support a property that sets the top level directory allowed (to enable this restriction, see AcsConfig.properties) https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3187 - Usability improvement when attempting to view files larger than 1MB that do not have an installed viewer https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2492 4. Open Source Package Management: - Support for password protected SSH keys https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3047 5. General: - System debugger added to the Tools menu https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3009 General Announcement: FIPS compliance checking will not be supported in a future update. As the requirements for FIPS compliance change and the Java Runtime Environment (JRE) evolves, it no longer makes sense for IBM i Access Client Solutions (ACS) to attempt to verify whether or not the JRE supports FIPS compliance. The check box "Client SSL must be FIPS-compliant" currently available at Edit-->Preferences will be removed in a future update. Beginning with this update, if this option is checked, a warning will be displayed when visiting the Preferences panel informing the user that this option will be removed in a future update. This update includes several fixes including: SE79815 OSP OSPM DISPLAY HANGS AND DOESN'T COMPLETE SE79819 OSP-OTHER-INCORROUT MSGGEN005 IS RECEIVED WHEN TRYING TO CHANGE AN EXPIRED PASSWORD WITH ACS 1.1.9.2 WITH PASSWORD LEVEL 0 OR 1 SE79821 OSP-OTHER-UNPRED 1.1.9.2. SST PROFILE PASSWORD WITH 9+ CHARACTERS FAILING SE79836 OSP-MSGMSGGEN049-PAR-940XMISC MSGGEN049 GETS WHILE STARTING 5250 EMULATOR WITH ACS 1.1.9.2 SE79857 OSP-OTHER-MSGSQL0104 IN ACS WITH NO WHITESPACE AFTER A LABEL COLON SE80020 OSP-INCORROUT JAPANESE AUTO-IME CHARACTER INPUT IS ACTIVATED ON NON-INPUT SCREEN AREA WHEN CURSOR PASSES THROUGH DBCS CHARACTER ----------------------------------------------------------------------------- Version = 1.1.9.2 Build date = April 2023 ESS Level = LCD8-2010-31 Here are some no-cost versions of Java: https://developer.ibm.com/languages/java/semeru-runtimes/downloads/ https://aws.amazon.com/corretto/ https://adoptium.net/ For information on cost-effective, enterprise-grade support from IBM for your Java deployments: https://www.ibm.com/cloud/support-for-runtimes For additional information see: https://www.ibm.com/support/pages/java-options-ibm-i-access-client-solutions Enhancements: 1. Run SQL Scripts (RSS): - Prompt for statement variables https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-1883 - Rich-text copy support https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2202 - Active hyperlinks https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3237 - Support insert/overwrite toggle https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-2364 - Allow user to set row retrieval block size https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3269 - Added Geospatial Analytics to Insert from Examples when connected to IBMi release 7.4 or later 2. Schemas: - RESTRICT ON DROP support for routines 3. 5250 Emulator: - Support certificates with multiple Subject Alternative Name (SAN) https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3505 4. General: - Eliminate extra terminal window that appears after applying Windows 11 update https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3481 Note: To eliminate the extra terminal window when using ACS Desktop shortcuts or file associations, you must run the install script for your installation located in the Windows_Application folder for this update or later. General information about this update: 1. When using "Help->Check for Updates" to monitor IBM's web location for the next available update, this feature will not work for versions prior to 1.1.9.2 because all ftp requests to this web location have been disabled. 2. When using "HMC Probe Utility" and "Virtual Control Panel", a change was made to use the standard SSH known_hosts file. That means you can expect to be prompted to accept the fingerprint of the IBM i server the first time you connect after installing this update. This update includes several fixes including: SE78904 OSP-UNPRED INTEGRATED FILE SYSTEM ICONS ARE NOT CORRECTLY SHOWN SE78949 OSP-OTHER-INCORROUT ACS 1.1.9.1 CALLING STORED PROC WITH NEWLINE FAILS SE78968 OSP ACS STRPCCMD COMMAND MIGHT HANG WHEN RUNNING A BATCH FILE WITH ECHO OFF SE79066 OSP-DB-OTHER INCORROUT ACS PLAN CACHE DUMP SUBSET MISSING AFTER CREATION SE79072 OSP-UNPRED DB - SCHEMAS - CHANGE RECEIVERS ON AUDIT JOURNAL FAILS SE79090 OSP-RC42705-MSGSQ99999 RELATIONAL DATABASE NOT IN RELATIONAL DATABASE DIRECTORY VENDOR CODE: -99999 SQL STATE 42705 SE79274 OSP-INCORROUT DATA TRANSFER OF EXCEL FILE IS INCORRECT AND INCOMPLETE SE79356 OSP-INCORROUT DATA TRANSFER TO SOURCE FILE NOT TRUNCATING DATA SE79402 OSP-INCORROUT SYSTEM SET TO PROMPT ALWAYS W/ 5250 SESSION BYPASS SIGNON CONTINUES TO USE PREVIOUS CREDENTIALS IF SIGNON SE79501 OSP ACS 5250S IMAGES SAVED FROM THE SCREEN HISTORY WILL NOT KEEP THE CORRECT COLORS SE79505 OSP-DB ACS - UPLOAD RESULT FAILS WITH SQL0104 IF COMMA IS THE DECIMAL SEPARATOR SE79525 CA400EXP USING ACS RUN SQL SCRIPT AND THE EXPLAIN ONLY OPTION WILL RUN THE SQL FOR SOME SQL STATEMENTS SE79526 CA400EXP CHANGES TO ACS RUN SQL SCRIPT AND HOW LIBRARY LIST IS POPULATED SE79527 OSP ACS OSPM IS FAILING TO CREATE AN NGINX FILE IN THE CLONE REPO FUNCTION SE79531 OSP-INCORROUT ACS DATA TRANSFER TO IASP FAILS WITH MSGDB0036 ----------------------------------------------------------------------------- Version = 1.1.9.1 Build date = November 2022 ESS Level = LCD8-2010-30 Here are some no-cost versions of Java: https://developer.ibm.com/languages/java/semeru-runtimes/downloads/ https://aws.amazon.com/corretto/ https://adoptium.net/ For information on cost-effective, enterprise-grade support from IBM for your Java deployments: https://www.ibm.com/cloud/support-for-runtimes For additional information see: https://www.ibm.com/support/pages/java-options-ibm-i-access-client-solutions --------------------------------- Enhancements: 1. Run SQL Scripts (RSS): - New preferences added to Edit->Preferences: General tab: Auto-save options (Idea IBMI-I-1576) Results tab: 'Prompt to close results prior to disconnecting' (Idea IBMI-I-3276) - Recover changed scripts after an abnormal termination (Idea IBMI-I-1690) - 'Copy with headings' supported from results (Idea IBMI-I-1032) - PC file chooser opens in detail view by default (Idea IBMI-I-2213) - Improved positioning of search result (Idea IBMI-I-2501) - Allow additional columns to be viewed in results Details... (Idea IBMI-I-3286) - Refresh existing Joblog window instead of creating a new one (Idea IBMI-I-2586) - Results windows assume focus for keyboard input only if RSS is the active window (Idea IBMI-I-2871) 2. Schemas: - Support for renaming table partitions - Allow delete of *JRNRCV with options: IGNORE_REMOTE_JOURNALS("*IGNTGTRCV") IGNORE_INQUIRY_MESSAGE("*IGNINQMSG") IGNORE_EXIT_PROGRAM("*IGNEXITPGM") (Idea IBMI-I-2901) - Support for 'RESTRICT ON DROP' in Table Definition dialog - Added new column stats information to statistics panel 3. SQL Performance Center: - Show Statements: Support for MTI names object filtering. Added QRO hash, Top N most temp storage, Top N most CPU usage, Top N most database reads filters for live plan cache, snapshots, and database monitors. 4. Visual Explain: - Show object names by default (Idea IBMI-I-3305) 5. Integrated File System: - View options for 'Use short date format' and 'Use IBM i system time zone' (Idea IBMI-I-2612) 6. Open Source Package Management: - Support OpenSSH formatted keys 7. General: - Ability for an admin to install or propagate an updated JRE to their Windows users when "Help->Check for Updates" has been configured to apply updates from an IBM i (Idea IBMI-I-2563) - Host name included in Signon prompt (Idea IBMI-I-2304) General information about this update: 1. The heap size used by IBM i Access Client Solutions (ACS) will no longer default to 1 gigabyte. The heap size will be determined by the Java Virtual Machine (JVM) and the PC available memory. In most cases, this will set the heap size to 25% of the PC's installed memory. The heap size can be overridden by using the -Xmx option on the command-line, with a desktop shortcut, or by setting the JAVA_TOOL_OPTIONS environment variable. The following examples will set the heap size to 2 gigabytes: Example 1 (command-line or desktop shortcut): Start_Programs\Windows_x86-64\acslaunch_win-64.exe -Xmx2g Example 2 (setting the JAVA_TOOL_OPTIONS environment variable): JAVA_TOOL_OPTIONS=-Xmx2g 2. When using "Open Source Package Management", a change was made to use the standard SSH known_hosts file. That means you can expect to be prompted to accept the fingerprint of the IBM i server the first time you connect after installing this update. 3. Mac users that install their updates from a configured IBM i location using "Help->Check for Updates" will need to: Install the update, restart ACS, run "Help->Check for Updates" a second time, install the update, restart ACS The second update is necessary to pick up the new Mac icon for the running application in the dock. This update includes several fixes including: SE77812 OSP ACS DATA TRANSFER SAVE DTTX MIGHT NOT SHOW THE NAME OF THE FILE SE78009 OSP ACS 1.1.9.0 AND EHLLAPI BRIDGE 9.22.096 CRASHING WHEN USING ] OR [ CHARACTER SE78103 OSP-UNPRED NO SIGNON PROMPT ON EACH TIME YOU START NAVIGATOR REQUESTS WHEN "PROMPT FOR USER NAME AND PASSWORD EVERY TIME" SE78106 OSP-INCORROUT UNABLE TO SAVE CUSTOM JKS KEYSTORE FROM ACS KEY MANAGEMENT SE78199 OSP-UNPRED COLUMN DELIMITER IS INCORRECT WHEN DBCS DATA IS ENTERED TO A FIELD WITH DSPATR (CS) SE78282 OSP-MSGCPF3344 ISSUED FOR SPOOLED FILES IN FINISHED STATUS WHEN VIEWING THROUGH ACS PRINTER OUTPUT SE78423 OSP-OSP ACS CHANGE TABLE, REMOVE FIELD NOT WORKING SE78518 OSP-F/QWSGET-T/QWSGET-MSGMCH0601 THE MESSAGE IN THE CURSOR PROTECTION AREA ON LINE 27 CAN BE DELETED WITH THE DEL KEY SE78567 OSP ACS 1.1.9. BUILD ID 2151 - SQL SHOW NO OUTPUT WHEN SYNTAX IS INCORRECT DEFINED SE78601 OSP-UNPRED MESSAGE TEXT NOT SHOWN AT LINE 24 IF FUNCTIONS KEY BUTTONS ARE AT LINE 24 ----------------------------------------------------------------------------- Version = 1.1.9.0 Build date = April 2022 ESS Level = LCD8-2010-29 Here are some no-cost versions of Java: https://aws.amazon.com/corretto/ https://adoptium.net/ https://developer.ibm.com/languages/java/semeru-runtimes/downloads For information on cost-effective, enterprise-grade support from IBM for your Java deployments: https://www.ibm.com/cloud/support-for-runtimes For additional information see: https://www.ibm.com/support/pages/java-options-ibm-i-access-client-solutions Special note for MacOS users: You need to install Java 11 or higher. We recommend https://aws.amazon.com/corretto/ since that version contains the most recent updates for keystroke issues. --------------------------------- 1. General Enhancements: - Support for System Groups in System Configurations - Alternate view from the main GUI for System Groups - Alternate system selection using System Groups (and by Description RFE 149059) (located next to system drop down box on main GUI) - Moved Open Source Package Management to main GUI (RFE 138401) - Naming customization for Hardware Management Interface 1 & 2 (RFE 152498, RFE 154193) (Properties to do this are defined in AcsConfig.properties) 2. Enhancements to Run SQL Scripts (RSS): - Support for multiple scripts in a single RSS window (RFE 132438) - New FileChooser when saving or opening files from the IBM i IFS - Schemas and SQL Performance Center dialogs can now display SQL and CL without using RSS - Search SQL Examples hover help (RFE 154335) - Additions to Insert from Examples Special note about "IBM Navigator for i": To use the new version of "Navigator for i", you no longer need to set com.ibm.iaccess.NewNavigator=true This update includes several fixes including: APAR SE76257 OSP-INCORROUT MSGDB0036 SERVER RETURNED SQL ERROR UPLOADING .XLS FILE APAR SE76310 OSP-DB-OTHER-WAIT AFTER CLOSING ACS, ACSLAUNCH_WIN-64.EXE PROCESS KEEP RUNNING FOR SQL SCRIPTS APAR SE76322 OSP-UNPRED MSGFI002 REPORTED WHEN USING A DBCS DIRECTORY NAME IN THE PATH FOR THE DATA TRANSFER FILE USED WITH DOWNLOAD PLUGIN APAR SE76333 OSP-UNPRED 5250 EXHIBIT INCORRECT HORIZONTAL CHARACTER PLACEMENT WITH ANY FONT OTHER THAN IBM3270 WHEN THE FONT APAR SE76345 OSP-INCORROUT ACD DATA TRANSFER UPLOAD TO IBM I RETURNS ERROR INSTEAD OF TRUNCATING PC FILE EXTRA DATA. APAR SE76349 OSP-INCORROUT SCREEN LINES ARE NOT SHOWN WHEN USING PRINT SCREEN COLLECTION FROM ACS EMULATOR TO AND PDF PRINTER. APAR SE76367 OSP-OSP-UNPRED ACS - IFS - UPLOAD IASP MSGGEN0003 APAR SE76369 OSP-UNPRED ACS DTFX DTTX FDFX DATA TRANSFER APAR SE76523 OSP-UNPRED ACS DATA TRANSFER RETURNED DATE FIELDS ARE MM/DD/YY APAR SE76758 OSP-INCORROUT IACS CONTENT ASSIST (F4) IS NOT RETRIEVING FIELD NAMES APAR SE76792 OSP-INCORROUT ACS USING CREATE IBM I DATABASE FILE FUNCTION SCAN ON XLS FILE RESULTS ON WRONG TYPE COLUMN INFORMATION APAR SE76844 OSP-INCORROUT ACS IFS VIEW FILE MEMBER FUNCTION DOESN'T SHOW ACCENTED CHARS CORRECTLY APAR SE76956 OSP-UNPRED JAVA.LANG.NULLPOINTEREXCEPTION: NULL UNCAUGHT DOING NON-INTERACTIVE DOWNLOAD, DOWNLOAD IS SUCCESSFUL APAR SE77010 OSP-INCORROUT DATA TRANSFER TO IBM I STOPS TRANSFERRING DATA WHEN '#N/A' IS FOUND APAR SE77026 OSP-UNPRED UNABLE TO TYPE NUMERIC VALUES INTO INPUT FIELD WITH HOST CODE PAGE SET TO 420 APAR SE77030 OSP-XTND-OTHER-UNPRED CLIENT ACCESS SOLUTIONS/RUN SQL SCRIPTS CHANGING OPTIONS IMPACT IS DESCRIBED WITH IMPROVED MESSAGE TEXT. APAR SE77161 OSP-INCORROUT ACCESS CLIENT SOLUTIONS DBCS PRINTER SESSION JAVA PRINT SERVICE PRINT TO PDF APAR SE77169 OSP-UNPRED CURRENT_USER FOR ADDITIONAL FILTER FOR AUDIT JOURNAL VIEWER IN ACS SCHEMA NOT WORKING APAR SE77299 OSP-UNPRED WATERMARK TEXT TO SHOW IS SET TO &HOST, THIS DOES NOT WORK WHEN IBM SEMERU 17 IS BEING USED APAR SE77372 OSP-UNPRED ACS 1.1.8.8 DATA TRANSFER HANGS APAR SE77397 OSP-OTHER-INCORROUT ACS 5250 DSPATR(CS) IS LEAKING FROM THE LAST COLUMN OF LINE TO THE FIRST COLUMN OF THE NEXT APAR SE77444 OSP-INCORROUT IBM I ACS EHLLAPI COPY OIA (FUNCTION 13) INCORRECT OUTPUT APAR SE77590 ACS 1.1.8.8. DATA TRANSFER WILL FAIL WITH MSGDB0036 - [CPF325F] CONVERSION OF THE TEXT FAILED APAR SE77745 OSP-INCORROUT ACS DATA TRANSFER FAILS TO REPLACE MEMBER ----------------------------------------------------------------------------- Version = 1.1.8.8 Build date = September 2021 ESS Level = LCD8-2010-28 Here are some no-cost versions of Java: https://adoptopenjdk.net/ https://aws.amazon.com/corretto/ https://developer.ibm.com/languages/java/semeru-runtimes/downloads https://adoptium.net/ For the most current information see: https://www.ibm.com/support/pages/java-options-ibm-i-access-client-solutions For information on cost-effective, enterprise-grade support from IBM for your Java deployments: https://www.ibm.com/cloud/support-for-runtimes Special note for MacOS 11.0 Big Sur: You need to install Java 11 or higher. We recommend https://aws.amazon.com/corretto/ since that version contains the most recent updates for keystroke issues. --------------------------------- 1. Enhancements to Run SQL Scripts: - Commit and Rollback buttons added to the toolbar (RFE 137047) - Warn user when closing a connection with uncommitted actions (RFE 148568) Note: Requires IBM i release 7.3 or higher - Job log search support - Synchronize recently used files when there are multiple RSS windows - Upload Results panel now has separate fields for Schema and Table, and a Replace table option - Additional Examples 2. Enhancements to Schemas: - Previous and Next buttons added on Journal Viewer... View Data Details window (RFE 146834) - Added Deterministic and Inline columns to Functions list 3. Enhancements to SQL Performance Center: - Main window search support - Analyze reports search support - Added convenience buttons for View options on main window - Full statement pop up when hovering over Show Statements plan cache list of statements (RFE 130919) - Added secure database (QZDASSINIT) host server to SQL Details for Jobs 4. Enhancements to Data Transfer - Support for selecting a specific Excel spreadsheet. When connecting to an Active Excel Spreadsheet as the Output device (or Input device), the Name drop-down box allows switching between spreadsheets. 5. Other General Enhancements: - Added Processor Feature Code to Virtual Control Panel (RFE 150132) - System selection from configured systems by typing name (RFE 138461) Special note for Mac users applying this update over 1.1.8.4 or earlier: See the notes under "Special note for Mac users applying this update over 1.1.8.4 or earlier" in this document for version update 1.1.8.7. Special note for users that want to enable ACS to launch to the new "IBM Navigator for i": 1. Apply IBM i 7.3 PTF SI76982 or IBM i 7.4 PTF SI76981 2. Set the following property in the AcsConfig.properties file: com.ibm.iaccess.NewNavigator=true OR set the property on the command line. For example: Start_Programs\Windows_x86-64\acslaunch_win-64.exe -Dcom.ibm.iaccess.NewNavigator=true This update includes several fixes including: APAR SE75536 OSP-UNPRED ACS RIGHT BORDER COLOR CHANGES WHEN SCREEN IS REQUESTED A SECOND TIME APAR SE75557 OSP-OTHER-MSGSQL0104 ACS RUN SQL SCRIPTS FAILS TO CREATE A FUNCTION WITH BEGIN/END IN A CONTINUE HANDLER APAR SE75589 OSP-MSGMSGSSL002-PAR-940XMISC ACS 1.1.8.7 MSGSSL002- THE IBM I SERVER APPLICATION IS NOT TRUSTED FOR SECURE SOCKETS CONNECTIONS APAR SE75696 OSP-UNPRED ACS IFS STOPS LISTING CONTENTS FROM ERROR EXCHANGING SECURITY INFORMATION FOR SYMBOLIC LINK TO QNTC APAR SE75754 OSP-UNPRED ACS 5250 - UNEXPECTED PASTE RESULTS COPYING SOME EXCEL CELLS APAR SE75855 OSP-OTHER-MSGSQL0104 IN ACS RUN SQL SCRIPT WHEN A CASE EXPRESSION IS USED APAR SE75916 OSP-INCORROUT IBM I ACCESS CLIENT SOLUTIONS 5250 DID NOT CLEAR BUTTON PRESSED STATE AFTER BEING PRESSED ON AN AUTO ENTER FIELD APAR SE75977 OSP ACS DATA TRANSFER MAY BE DELAYED FOR 60 SECONDS APAR SE76061 OSP-THREADS-UNPRED ACS DATA TRANSFER FAILS TO OPEN APAR SE76188 OSP-INCORROUT 5250 SESSION RIGHT CLICK DOESN'T DISPLAY POP UP KEYPAD WHEN THERE ARE MOUSE BUTTON EVENTS DEFINED ON THE SCREEN ----------------------------------------------------------------------------- Version = 1.1.8.7 Build date = April 2021 ESS Level = LCD8-2010-27 Here are a couple options for obtaining a no-cost version of Java: https://adoptopenjdk.net/ https://aws.amazon.com/corretto/ Special note for Mac users upgrading to macOS 11.0 Big Sur: You need to install Java 11 or higher. We recommend Java 11 since it is the most recent LTS version. --------------------------------- 1. Enhancements to Run SQL Scripts: - All SQL warnings encountered during results retrieval are now posted to the Messages tab - A Refresh list... option has been added to Database drop-down on the Connection->Connect to Database... dialog - Descriptions for JDBC configurations are displayed as hover text on the Connection->Connect to Database... dialog and Connection->Apply JDBC Configuration menu - Data-mapping errors in results are now displayed as "++++++++++++" to match STRSQL behavior - Additional Insert from Examples 2. Enhancements to Schemas: - A new option on Generate SQL allows constraints to be defined in the CREATE TABLE statement instead of a separate ALTER TABLE statement 3. Enhancements to Visual Explain: - Advised Indexes now combine multiple CREATE INDEX statements into a single Run SQL Scripts window (RFE 146855) 4. Enhancements to Printer Output: - Actions for Delete, Hold, and Release can be monitored in Active Tasks Pane (RFE 149102) 5. Enhancements to 5250 Display: - Allow target address in lower right corner to be copied so it can be pasted (RFE 148520) 6. Other General Enhancements: - Warn user when logging in if caps lock is on (RFE 143192) Special note for Mac users applying this update over 1.1.8.4 or earlier: 1. If you install this update from an IBM i server using the feature described in GettingStarted section "5.2 Setting up an IBM i Update Location", be aware of the following: a. You should first upgrade to 1.1.8.5 before upgrading to the current version. Or, you may go directly to the current version if you use the install_acs script in the Mac_Application directory. If you already applied the update from an IBM i server, ACS will not start. To correct, run the install_acs script in the Mac_Application directory. b. The user will be prompted for an Administrator password. This is necessary so we can move some files to a new location. 2. If you install this update using the install_acs script in the Mac_Application directory: a. No additional instructions are needed. b. The user will be prompted for an Administrator password. This is necessary so we can move some files to a new location. This update includes several fixes including: APAR SE74830 OSP MONOSPACED FONT IS NOT MAINTAINED ON THE SESSION APAR SE74862 OSP-INCORROUT USING ACS RUN SQL SCRIPTS TO RUN SQL PROCEDURE WITH MULTIPLE CURSORS ONLY ONE IS SHOWN APAR SE74898 OSP-INCORROUT FIELD + AND FIELD - NOT WORKING CORRECTLY IN RPG PROGRAM APAR SE74915 OSP-INCORROUT IBM I ACCESS CLIENT SOLUTIONS SIGNON TO IBM I TRUNCATES LONGER SYSTEM NAMES OVER APPROXIMATELY 25 CHARACTERS APAR SE75013 OSP-UNPRED ACS RUNSQLSCRIPTS JDBC CONFIGURATIONS HANDLING NOT CORRECT APAR SE75024 OSP-OTHER-UNPRED IBM I ACCESS CLIENT SOLUTIONS BECOMES UNRESPONSIVE WHEN USING IFS MULTIPLE FILE UPLOAD APAR SE75045 OSP-UNPRED ACS DELETING A DOUBLE-BYTE CHARACTER WITH THE DELETE KEY BREAKS THE UNDERLINE AT THE RIGHT APAR SE75076 OSP ACS EHLLAPI FUNCTION 110 CALLING A MACRO IS FAILING WITH RC 9 APAR SE75095 OSP-UNPRED DATA TRANSFER - A PARAMETER MARKER CANNOT BE SPECIFIED FOR THIS SQL STATEMENT APAR SE75132 OSP-UNPRED RUNSQLSCRIPTS - TOGGLE COMMENT KEY COMBINATION CTRL SLASH ON NON-ENGLISH KEYBOARDS NOT WORKING APAR SE75155 OSP-D/T3812-PAR-940XMISC USING PRINTER DEFINITION TABLE ACS DOES SEND CHARACTERS AS CODE IT IS MISSING CHARACTERS APAR SE75166 OSP-INCORROUT ACS FILE TRANSFER RETURNS NOCLASSDEFFOUNDERROR: ORG.APACHE.COMMONS.MATH3.UTIL.ARITHMETICUTILS ERROR APAR SE75336 OSP-PAR-940XMISC HOST PRINT KEY DOES NOT DISPLAY DBCS LETTER CORRECTLY APAR SE75357 OSP-MSGSQL0612 ACS - SCHEMAS - TABLE -DEFINITION - ADD COLUMN W/ LABEL APAR SE75369 INCORROUT ACS DATABASE CREATION WIZARD DOES NOT CORRECTLY CREATE FIELD TYPES FOR EXCEL XLSX DATE AND TIMESTAMP COLUMNS APAR SE75469 OSP-INCORROUT IBM I ACCESS CLIENT SOLUTIONS IFS HANGS WHEN VIEWING PROPERTIES OF A FOLDER THAT IS A SYMLNK APAR SE75503 OSP-UNPRED ACS DATA TRANSFER NOT HANDLING SPACE BETWEEN SIGN AND NUMERIC ----------------------------------------------------------------------------- Version = 1.1.8.6 Build date = December 2020 ESS Level = LCD8-2010-26 Here are a couple options for obtaining a no-cost version of Java: https://adoptopenjdk.net/ https://aws.amazon.com/corretto/ --------------------------------- 1. Enhancements to the Content Assist feature of Run SQL Scripts include: - Syntax Proposals for the following statements: INSERT, UPDATE, DELETE, MERGE, CREATE INDEX, TRUNCATE - Support for CASE and OLAP expressions - Enhanced support for built-in functions - Provide derived table and UDTF as syntax proposals - The expression at the cursor is wrapped by the provided BIF, CASE, or OLAP expression after content assist - Support for ALIAS files and QTEMP library - Other miscellaneous enhancements 2. Enhancements to Run SQL Scripts: - Reconfigured menus including consolidating preferences on a common dialog at Edit->Preferences... - Variety of improvements to SQL formatting and syntax proposals - Support for INCLUDE SQL (RFE 126674) - Added "Find Previous" and "Go to Line..." on Search menu - Release cursor lock on full table read or inactivity (RFE 129534, 145008) - Change null results from '-' to something else (RFE 141332) - Performance improvements including "Replace All" - Additional Insert from Examples for new IBM i Services 3. Enhancements to Database Schemas: - System name support for Sequences (requires 7.4 PTF SI74324 or 7.3 PTF SI74326) - View Definition column heading and text can be changed - View->Data action includes data from hidden columns 4. Enhancements to Integrated File System: - Multiple file upload (RFE 108689) - Upload an entire folder (RFE 114991) - Support for unzip to extract the contents of a .jar or .zip file (RFE 134332) - Added "View..." with an option to convert a text file to UTF-8 so it can be viewed on the workstation - Support for viewing and downloading /QSYS.LIB .MBR files (RFE 144689) 5. Enhancements to 5250 Display: - Updates to CCSIDs 1377 and 1388. See PTFs required below. 6. Other General Enhancements: - "System for checking updates" added to Edit->Preferences General tab (RFE 143072) - Executable files have been signed with an IBM owned certificate (RFE 136954) - New product icon Special note for Mac users applying this update: If you install this update from an IBM i server using the feature described in GettingStarted section "5.2 Setting up an IBM i Update Location", be aware of the following: 1. You must be at version 1.1.8.5. If you are at a version before 1.1.8.5, you may skip over 1.1.8.5 if you use the install_acs script in the Mac_Application directory. If you already applied the update using this feature and were not at version 1.1.8.5, ACS will not start. Run the install_acs script in the Mac_Application directory to fix it. 2. The user will be prompted for an Administrator password. This is necessary so we can move some files to a new location. If you install this update using the install_acs script in the Mac_Application directory: 1. No additional instructions are needed. 2. The user will be prompted for an Administrator password. This is necessary so we can move some files to a new location. Special note for Mac users upgrading to macOS 11.0 Big Sur: ACS may not be able to locate Java 8 on macOS 11.0 Big Sur. We recommend installing Java 11. This update includes several fixes including: APAR SE74109 OSP ACS DISPLAYING IFS LOCK'S WITH ACS MIGHT FAIL WITH MSGGEN005 - INTERNAL.ERROR APAR SE74176 OSP-INCORROUT ACCESS CLIENT SOLUTIONS 1.1.8.4 DOES NOT ALWAYS HONOR COLHEADINGS=0 APAR SE74216 OSP-DB-OTHER-WAIT RSS -> GENERATE SQL SCREEN -> ADD BUTTON WHILE PROCESSING, OTHER PARTS OF ACS ARE STUCK WAITING APAR SE74224 CAN'T SELECT URL IN 5250 SESSION APAR SE74303 OSP-INCORROUT ACS PASTE CAUSES INCOMPLETE PASTE ERROR SOUND EVEN WHEN PASTE IS CORRECTLY COMPLETED APAR SE74309 OSP-INCORROUT ACS END KEY INCORRECT BEHAVIOR APAR SE74310 OSP-UNPRED ACS INCORRECT VIEW BEHAVIOR WHEN USING AN ACS VIEW CONTAINING A HIGHER NUMBER OF SESSIONS APAR SE74314 OSP-INCORROUT ACS UNEXPECTED RESULTS WHEN USING DELETE KEY ON TEXT HAVING COLOR ATTRIBUTE CHARACTERS APAR SE74322 OSP-INCORROUT ACS VIEW LIST NOT SHOWN AS EXPECTED UNDER CONTEXT MENU APAR SE74367 OSP-UNPRED ACS - FONT STYLE BOX NOT VISIBLE USING 64-BIT JAVA APAR SE74451 UNPRED-HLIC UNABLE TO COPY/PASTE BLANKSPACES IN ACS APAR SE74472 CA400XW1 DUP FIELD NOT WORKING WHEN ER = Y AUTOMATIC RECORD ADVANCE IS USED APAR SE74577 OSP-UNPRED RSS PROMPT CHGJOB DOES NOT RETRIEVE THE CURRENT VALUES FOR THE CURRENT JOB APAR SE74578 OSP-UNPRED RSS PROMPT RSTOBJ RETURNS MESSAGE CPD37BF APAR SE74605 OSP ACS 5250 WS PROFILE STARTED , NO WINDOW TITLE IS SHOWN APAR SE74650 OSP-THREADS-UNPRED ACS EHLLAPI NOT RETURNING CORRECT COLORS ATTRIBUTES APAR SE74662 OSP-UNPRED INPUT LANGUAGE CHANGED FROM CHINESE INPUT MODE TO ENGLISH INPUT MODE AFTER SELECTING SPACE BAR APAR SE74757 OSP-OTHER PASTE WILL ADD AN EXTRA LINE APAR SE75302 OSP-INCORROUT IBM I ACCESS CLIENT SOLUTIONS DBCS SO/SI REMOVED WHEN FILE SEPARATOR IS 1 IBM i PTFs required to support updates for CCSIDs 1377 and 1388: 7.4 - MF67073, MF67039, MF66935, SI71938, SI71937, SI71982, SI72073 7.3 - MF67069, MF66942, MF67120, SI71948, SI71942, SI72060 7.2 - MF67072, MF66946, MF67121, SI71953, SI71952, SI72104 Note: The ACS emulator only supports characters in the basic multilingual plane and does not support surrogate pairs. ----------------------------------------------------------------------------- Version = 1.1.8.5 Build date = August 2020 ESS Level = LCD8-2010-25 Here are a couple options for obtaining a no-cost version of Java: https://adoptopenjdk.net/ https://aws.amazon.com/corretto/ --------------------------------- 1. Enhancements to Integrated File System: - Performance improvements when displaying contents of a directory based on column attributes selected See section "9.12.5 IFS Performance" in GettingStarted for additional details. - Option added to "Download..." for converting a text file to UTF-8 so it can be viewed on the workstation (RFE 118261) 2. Enhancements to the Content Assist feature of Run SQL Scripts include: - F4 as an alternate activation shortcut - Support for providing syntax proposals (templates have been removed) - Support for built-in functions - Highlighting of next expected change(s) within the statement when a proposal is selected - Improved filtering performance in the proposal list - Intelligent positioning of cursor within Content Assist - Support for OLAP and CASE expressions, VALUES queries, derived tables, JOIN clauses and other query support 3. Enhancements to the Visual Explain feature of Run SQL Scripts: - Mouse wheel scrolling has been modified (RFE 142594) 4. Enhancements to Database Schemas: - Added "Call in Run SQL Scripts" action for procedures - Added "Query in Run SQL Scripts" action for functions - Provide additional details for journaled objects 5. Enhancements to 5250 Display: - Added keywords &SYSNAME and &SYSDESC to watermark options (RFE 143829 ) 6. Enhancements to System Configurations: - On Connection tab, display the SSH port configured in the service table (RFE 141986) - Display the port number for each service during Verify Connection 7. Other General Enhancements: - Enable sorting by profile on the Passwords tab (Edit->Preferences) (RFE 141873) This update includes several fixes including: APAR SE73503 OSP-UNPRED 5250 SCREEN CORRUPTED AFTER SELECTING UNDO WHEN SEU IS ENDED AFTER PASTING APAR SE73650 OSP-OTHER-MSGSQL0104 ACS SCHEMAS TRYING TO CHANGE A FIELD DEFAULT TO DATA TYPE DEFAULT APAR SE73734 OSP-UNPRED UPLOAD FAILS WHEN HOST FILE WITH GRAPHIC COLUMNS APAR SE73871 OSP-UNPRED ACS RUNSQLSCRIPT DOES NOT THROW A WARNING MESSAGE WHILE IT SHOULD FOR ADDITIONAL SQL STATEMENTS AFTER A PROCEDURE APAR SE73907 OSP-INCORROUT ACS PRINT SCREEN USING THAI HOST CODEPAGE 838 RESULTS ON BLANK PAGE APAR SE74007 OSP-INCORROUT ACS DATA TRANSFER FILE CREATION WIZARD DOESN'T AUTO POPULATE UPLOAD FIELDS WITH LIBRARY/FILE THAT WAS CREATED APAR SE74015 DBCS X'4240' PRINTS AS BLACK BOX IN IBM I ACCESS CLIENT SOLUTIONS PRINTER SESSION CONFIGURED TO USE IBM5577.PDT APAR SE74024 IN ACS RUN SQL SCRIPT WHEN İIS PART OF THE STATEMENT APAR SE74028 OSP-UNPRED ACS CRASHES INTERMITTENTLY DURING DATA TRANSFER FROM IBM I APAR SE74084 COPY/PASTE ISSUE INTRODUCED IN 1.1.8.4 APAR SE74086 RALT+L NOT PRODUCING AN @ SYMBOL APAR SE74109 ACS DISPLAYING IFS LOCK'S WITH ACS MIGHT FAIL WITH MSGGEN005 INTERNAL ERROR ----------------------------------------------------------------------------- Version = 1.1.8.4 Build date = April 2020 ESS Level = LCD8-2010-24 Here are a couple options for obtaining a no-cost version of Java: https://adoptopenjdk.net/ https://aws.amazon.com/corretto/ --------------------------------- 1. Enhancements to Run SQL Scripts: - SQL language and performance improvements to Content Assist. - Content Assist preferences support, including description text and data type. - Display timestamp of query in results window. (RFE 134636) - Details... action added on query result. (RFE 134635) - Option to Suppress Inquiry Messages. (RFE 140075) - New entries in Insert from Examples for all new IBM i Services. 2. Enhancements to Database Schemas: - SQL Weak Type support. - SQL table comparison support. 3. Data Transfer Enhancements: - Column heading and label options added to CLDOWNLOAD. (RFEs 138673, 138915) 4. Enhancements to 5250 Display and Print emulation: - Compatible pasting of special characters from other Windows documents. See GettingStarted section 9.6.6 5250 Compatibility. (RFE 126146) - Utility to generate the font-image file for User Defined Characters with PDT printing on a Windows workstation. (RFE 130267) - Easier way to create a shortcut to a 5250 session. (RFE 132157) Session Manager, File->Open Directory will open the location of the configuration files. From there, a shortcut or alias can be manually created. - Option on Print Screen Setup to set column separators. (RFE 128192) - Capability to reorder a print screen collection. (RFE 114927) - Option to "Disable the popup keypad menu". (RFE 140004) Available at 5250 Session Manager-->Tools-->Customize Menu Bar... - Allow "Yen" and "Backslash" at the same time. (RFE 132374) Note: With this update, you may want to change the keyboard mapping for the Yensign. To change keyboard mapping, select Edit->Preferences->Keyboard... - Maintain selection in 5250 Session Manager when a 5250 session exits. (RFE 131959) - Option to save screen images from a Screen History Archive. (RFE 123233) 5. Open Source Package Management (OSPM) Enhancements - Install RPM-based open source packages on an IBM i partition not connected to the internet. An SSH tunneling option allows internet access to the RPM repository through the connected workstation. - Maintain a list of recently used locations. (RFE 138815) - Clear Metadata... action added to Utilities. 6. Enhancements to System Configurations: - Features that leverage SSH connections (eg OSPM, SSH Terminal) can configure a different port at System Configurations->Connection. (RFE 140483) - Button on System Configurations Console tab to verify connections (RFE 128193) 7. Other General Enhancements: - Splash screen displays until first panel appears. (RFE 139134) - Several most-recently-used lists have been added (RFE 89715) - Access the internet from an SSH Terminal on an IBM i partition not connected to the internet. See the HttpProxyUI plugin in GettingStarted. This update includes several fixes including: APAR SE72681 OSP-INCORROUT ACS SCHEMAS TABLES DEFINITION ADDING A COLUMN REQUIRES MORE TAB-KEYS TO FILL APAR SE72751 OSP ACS 5250 PASTE WILL ADD AN EXTRA LINE APAR SE72831 OSP-PAR-940XMISC WAIT SCREEN WHEN TRYING FOR VIEW TABLES OR JOURNALS IN ACS 1.1.8.3 DATABASE CONTAINER APAR SE72870 OSP-INCORROUT USING ACS PRINTER SESSION WITH PDT IBM5577-B02,F02,G02,H02 AND APW SYMBOL FUNCTION APAR SE72873 OSP-UNPRED ACS - TEXT ON PANELS NOT TRANSLATED TO THE SELECTED LOCALE APAR SE72879 OSP-UNPRED DATA TRANSFER FIELDS SPECIFIED AFTER AN ENTER TO GET A NEWLINE ON CHANGE DATA OPTIONS ARE NOT SHOWN APAR SE72883 ACS RPM CLONING FAILS APAR SE72913 MSGMSGDB0036 [SQL0104] TOKEN (WAS NOT VALID. APAR SE72951 OSP-INCORROUT WRONG BEHAVIOR WHEN USING ACS 5250 SESSION HOST CODE PAGE 424 AND DDS FLDCSRPRG APAR SE72984 OSP-UNPRED ACS KEYBOARD DOCUMENTATION INCORRECT APAR SE72991 OSP-INCORROUT QUERY/400 STATUS MESSAGES ARE VERY SLOW USING ACS 5250 EMULATION SSL ENABLED. APAR SE72992 OSP-INCORROUT HANG PROBLEMS USING ACS 5250 SESSION WITH HOST CODE PAGE 424 AND DDS FLDCSRPRG APAR SE73042 OSP-INCORROUT ACS CURSOR PROBLEMS WITH DDS KEYWORD RLTB APAR SE73069 OSP-PAR-940XMISC ACCESS CLIENT SOLUTIONS ACS JAVA PRINT SERVICE JPS BESTFIT OPTION RESULTS ARE INCONSISTENT APAR SE73145 LOSING CURSOR ON 5250 EMULATION SESSION APAR SE73163 OSP ACS 5250 PASTING DATA IN A DBCS ENVIRONMENT MIGHT ADD EXTRA CHARACTERS. APAR SE73264 OSP-THREADS-UNPRED ACS RSS UNABLE TO ENTER CHARACTER UCP 00E2 APAR SE73344 OSP-MSGCPDA4A8 ERROR 8925 CREATION OF DEVICE FAILED WHEN SELECTING PRINTER MODEL INFOPRINT 650ES (EPSON MODE) OR (PPDS APAR SE73391 ACS TAKES A LONG TIME TO LOAD WHEN LAUNCHED ON OVER NETWORK. APAR SE73392 ACS 5250 EMULATION IS STARTING MUCH SLOWER WHEN THE BASE DIRECTORY CONFIGURATION CONTAINS A UNC PATH. APAR SE73414 WHEN LAUNCHING A 5250 MULTIPLE SESSION BATCH FILE THE SIGNON TO IBM I PROMPT PANELS MAY BE PARTIALLY BLANK APAR SE73529 RECEIVING ERROR "CANNOT STORE NON-PRIVATEKEYS" WHEN USING IMPORT FUNCTION FROM ACS KEY DATABASE TOOL ----------------------------------------------------------------------------- Version = 1.1.8.3 Build date = December 2019 ESS Level = LCD8-2010-23 Note: This version requires Java 8. To ensure uninterrupted usage, make sure your deployment is using Java 8 before deploying this version. To check which version of Java is being used by IBM i Access Client Solutions, select Help->About from the product's main panel. Here are a couple options for obtaining a no-cost version of Java: https://adoptopenjdk.net/ https://aws.amazon.com/corretto/ --------------------------------- 1. Enhancements to Run SQL Scripts: - Availability of Content Assist (RFEs 96285, 112116, 115073, 123901) - Option in status bar for downloading additional rows (RFE 124799) - Save custom examples using Edit->Examples->Save as New Example... (RFE 103463) - Additional directory support for examples at Edit->Examples->Insert from Examples... , Preferences... - Display cursor coordinates in status bar - Syntax highlighting updates - Insert from Examples enhanced for new IBM i Services 2. SQL Performance Center - Display confirmation message prior to deleting an active monitor ( RFE 130146 ) 3. Enhancements to Database Schemas: - Search capability using Edit->Find - Support for TRUNCATE TABLE - Constraint Definition dialogs show status - List the nodes below each schema in alphabetical order (RFE 137014 ) 4. Miscellaneous Visual Explain improvements 5. Enhancements to Integrated File System: - Add "Open in Run SQL Scripts" action for .sql files - Add "Explain SQL" action for programs 6. Enhancements to System Configurations: - Additional Hardware Management Interfaces on the provided list of candidates (RFE 134333, 134973) Note the following incompatibility: Since Tape Management 2 was added, the Tape Management plugin was renamed from tapemgmt to tapemgmt1 (reference GettingStarted). 7. Data Transfer Enhancements: - Additional option for com.ibm.iaccess.dataxfer.SheetId (RFE 135210) 8. Other General Enhancements: - Check and download updates from an IBM i system. See GettingStarted section 5.2 Setting up an IBM i Update Location. - Import and View Personal Certificates using Key Management (RFE 128331) - The default user id will no longer be switched when changing passwords - Set default action on ACS Window Setup Panel (RFE 137693) This update includes several fixes including: APAR SE71175 OSP-OTHER-INCORROUT USING ACS TO RESTART AN IDENTITY COLUMN FAILS WITH MSGSQL0199 DUE TO MISSING SET KEYWORD APAR SE71212 OSP SQL FORMAT IN ACS GETS NULLPOINTEREXCEPTION APAR SE71213 OSP SAVE PROMPTING IN ACS DOES NOT WORK AS EXPECTED. APAR SE71223 OSP-OTHER-INCORROUT ACS DELETING INDEX ADVISES MAY FAIL WITHOUT AN ERROR APAR SE71224 OSP-OTHER-INCORROUT ISSUE WITH EDIT-PASTE FUNCTION IN IACS V1.1.8.2 5250 EMULATOR. APAR SE71255 OSP-INCORROUT FILTER FOR SPECIFY USER DATA FIELD IN PRINTER OUTPUT IN IBM I ACCESS CLIENT SOLUTIONS DOE NOT HONOR LOWER CASE APAR SE71299 OSP-INCORROUT GRID LINE NOT DISPLAYED IN ACS WHEN USING DSPF WITH DDS GRDLIN OR GRDBOX APAR SE71300 OSP ACS IMPORTED MACRO WILL FAIL WITH " MACRO WAS EMPTY " IF THE OLD PC5250 / PCOM MACRO CONTAINS & OR < OR " CHARACTER. APAR SE71321 OSP-UNPRED ACS DBCS COBOL PROGRAM FAILS WITH MCH0603 APAR SE71388 OSP ACS HARDCOPY LOCAL PRINT FUNCTION WILL GENERATE A PRINTOUT WITH THICK LINES. APAR SE71392 OSP-UNPRED ACS GRID LINES REMOVED USING CLEAR FIELDS FUNCTION APAR SE71396 OSP ACS 5250 EMULATION WILL DISPLAY WRONG DATA IF DATA IS DELETED IN CNTFLD FIELD APAR SE71413 OSP-INCORROUT ACS DDS WINDOW PROBLEMS APAR SE71458 OSP-UNPRED ACS BACKUP SERVER NOT WORKING CORRECTLY APAR SE71462 OSP-INCORROUT POP UP KEYPAD STAYS ACTIVE AFTER SELECTING CUSTOM MENU FUNCTION APAR SE71471 OSP-UNPRED ACS SHIFT TAB MOVES CURSOR TO NON DISPLAY FIELDS APAR SE71504 OSP-UNPRED ACS SHIFT TAB MOVES THE CURSOR TO AN UNINTENDED POSITION ON THE EDTWRD FIELD APAR SE71617 OSP DIFFERENT BEHAVIOUR BETWEEN OLD EHLLAPI OF CLIENT ACCESS AND THE NEW EHLLAPI OF ACCESS CLIENT BRIDGE APAR SE71668 OSP-UNPRED DATA TRANSFER TRUNCATE TRAILING SPACES NOT DONE CORRECTLY APAR SE71699 OSP-OTHER-INCORROUT ACS SAVING SQL SCRIPT RESULT AS OPENOFFICE ODS RESULTS IN DATE COLUMN SHOWN WITH TIME APAR SE71820 OSP-INCORROUT MODIFY OPTION IN SESSION MANAGER DOES NOT SAVE CHANGES. APAR SE71880 OSP-OTHER-INCORROUT ACS RSS EXPORT NCHAR AND GRAPHIC CCSID 1200 NOT SUPPORTED IN ANY FORMAT EXCEPT EXCEL APAR SE71906 OSP ACS 5250 EMULATION MIGHT LOOK LIKE HANGING WHEN THE USERS ARE TYPING VERY FAST APAR SE71950 INCORROUT-HLIC-94XXMISC ACS PROFILE MIGRATION TOOLS DOES NOT CONVERT SSL SETTTING. APAR SE71955 OSP ACS 5250 SESSION INPUT INHIBITED WHEN USING LARGE SUBFILE, MENU WITH BUTTONS APAR SE71971 OSP-INCORROUT DDS SNGCHCFLD WITH KEISEN BUFFER INCORRECTLY DISPLAYED WHEN USING ACS EMULATOR APAR SE72063 OSP-UNPRED ACS NO DATA AVAILABLE ON REORGANIZE WHILE THE REORGANIZATION IS SUCCESSFUL APAR SE72129 OSP-UNPRED AUTO STARTING MACRO USING HOST ID METHOD RETURNS INCORRECT HOST ID IN A BATCH SESSION FILE WITH MULTIPLE SESSIONS APAR SE72147 OSP-UNPRED UNABLE TO VIEW JOB SPECIFIC AUDIT DATA VIA ACS APAR SE72159 OSP-UNPRED INCORRECT CURSOR POSITION AFTER ENTERING DBCS DATA IN INPUT FIELD APAR SE72303 OSP ACS RUN SQL SCRIPT MIGHT HANG APAR SE72384 OSP-UNPRED TYPING DBCS DATA ON AN INPUT FIELD MOVES THE CURSOR TO THE END OF THE FIELD INSTEAD ON TO THE NEXT INPUT FIELD APAR SE72430 OSP-UNPRED ACS NEED REPEATEDLY DO SHIFT SPACE TO SWITCH TO FULLWIDTH APAR SE72576 OSP-UNPRED CHANGED PRINTER NAME ON PRINT SCREEN SETUP NOT SAVED APAR SE72684 OSP ACS CONVERSION PROBLEMS WITH SPECIAL GERMAN PDT PRINTER SESSIONS USING HOST CODE PAGE 1141. APAR SE72746 OSP-INCORROUT ACS EMULATOR LEAVES TRIM BOX BEHIND ON FIELD WITH MOUBTN EVENT. APAR SE72768 SPLF PLUGIN FROM SHARED CENTRAL DEPLOYMENT OF KERBEROS CONNECTION WHEN NOT ENROLLED IN KERBEROS ----------------------------------------------------------------------------- Version = 1.1.8.2 Build date = April 2019 ESS Level = LCD8-2010-22 Note: This version requires Java 8. To ensure uninterrupted usage, make sure your deployment is using Java 8 before deploying this version. To check which version of Java is being used by IBM i Access Client Solutions, select Help->About from the product's main panel. Here are a couple options for obtaining a no-cost version of Java: https://adoptopenjdk.net/ https://aws.amazon.com/corretto/ --------------------------------- 1. Enhancements to Run SQL Scripts: - A completely redesigned SQL formatter which understands complex SQL, provides consistent formatting, and detailed error reporting. (RFEs 94205, 100221) - Run SQL statements using IBM i Source physical Files (RFE 95556) - Run SQL statements using stream files in IFS (RFE 130016) - Connect with last used database and IASP (RFE 131741) - More Insert from Examples - Additional JDBC connection properties for assigning alternate server name and other attributes. - Support languages with bidirectional data (RFE 127738) 2. Enhancements to Database Schemas: - Copy/Paste provides an easy way to establish new projects. 3. Enhancements to Printer Output: - Option to remove system name from the download path (RFE 128478) 4. Enhancements to Integrated File System: - Added action Download... to temporarily override download location set in preferences (RFE 123485) - Added Include filter to improve performance by limiting data returned from the server. (RFE 130007) 5. Enhancements to System Configurations: - Actions may be launched directly from the System Configuration panel using either the menu, context menu (right-click), or keyboard shortcut. - Up to six Hardware Management Interfaces may be configured from a provided list of candidates. The main ACS panel will be updated accordingly. - Columns rearranged so Description is next to System Name. 5. Configuration Enhancements: - Added property com.ibm.iaccess.IncludeComps so administrators can specify a static list of available ACS features (RFE 97999) - Property com.ibm.iaccess.ResetDefaultUserOnImport can be used to reset the default user id when importing a configuration (RFE 123946) 6. Other General Enhancements: - Japanese new era support - For environments like Citrix, property com.ibm.iaccess.ResetForMaintenanceOnExit can be used to end all ACS processes when ACS exits (RFE 130431) This update includes several fixes including: APAR SE70280 OSP-THREADS-INCORROUT INCORRECT BEHAVIOR WITH ACS USING BYPASS SIGNON IN MULTIPLE SESSIONS TO THE SAME SYSTEM. APAR SE70283 OSP-UNPRED OVERWRITING DATA ON A CNTFLD KEYWORD FOR THE TYPE J FIELD ADDS SHIFT IN AND SHIFT OUT APAR SE70295 OSP ACS 5250 EMULATION SELECTING SEVERAL ITEMS IN A MENU MIGHT NOT BE POSSIBLE. APAR SE70307 UNPRED-HLIC ACS FILE SYSTEM SEND OPTION ONLY WORKS WITH .FILE OBJECTS APAR SE70351 OSP-UNPRED INCORRECT CURSOR MOVEMENT EDITING A SOURCE FILE WITH DBCS CHARACTER CONTENT APAR SE70402 OSP-INCORROUT X22 APPEARS TO BE TRANSFORMED TO BLANK, BUT IT'S GETTING OFFSET N+1 X22 IS WHITE COLOR FOR COMMENTS IN RPG. APAR SE70403 OSP-UNPRED REOPENING A SAVED SESSION WITH MINIMIZED SCRATCH PAD SCRATCH PAD IS OPENED AND NOT MINIMIZED. APAR SE70415 OSP-INCORROUT ACS EXCEL FILE TO IBM I FILE TRANSFER DECIMALS ARE INCORRECT APAR SE70416 OSP ACS ACSLAUNCH WIN-32.EXE WILL FAIL TO START WHEN USING JAVA 11 32BIT FROM ADOPTOPENJDK APAR SE70456 OSP-FILE NAME IN WINDOWS PRINT QUEUE DIFFERENT WHEN USING ACS JAVA PRINT SERVICE APAR SE70463 OSP-UNPRED ILLEGAL SHIFT CHARACTERS ARE ADDED WHEN THE CHARACTER TRANSITS TO THE SECOND LINE IN THE O TYPE CNTFLD APAR SE70464 OSP-UNPRED DDS CNTLFLD KEYWORD DBCS CHARACTERS WILL NOT TRANSIT TO THE FIRST LINE WHEN USING DELETE APAR SE70467 OSP-UNPRED DDS SCREEN SHOWS GARBLED DBCS TEXT APAR SE70468 OSP-UNPRED ACS NEW TAB OPENS IN A SMALL AREA OF THE SCREEN WHEN TAB BAR IS NOT SHOWN APAR SE70511 OSP ACS MIGHT ASK FOR A SECOND TIME FOR USER ID AND PASSWORD APAR SE70538 OSP-INCORROUT SARA-AM THAI FONT PRINTS INCORRECTLY USING ACCESS CLIENT SOLUTIONS PRINTER SESSION USING JAVA PRINT SERVICE APAR SE70540 OSP-INCORROUT ACS DATA TRANSFER OF TIMES TO EXCEL APAR SE70545 OSP-UNPRED ACS USING RESTRICT PLUGIN WITH DATAXFER GROUP REPORTS MSGRST001 FOR DTBATCH APAR SE70554 OSP-UNPRED ACS SHOW RESTRICTED FUNCTIONS SCREEN SEEN BY USERS APAR SE70584 OSP IN PERFORMANCE MONITORS AND SELECTING DBMONS TO DELETE THE START OF THE SELECTION CAN BE LOST CAUSING ALL DBMONS TO DELETE. APAR SE70591 OSP-INCORROUT-CRT PASTE INTO 5250 SESSION INCORRECT. CHARACTERS CUT OFF AT END OF LINE RATHER THAN WRAP TO NEXT LINE. APAR SE70600 OSP-ACCESS CLIENT SOLUTIONS ADD PDT SUPPORT FOR EXTENDED APAR SE70665 UNPRED-HLIC WHEN MULTIPLE RDP SESSIONS ARE STARTED BY ONE USER, ALL 5250 SESSIONS LAUNCH ON FIRST RDP SESSION. APAR SE70680 ACS ESC_P PDT INCORRECT OUTPUT APAR SE70806 OSP ACS MULTIPLE SESSION OF LAUNCHER IN A BATCH PROCESS MIGHT RESULT IN MSGGEN045 AND 659 AT THE SESSION APAR SE70842 OSP ACS DATA TRANSFER ACTIVE SPREADSHEET WAS NOT FOUND OR CELL BEING EDITED APAR SE70861 OSP ACS IMPORTING THE SETTING FOR THE "ENABLE TOOL TIP MESSAGE" FROM A ACS_BAK.ZIP DID NOT WORK APAR SE70890 OSP ACS PLUGIN 5250 MIGHT NOT HONOR THE /SYSTEM=XXXX PARAMETER IF A ACSDISPLAY.HOD IS AVAILABLE APAR SE70945 ACS PDT ROMAN NUMERAL / JIS CODE CANNOT BE PRINTED CORRECTLY APAR SE71063 WHEN WRITING THE DDS-WINDNOW RECORD, THE CHARACTERS IN THE BACKGROUND ARE DISCOLORED GARBAGE APAR SE71412 OSP-INCORROUT ACS PC5250 TOOLBAR FILE MIGRATION PROBLEMS ----------------------------------------------------------------------------- Version = 1.1.8.1 Build date = November 2018 ESS Level = LCD8-2010-21 Note: This version requires Java 8. To ensure uninterrupted usage, make sure your deployment is using Java 8 before deploying this version. To check which version of Java is being used by IBM i Access Client Solutions, select Help->About from the product's main panel. Recommended Java Level: Java 8 Update 191 or higher --------------------------------- 1. Enhancements to Run SQL Scripts: - "for update" now allows results to be updated (RFE 89794) - Ability to select text from within a result cell (RFE 91124) - Support for displaying name and label at the same time (RFE 98618) - Support for changing column headings in current results (RFE 108357) - Support for column customization in current results (RFE 125506) - Refresh option to update current results (RFE 108617) - Many new Insert from Examples 2. Enhancements to Database Schemas: - Specifying a system name is supported when creating a new schema - Improvements to Tables->Work with->Related Objects - Added support for changing Aliases, Row Permissions, and Column Masks 3. Enhancements to SQL Performance Center: - Support for filtering Performance Monitors, Plan Cache Snapshots, and Plan Cache Event Monitors. 4. General DB Enhancements: - Added File->New Window to Schemas and SQL Performance Center for selecting a different system (RFE 119563) 5. Enhancements to 5250 Display and Print emulation: - Allow keyboard buffering to be turned off (RFE 91890) - Allow variables in Print Screen Header and Footer (RFE 92158) - Migrate kerberos setting from Access for Windows to ACS (RFE 122787) - Enable margin setting for 5250 print emulation when Use Java Print Service is specified (RFE 122569) 6. Enhancements to Data Transfer: - Custom tab names for Excel download (RFE 112968) - UTF-8 support for Dos Random file type (.dsr) See additional information below for incompatibility with previous versions 7. Other General Enhancements: - Installation scripts for Windows check for compatible version of Java Attention: Users of Data Transfer: This update includes changes that make Data Transfer downloads and uploads using the Dos Random format (.dsr) incompatible with previous versions unless you take the actions outlined below. Other file formats (.csv, .txt, .xlsx, .ods, etc) are not affected. The default File Encoding for Data Transfer downloads and uploads is UTF-8. The File Encoding determines how the downloaded data is formatted within the .dsr file. Previous versions of ACS were not correctly formatting a DosRandom file format when a UTF-8 encoding was specified. Instead, the DosRandom file format was always being formatted according to a US-ASCII encoding. Any saved Data Transfer request files (.dtfx, .fdfx, .dttx) likely have the encoding as UTF-8 (which would be incorrect since the encoding for dsr files was always US-ASCII). Because it is necessary to support characters which cannot be represented by US-ASCII, this update will honor the FileEncoding as specified. That means if you want to continue to use the US-ASCII format, you will need to make the following changes: 1. For new download requests, visit the Details panel and change the "Translate system data to" to US-ASCII. The default is UTF-8. 2. If you have saved Data Transfer download requests (file type dtfx and fdfx) for Dos Random, you will need to change the FileEncoding property from UTF-8 to US-ASCII. 3. If you have saved Data Transfer upload requests (file type dttx and fdfx) for Dos Random, you will need to change the FileEncoding property from UTF-8 to US-ASCII. This update includes several fixes including: APAR SE69687 OSP-INCORROUT LEFT ARROW TO MOVE CURSOR FROM A TYPE TO G TYPE DOESN'T CHANGE TO DOUBLE WIDTH CURSOR. RIGHT ARROW WORKS. APAR SE69690 OSP-PAR-940XCOM JPS PAPER SIZE SETTING IS USING THE WINDOWS DEFAULT DRIVER PAGE SIZE SETTING. APAR SE69730 OSP-UNPRED PRINT THE CURRENT SCREEN EXTRANEOUS COPY OF THE SAME SCREEN ARE RANDOMLY PRINTED WHEN DONE QUICKLY APAR SE69743 OSP ALTERING A COLUMN TO BE IMPLICITLY HIDDEN WITH ACS WILL FAIL WITH SQL0104. APAR SE69745 OSP-THREADS-UNPRED KMP, BAR AND PMP FILES DELETED DURING MIGRATION. APAR SE69761 OSP-PAR-940XCOM ACCESS CLIENT SOLUTIONS JAVA PRINT SERVICES 'GRID RULE LINES' IS MISSING APAR SE69787 UNPRED-HLIC-94XXCOM UP AND DOWN ARROW KEY MOVEMENTS ARE DIFFERENT FROM IAW. APAR SE69794 OSP-PAR-940XCOM JAPANESE EXTENDED SHIFT_JIS SPECIAL CHARACTER NOT PRINTED THROUGH ACCESS CLIENT SOLUTIONS PRINTER SESSION APAR SE69803 OSP-UNPRED INCORRECT DATA DUE TO DATA TRANSFER UPLOAD WITH DSR FORMAT APAR SE69806 OSP-INCORROUT WRONG POSITION IME CONVERSION CANDIDATE WINDOW WITH ACS APAR SE69831 OSP-PAR-940XCOM JAPANESE EXTENDED SHIFT_JIS SPECIAL CHARACTER NOT PRINTED THROUGH ACCESS CLIENT SOLUTIONS PDT PRINTER SESSION APAR SE69845 INCORROUT-PRT-ACS PRINTER SESSION USING JAVA PRINT SERVICES V1.1.8 THAI CHARACTERS PRINT INCORRECTLY APAR SE69846 INCORROUT-ACS V118 EXTRA FILE GENERATED IN PDF DRIVER WINDOWS PRINT QUEUE USING JAVA PRINT SERVICE APAR SE69888 OSP-ACCESS CLIENT SOLUTIONS INTERVENTION REQUIRED MESSAGE ISSUED IN PRINTER SESSION USING WINDOWS 10 AND JAVA 10 APAR SE69900 OSP ACS START MIGHT FAIL WITH JAVA.LANG.REFLECT.INACCESSIBLEOBJECTEXCEPTION APAR SE69907 OSP-OTHER-INCORROUT ACS EHLLAPI SEND KEY (3) RETURNS INCORRECT RESPONSE WHEN CURSOR IS X INHIBITED. APAR SE69916 OSP-UNPRED POSITIONING THE CURSOR USING MOUSE RESULT IN MESSAGE THE KEY USED TO EXIT FIELD NOT VALID APAR SE69917 OSP-RC42601-MSGSQL01014 USING FRENCH LOCALE CAUSES MSGSQL01014 IN SCHEMA SEARCH APAR SE69947 OSP-INCORROUT ACS MIGHT HANG WHEN STARTING NEW 5250 TABBED SESSIONS APAR SE69949 OSP-PAR-940XMISC STICKY POPUP KEYPAD DID NOT WORK CORRECT WITH TAB SETUP ACTIVATED IN A HOD EMULATION. APAR SE69955 OSP-INCORROUT ACS DATA TRANSFER FILE CREATION INCORRECT CCSIDS FOR BLANK COLUMNS APAR SE69983 OSP-UNPRED PRINT SCREEN SHOWS THICK BLACK VERTICAL LINES BENEATH FIELD DATA APAR SE69992 OSP-UNPRED INCORRECT CURSOR BEHAVIOR ON DISPLAY FILE WITH EDTWRD FUNCTION USING ARROW KEYS APAR SE70016 OSP-INCORROUT ACCESS CLIENT SOLUTIONS PRINTER SESSION SET TO USE JAVA PRINT SERVICE NOT PRINTING 198 COLUMNS APAR SE70031 OSP-UNPRED SEVERAL INCORRECT CURSOR MOVEMENT ISSUES WITH DDS DISPLAY FILES APAR SE70046 OSP-UNPRED SEARCH PRESENTATION SPACE 6 RETURNS RC 24 IF PROGRAM SEARCH FOR DBCS BLANK APAR SE70047 OSP-UNPRED OK BUTTON DOES NOT WORK WHEN A DATA TRANSFER FILE IS PUT INTO THE DATA TRANSFER MIGRATION TOOL USING DRAG AND DROP APAR SE70048 OSP-INCORROUT EXTRA SPACE OR ZERO BEFORE NUMBER WHEN USING ACS DATA TRANSFER DOWNLOAD APAR SE70051 OSP-OTHER-INCORROUT CUSTOM DISPLAY LOGON CURSOR BLINKS PROPERLY IN CLIENT ACCESS, BUT NOT IN ACS. APAR SE70063 OSP-PAR-940XMISC JPS DBCS LPI; MARGINS AND START POSITION OF FIRST PRINTED LINE HAS OPTIONS AVAILABLE OR HAS BEEN FIXED. APAR SE70066 OSP ACS STARTING MULTIPLE SESSIONS IN BATCH NIGHT RESULT IN GETTING THE SAME SHORT SESSION ID APAR SE70106 OSP-INCORROUT ACS PROBLEMS WITH DDS PSHBTNCHC KEYWORD APAR SE70114 OSP-UNPRED DBCS CHARACTERS THAT SHOULD BE CORRECTED ARE REPLACED APAR SE70118 OSP ACS IFS DOWNLOAD WILL GET A MSGFI002 " THE FILE COULD NOT BE FOUND " WHEN THE FILE NAME CONTAINS AN ASTERISK APAR SE70142 OSP ACS DATA TRANSFER WILL GET A MSDB0036 SQL0206 WHEN USING FILENAME.FIELD SYNTAX IN THE JOIN CLAUSE APAR SE70143 OSP ACS USING THE ATTN KEY AT A UNICODE FIELD MIGHT HANG THE SESSION APAR SE70152 OSP-UNPRED CHARACTERS ARE SUBSTITUTED WHEN INPUT CHARACTER VALIDATION IS SET TO ON APAR SE70167 OSP-PAR-940XCOM IBM ACCESS CLIENT SOLUTIONS JAVA PRINT SERVICES MONOSPACE THA3270 FONT HAS COLUMN ALIGNMENT INCORRECT OUTPUT APAR SE70170 OSP-UNPRED DATA AFTER DBCS DATA IS NOT PASTED AFTER COPYING A STRING OF DATA FROM SEVERAL INPUT FIELD APAR SE70178 OSP-UNPRED MESSAGE ACS0020 REPORTED WHEN A SESSION IS CLOSED EVEN NOTHING HAS BEEN CHANGED IN FULL SCREEN MODE APAR SE70196 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS ARABIC CHARACTERS PRINTING INCORRECTLY --------------------------------- Version = 1.1.8.0 Build date = June 2018 ESS Level = LCD8-2010-20 Note: This version requires Java 8. To ensure uninterrupted usage, make sure your deployment is using Java 8 before deploying this version. To check which version of Java is being used by IBM i Access Client Solutions, select Help->About from the product's main panel. Recommended Java Level: Java 8 Update 171 or higher --------------------------------- 1. Enhancements to Database Schemas: - Locked Rows (Table/Table Partition) - Lock Holders (Alias/Index/Table/View) - Table action to launch into View Journal Entries - Change Schema Text - Schema Properties - SQL Package Properties - Transactions - Index and MQT partition lists - Allow columns to be added before existing columns (RFE 109711) 2. Enhancements to Run SQL Scripts: - Add system name to title for result windows (RFE 104464) - Added more examples to "Insert from Examples..." 3. General DB Enhancements: - Provide sortable columns for SQL Details for Jobs (RFE 114874) - Add SQL Details for Jobs to the main SQL Performance Center dialog - Preference to control the global naming convention (*SQL or *SYS) for DB tools. 4. Enhancements to Data Transfer: - Do not upload phonetic data from an xlsx file (RFE 106406) 5. Enhancements to IFS: (RFE 117535, RFE 100792) - Additional options for viewing and updating Properties and Permissions. 6. Enhancements to 5250 Print: (RFE 95790, RFE 99537, RFE 107622) - The 5250 print support has been significantly updated to enable Java Print Service (JPS) with the following features: Characters per inch (CPI) Lines per inch (LPI) for SBCS code page sessions (DBCS sessions always use 7.5 LPI) Page size Font size scaling (double-width, double-height, etc.) SBCS and DBCS (with Shift Out and Shift In) text Horizontal and vertical positioning Grid lines Barcodes Font Orientation (automatic, portrait, landscape) With and without scaling (fit-to-page) Note: ASCII transparency (data intended to go directly to the printer) is not supported 7. Added Open Source Package Management: A new interface for managing open source packages on the IBM i has been added to the Tools menu. 8. Several fixes including: APAR SE68889 OSP-UNPRED ERRORLEVEL REPORTS 0 FOR DATA TRANSFER FROM AN EMPTY FILE APAR SE68890 OSP-UNPRED J FIELD TYPE REPORT DOUBLE BYTE CHARACTER REQUIRED AS INPUT USING CURSOR KEYS APAR SE68897 OSP-WAIT ACS FREEZES ON MENU OPTION APAR SE68905 OSP-ACCESS CLIENT SOLUTIONS DBCS HYPHEN SHIFTED ONE BYTE TO LEFT WHEN USING JAVA PRINT SERVICE APAR SE68939 OSP-INCORROUT ACS FILE TRANSFER CREATE IBM I DATABASE FILE CREATES FILE WITH CCSID 1208 APAR SE68962 OSP-INCORROUT CPF5192 - DATA SENT TO DEVICE NOT VALID. NEGATIVE RESPONSE CODE. DURING PROCESS OF RAPID SUCCESSIVE SCREEN UPDATES APAR SE68975 OSP-UNPRED COLOR CHANGES USING ARROW KEY SELECTING RECORDS ON DDS DISPLAY FILE APAR SE68987 OSP-INCORROUT ACS HIGH RATE SCREEN REDRAW CAUSES DELAY FOR THE SCREEN UPDATES APAR SE68998 OSP-UNPRED GRID LINES DDS GRDLIN DISAPPEAR WHEN A DDS GRDBOX IS BEING DISPLAYED APAR SE68999 OSP-UNPRED 5250 SESSION WITH FIXED FONT DOES NOT DISPLAY A PHYSICAL CORRECTLY WHEN THE DATA EXCEEDS 80 CHARACTERS APAR SE69000 OSP-UNPRED SLASH FOR KEYWORD EDTMSK IN DDS DISAPPEARS WHEN TAB KEY IS BEING USED APAR SE69021 OSP-UNPRED FLDCSRPRG HEADING TO THE J-FIELD USED IN DDS CAUSES INVALID CURSOR POSITION. APAR SE69033 OSP-UNPRED UNTRANSLATABLE CHARACTER SHOWN AS BLANK WITH HCP 939 SET APAR SE69048 OSP-INCORROUT SCREEN HISTORY ARCHIVE FILE NOT CREATED THOUGH SUCCESS MESSAGE DISPLAYED IF SESSION NAME CONTAINS INVALID CHAR APAR SE69053 OSP-INCORROUT ACS 5250 KEYBOARD IS NOT LOCKED DURING MACRO PLAYBACK. APAR SE69074 OSP-INCORROUT ACS 5250 IN FULL SCREEN MODE WILL SHOW A LITTLE PANEL WHEN USING THE ALT AND KATAKANA KEY APAR SE69078 OSP-DB-OTHER-MSGSQL0109 IACS LOOSING THE DEFAULT VALUE WHEN ADDING COLUMN TO EXISTING TABLE. APAR SE69101 OSP-INCORROUT ACS DATA TRANSFER ERROR MSGDB0036 STOPS THE TRANSFER APAR SE69106 OSP-UNPRED MESSAGE ROLL UP OR DOWN PAST THE FIRST OR LAST RECORD IN FILE DOES NOT DISAPPEAR WHEN RESET KEY IS PRESSED APAR SE69110 OSP-UNPRED CREATING AN ADVISED INDEX FAILS WITH LANGUAGE DE_DE AND SORT SEQUENCE *NONE APAR SE69138 OSP-F/QLICUSRL-T/QZDANDB-MSGCPF2110 RUN SQL SCRIPTS SPECIFYING A LIBRARY LIST HAS NO AFFECT ON JOB. CPF2110 SEEN IN JOBLOG. APAR SE69211 OSP-UNPRED 5250 EMULATION MAXIMIZED ALWAYS ON PRIMARY DISPLAY IF DO NOT SHOW THE TITLE BAR WHEN MAXIMIZED IS SELECTED APAR SE69212 OSP-UNPRED IME KANJI INPUT IS INCORRECT APAR SE69263 OSP-INCORROUT ACS 5250 EMULATION WILL NOT BE RESPONSIVE ANYMORE WHEN USING THE JUMP NEXT OR JUMP PREVIOUS FUNCTION APAR SE69273 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS USING IBM5587.PDT APAR SE69314 OSP-INCORROUT ACS 5250 EMULATION WILL SHOW AN EXTRA GRAY BOX BEFORE CURSOR APAR SE69317 OSP-UNPRED DATA TRANSFER REPORTS WARNING MESSAGE WHEN FILE EXTENSION DOES NOT MATCH THE FILE TYPE SPECIFIED APAR SE69318 OSP ACS DATA TRANSFER MIGHT NOT RECOGNIZE THE RIGHT CURRENT SHEET APAR SE69360 OSP-INCORROUT-ACS ACCESS CLIENT SOLUTIONS PRINTER SESSION MAXIMUM LINES PER PAGE NOT ALWAYS CORRECT USING IBM5577.PDT APAR SE69361 OSP-INCORROUT ACS SBCS KANA CHARACTER INPUT IN THE TYPE A FIELD APAR SE69400 OSP-UNPRED INPUT CHARACTER VALIDITY CHECK SET TO ON NOT WORKING CORRECTLY IN SPECIFIC ENVIRONMENT APAR SE69436 OSP-ACS-INCORROUT SPOOLED FILES JOINED AS ONE IN WINDOWS PRINT QUEUE WHEN PRINTING FROM ACS PRINTER SESSION USING IBM5577.PDT APAR SE69467 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS BARCODE PRINTING INCORRECT USING BASIC_ASCII PDT IN ACS PRINTER SESSION APAR SE69499 OSP-PAR-940XCOM HOD POSITION IS NOT SAVED CORRECT WHEN WORKING WITH A SECOND DISPLAY APAR SE69503 OSP-UNPRED IME STATE INCORRECT SINCE VERSION 1173 CORRECT STATE SEEN WITH VERSION 1172 APAR SE69508 OSP-UNPRED DATA FROM FIRST SCREEN STILL SHOWN ON POPUP SCREEN APAR SE69511 OSP-INCORROUT ALT+PAGEDOWN DOES NOT WORK CORRECTLY FOR SESSIONS STARTED BY PCSSTARTSESSION APAR SE69513 OSP-UNPRED LOCAL HOST LOOKUP USING VIRTUAL IP NOT FINDING CORRECT ADDRESS APAR SE69544 OSP-UNPRED NOT ABLE TO PASTE SINGLE AND DOUBLE QUOTE INTO J TYPE OR G TYPE FIELD APAR SE69547 OSP-INCORROUT FIELD+ KEY DOES NOT REMOVE THE MINUS (-) SIGN FROM A SIGNED NUMERIC FIELD IF THE FIELD CONTAINS THE MAXIMUM APAR SE69550 OSP-PAR-940XMISC POPUP KEYPAD SETTING FOCUS BACK TO TERMINAL DID NOT WORK CORRECT. --------------------------------- Version = 1.1.7.3 Build date = February 2018 ESS Level = LCD8-2010-19 Recommended Java Level: Java 8 Update 161 or higher Note: The next update scheduled for June 2018 will require Java 8. --------------------------------- 1. Enhancements to Database: - More integration between Schemas and Run SQL Scripts (RFE 108105). - Improved sorting for Show Statements in the SQL Performance Center. - Dependency based sorting when generating SQL. - Support for Properties, Start/End and Swap Receivers has been added to Journal. - A legend has been added to Visual Explain. 2. Enhancements to Data Transfer: - Performance improvements when downloading large files especially to files of type txt, csv, dsr. 3. Enhancements to IFS: - Permissions action for displaying current authorities. - View action for viewing the content of some objects. - Updated icons and hover text for identifying symbolic links. 4. Enhancements to 5250: - Additional support for code page 1371 (Traditional Chinese). - Copy Append As Table for copying a table from multiple pages. 5. Enhancements to Printer Output. - Download... action for allowing preferences to be temporarily overridden (RFE 115970). 6. Several fixes including: APAR SE68339 OSP-UNPRED MSIME YEN SIGN INPUT RESULT IN A BACKSLASH APAR SE68340 OSP-UNPRED LOCK LEFT BEHIND ON FILES UPLOADED WITH ACS INTEGRATED FILE SYSTEM AND FOR FILES LISTED BY ACS IFS APAR SE68405 OSP-INCORROUT ACS DATA TRANSFER FROM EXCEL FAILS IF FIRST COLUMN NOT SELECTED APAR SE68411 OSP-DB-OTHER-MSGSQL0104 ACS SCHEMA, DATABASE MAINTENANCE -> INDEX REBUILDS, ERRORS WITH MSGSQL0104 BUT ONLY IF USING FRENCH APAR SE68431 OSP-INCORROUT ACS DATA TRANSFER UPLOAD FAILING WITH MSGDB0036 WHEN TEXT FIELD ENDS WITH COMMA APAR SE68447 OSP-SLOW PRINTING OF *AFPDS SPOOLED FILE THROUGH ACCESS CLIENT SOLUTIONS APAR SE68451 OSP-UNPRED BACKSPACE NOT WORKING CORRECTLY ON A DSIPLAY FILE WITH CNTFLD KEYWORD FOR O TYPE FIELD APAR SE68452 OSP-UNPRED CHOICE MARKS NOT VISIBLE USING DDS KEYWORDS SNGCHCFLD MLTCHCFLD WITH DBCS TEXT APAR SE68499 OSP-UNPRED UPLOAD CSV FILE REPORTS MESSAGE THE DATA CANNOT BE SENT TO THE HOST FILE APAR SE68540 OSP-INCORROUT ACS MIGRATION OF JAPANESE DTF DATA TRANSFER REQUEST TO DTFX REQUEST RESULTS IN INCORRECT TARGET PATH APAR SE68565 OSP-INCORROUT ACS DDS CNTFLD KEYWORD O TYPE FILED, UPDATE WILL NOT WORK CORRECTLY APAR SE68576 OSP-INCORROUT ACS 5250 EMULATION , POP UP PANEL MIGHT CHANGE TO DBCS DEPENDING ON THE POSITION APAR SE68588 OSP ACS AND SELECTING SCHEMA-TABLE WILL SEE MSGACSDB0036 AND SQL0113 IN JOBLOG FOR DBCS SYSTEMS APAR SE68593 OSP-UNPRED SBCS CHARACTER INPUT WITH IME AUTO START SET BECOMES DBCS DATA APAR SE68608 OSP-UNPRED REPLACEMENT CHARACTER CREATED BY DUP KEY IS SENT WHEN INPUT CHARACTER VALIDATION IS SET TO ON APAR SE68664 OSP-INCORROUT NLS TURKISH CHARACTERS PROBLEMS ON ACS DATA TRANSFER POPUP WINDOW APAR SE68670 OSP-INCORROUT ACS TYPE W FIELD SBCS KANA CHARACTER INPUT PROBLEMS APAR SE68692 OSP-INCORROUT ACS SBCS KANA CHARACTER INPUT IN THE TYPE O FIELD PROBLEMS APAR SE68729 OSP-UNPRED HMC 5250 CONSOLE LOCKS INDEFINITELY AFTER TIME OUT APAR SE68731 UNPRED-HLIC-94XXCOM ACS HANG WHEN WORKING WITH SYSTEM CONFIGURATION / ADVANCED HMC 5250 OPTIONS APAR SE68733 OSP-INCORROUT JAPANESE POSTAL BAR CODE DOES NOT PRINT CORRECTLY ON IBM PAGES PRINTER WHEN USING ACCESS CLIENT SOLUTIONS APAR SE68756 OSP-UNPRED URL HOTSPOT FAILS IF FILE NAME HAS SPACES APAR SE68761 OSP-UNPRED ACS 5250 EXTRA POPUP PANEL IS PRESENTED AFTER ENTERING ALT FX WHICH PASTED A TEXT INTO THE SESSION APAR SE68767 OSP-UNPRED CURSOR IS NOT A DBCS CURSOR IF KEYWORD SNGCHCFLD IS WITHIN DDS APAR SE68792 OSP-UNPRED CHARACTER MISSING AND CHANGED COLOR DISPLAYING SUBFILE APAR SE68802 OSP-INCORROUT ACS 5250 EMULATION WILL NOT SHOW ALL WINDOW CORRECTLY APAR SE68811 OSP IN ACCESS CLIENT SOLUTIONS VERSION 1.1.7.2 HOTSPOTS TO URLS HAVE STOPPED WORKING APAR SE68825 OSP-INCORROUT ACS 5250 EMULATION MIGHT NOT SHOW FX KEY, CORNER OF THE WINDOW FRAME APAR SE68830 OSP-INCORROUT ACS TRANSFER DATABASE FILE CREATED WITH INCORRECT CCSIDS APAR SE68867 OSP-UNPRED PRESS ANY KEY TO RETURN WITH STRPCCMD NOT RETURNED WITH LOCALE SET TO JA_JP --------------------------------- Version = 1.1.7.2 Build date = October 2017 ESS Level = LCD8-2010-18 Recommended Java Level: Java 8 Update 144 or higher Note: The next update scheduled for February 2018 will require Java 8. --------------------------------- 1. General enhancements: - Added SSH Terminal (when an already installed SSH client is found like cygwin, PuTTY, bash, Terminal, Xterm, etc) (RFE 95109) - LAN Console Keep Alive (RFE 99856) 2. Enhancements to Printer Output: - Date/Time format based on locale (RFE 108708) 3. Enhancements to Data Transfer: - Added option to exclude line endings (RFE 110105) 4. Enhancements to Schemas: - Added Database Maintenance options for Check Pending Constraints, Index Builds, Index Rebuilds, Table Alters, Table Reorganizations - Added Database Maintenance option for Text Index Builds (when OmniFind Text Search Server is installed) - Added Related Objects to Views, "Work with" - Added more optional columns to Tables 5. Enhancements to Run SQL Scripts: - Added Change Query Attributes for Connection - "Save as..." location defaults to script location (RFE 94390) - SQL formatting like legacy Client Access (RFE 103029) - Added ability to customize border under View (RFE 108149) - Added examples to "Insert from Examples..." for new IBM i Services 6. Several fixes including: APAR SE67730 OSP-UNPRED UNABLE TO RESTRICT "SCHEMAS" WITHIN THE GROUP "DATABASE" APAR SE67748 OSP-INCORROUT-PRT ASCII TRANSPARENCY IS NOT WORKING FOR DBCS SPOOL DATA APAR SE67769 OSP-UNPRED ACS SESSION WITH 27X132 FREEZES WHEN QUERYING PF APAR SE67792 OSP-UNPRED ACS SHOW SQL STATEMENTS REFRESH DOES NOT KEEP SORT APAR SE67796 OSP-F/QWSGET-T/QWSGET-MSGCPF5411 OVERLAPPING FIELDS IN DSPF LEAD TO MSGCPF5411 APAR SE67811 OSP-INCORROUT ACS WILL NOT HANDLE FPNN HOTPSOT CORRECTLY APAR SE67868 OSP-INCORROUT COPY AND PASTE FUNCTION NO LONGER WORKING ORDER ENTRY FIELDS APAR SE67892 OSP-INCORROUT IBM I ACS ALT KEYBOARD MAPPING PROBLEMS APAR SE67957 OSP-INCORROUT ACS 5250 SCREEN BACKGROUND COLOR WILL SET WHEN UNICODE IS ENABLED APAR SE67962 SAVE OF VISUAL EXPLAIN WITH LARGE NUMBER OF PLAN NODES CAUSING ACS TO HANG APAR SE67972 OSP-INCORROUT ACS SQL PERFORMANCE CENTER, DB FUNCTION TRANSLATION FOR OTHER LANGUAGES IS MISSING APAR SE67984 OSP-INCORROUT ACS PROBLEMS WITH DDS MENUBAR BORDER COLOURS APAR SE67996 OSP-INCORROUT UNABLE TO CONNECT VIA RUN SQL SCRIPT USING ASENSITIVE APAR SE68003 OSP-INCORROUT-PRT PDT PRINTING APAR SE68027 OSP-PAR-940XMISC WHEN A SPOOLED FILE IS OUTPUT BY ACS117 WITH NON-IBM FUJIXEROXPRINTER.PDT, THE FIRST COLUMN RECORDS "BBB" APAR SE68037 OSP-WAIT RUN SQL SCRIPTS CLOSING AN EXISTING RESULT WINDOW WHILE ANOTHER LONG RUNNING QUERY IS ACTIVE WILL BOCK OTHER ACS APAR SE68048 OSP-INCORROUT RUN SQL SCRIPTS RUN TIME MESSAGE SHOW INCORRECT TIME VALUES APAR SE68061 OSP-UNPRED INCORRECT SCREEN AFTER RETURNING FROM ATTENTION PROGRAM APAR SE68080 OSP-UNPRED ACS EHLLAPI @A@U (ROLLUP), @A@V (ROLLDOWN) DOES NOT WORK APAR SE68092 OSP-INCORROUT RIGHT CLICK FROM SPECIFIED FIELD WITH BUILT IN MENU DOES NOT OPEN THE MENU CORRECTLY APAR SE68098 OSP-UNPRED SHIFT-TAB DOES NOT WORK CORRECTLY, ON SCREEN WITH A MULTIPLE SELECTION FIELD APAR SE68135 OSP-INCORROUT ACS 1.1.7.1 DATA TRANSFER WITH ACTIVE EXCEL SPREADSHEET REQUESTING SAVE APAR SE68152 OSP-INCORROUT IBM I ACCESS CLIENT SOLUTIONS PRINTER EMULATION SESSION NOT PROMPTING AS EXPECTED APAR SE68171 OSP-OTHER-INCORROUT ACS DATA TRANSFER FAILS TO CREATE ADDITIONAL SHEETS IN .XLS AND .XLSX FILES APAR SE68172 OSP-UNPRED MESSAGE "DATA CAN NOT BE SENT TO THE HOST FILE" RECEIVED FOR UPLOADING A FILE WITH BLANKS IN COLUMN APAR SE68185 OSP-INCORROUT ACS UPLOAD FILE WITH EOF X'1A' RESULTS ON ADDITIONAL RECORD APAR SE68193 OSP ACS USING FIELD EXIT AT J TYPE INPUT FIELD WILL REMOVE SHIFT OUT CODE 0E APAR SE68199 INCORROUT-CRT-D/T5251-HLIC COLOR SETTINGS ARE NOT CORRECTLY SAVED IN THE HOD PREFERENCES APAR SE68229 OSP-UNPRED LOGON DIALOG ON MAIN DISPLAY WHEN SESSION IS ON EXTERNAL DISPLAY IN A MULTIPLE DISPLAY ENVIRONMENT APAR SE68236 OSP-INCORROUT IBM I ACCESS CLIENT SOLUTIONS DISPLAY DESCRIPTION PANEL NOT FOLLOWING IMPORTED SETTING ON FIRST LAUNCH APAR SE68294 INCORROUT BARCODE IS INCORRECTLY PRINTED AFTER MIGRATING THE EMULATOR FROM IAW TO ACS --------------------------------- Version = 1.1.7.1 Build date = July 2017 ESS Level = LCD8-2010-17 Recommended Java Level: Java 8 Update 144 or higher --------------------------------- 1. General enhancements: - Option to disable end users from accepting "trusted" signers (RFE 99153) - Option to enable SSL by default (RFE 100725) - Enable "Check for updates" from command line (RFE 96516) - Provide better error details (RFE 99599, RFE 105977) 2. Enhancements to 5250 Emulation: - Screen History Archiving - Toolbar buttons for launching Navigator for i (RFE 100673), Schemas (RFE 106817), and SQL Performance Center (RFE 106817) 3. Enhancements to Printer Output: - Combine date/time into single column with most current entry displayed first (RFE 93655) - Date/Time filter (RFE 99212) - Filter Reset button (RFE 104310) 4. Enhancements to Data Transfer: - Automatically truncate extra columns during upload (RFE 106407) 5. Enhancements to Schemas: - Added Health Center - Additional filters for object folders - Action for checking permissions - Added View Entries to Journals 6. Enhancements to Run SQL Scripts: - Added SQL Performance Monitor - Added headings to text type output (RFE 91120) 7. Enhancements to SQL Performance Center: - Added Import SQL performance data - Support for adding new SQL Performance Monitors, Plan Cache Snapshots, and SQL Plan Cache Event Monitors - Properties dialog for SQL Performance Monitors, Plan Cache Snapshots, and SQL Plan Cache Event Monitors 8. Enhancements to Visual Explain: - Added icon Help text 9. Several fixes including: APAR SE67026 OSP-UNPRED MACOS NSINVALIDARGUMENTEXCEPTION POP-UP WINDOW APPEAR WHEN FRONT-END PROCESSING IS TURNED ON APAR SE67044 OSP-UNPRED ACS V1R1M7 117 HEADLESS=TRUE CRASHES BINARY APAR SE67056 OSP-UNPRED DATA TRANSFER UPLOAD CSV FILE REMOVED LEADING BLANKS FOR NUMERIC RECORD APAR SE67076 OSP-INCORROUT UNABLE TO MAP THE BACKTAB FUNCTION TO CONTROL(LEFT)+TAB. APAR SE67086 OSP-UNPRED ACS DATA TRANSFER UPLOAD TAB DELIMITED TEXT FILE REMOVED LEADING BLANKS FOR NUMERIC RECORD APAR SE67088 OSP-UNPRED RUNNING ACS DATA TRANSFER FROM CMD PROMPT DISPLAY THE GUI DIALOG "DO YOU WANT TO SAVE THIS TRANSFER REQUEST?" APAR SE67097 OSP-INCORROUT ACS CHARACTER BACKSPACE HOST FUNCTION MOVES CURSOR TO INCORRECT POSITION APAR SE67103 OSP-INCORROUT- GRID LINE NOT PRINTED ON HOST PRINT SCREEN THROUGH ACCESS CLIENT SOLUTIONS DISPLAY SESSION APAR SE67108 OSP-INCORROUT IBM I ACS EHLLAPI HANDLES SOME RETURN CODES WRONG, APPLICATIONS MAY NOT GET DATA EXPECTED FROM SESSION. APAR SE67119 OSP-UNPRED MSGSY1008 WHEN CHANGING PASSWORD WHICH BEGINS WITH A DIGIT (QPWDLVL 0 OR 1) APAR SE67122 OSP-UNPRED MOUSE POINTER IS AN ARROW WHEN HOVERING OVER AN URL HOTSPOT WHEN A WATERMARK IS IN USE APAR SE67147 OSP-UNPRED MODIFIED DATE AND TIME ARE CHANGED OF XLSX PC FILE DOING ACS DATA TRANSFER UPLOAD APAR SE67151 OSP-UNPRED RETURNING TO 5250 SESSION, OVERLAYS ARE NOT DISPLAYED AFTER CLICKING URL HOT SPOT APAR SE67172 OSP-UNPRED LOSING CURSOR ON THE PROMPT SCREEN FROM A PROGRAM APAR SE67176 OSP-PERFM ACCESS CLIENT SOLUTIONS HANGS WHEN TRYING TO PRINT A PRINT COLLECTION. APAR SE67193 OSP-UNPRED GRID LINES ARE INCORRECTLY PAINTED ON THE SCREEN IN COMPARISON WITH PCOM. APAR SE67205 OSP-INCORROUT ACS DB CREATION WIZARD WILL CHOOSE WRONG FIELD SIZE APAR SE67214 OSP-INCORROUT ACS DB CREATION WIZARD WILL FAIL IF FIRST LINE OF AN EXCEL SHEET DOESN'T CONTAIN THE FIELD NAMES MSGGEB005 APAR SE67239 OSP-UNPRED UNABLE TO RE-TYPE UPPER/LOWER LEVEL OF THAI CHARACTER APAR SE67240 OSP-UNPRED COPY THAI CHARACTER TO NOTEPAD TRUNCATED IF ONLY THAI CHARACTER IS SELECTED APAR SE67335 OSP-INCORROUT NUMERIC DATA IN ROW, COLUMN HAS TOO MANY DIGITS FOR THE IBM I ERROR MESSAGE RECEIVED WHEN UPLOADING AN XLS FILE APAR SE67349 OSP-THREADS-INCORROUT ACS EXCEL DATA TRANSFER FROM OPEN SHEET MIGHT CRASH THE DATA TRANSFER APPLICATION APAR SE67367 OSP-INCORROUT ACS SCREEN HISTORY ARCHIVE WILL FAIL AFTER DEPLOYMENT FROM ACS_BAK APAR SE67383 OSP-INCORROUT DISPLAY FILE WITH GRID LINE HAS MISSING PART ON ROW 1 COLUMN 1 WHEN USING ACS APAR SE67406 OSP-INCORROUT ACS PROVIDING INCORRECT PASTE OUTPUT WHEN PASTING INTO FIELD CONTAINING "/"S APAR SE67416 OSP-UNPRED UPLOAD FAILS WHEN HOST FILE WITH PACK DECIMAL COLUMNS APAR SE67477 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS IGNORING SHIFT IN ( X'0F ) WHEN PRINTED THROUGH PRINTER SESSION APAR SE67478 OSP-INCORROUT ACS INCORRECTLY SKIPPING PROTECTED FIELDS WHEN PASTING. APAR SE67498 OSP-UNPRED DECIMAL VALUES INCORRECT IN TARGET FILE UPLOADING EXCEL FILE APAR SE67511 OSP-INCORROUT ACS EHLLAPI FIND FIELD (32) FUNCTION RETURNS 0, INCORRECT VALUE. APAR SE67527 OSP-UNPRED UPLOADING TAB DELIMITED TEXT FILE TO SOURCE PHYSICAL FILE DOES NOT WORK APAR SE67573 OSP-INCORROUT INCORRECT FORMAT WHEN UPLOADING TAB DELIMITED TEXT FILE TO SOURCE PHYSICAL FILE APAR SE67580 OSP-UNPRED CURSOR MOVES TO WRONG POSITION ON A DISPLAY FILE WITH CONFIGURED BUTTONS APAR SE67588 OSP-INCORROUT ACS EMULATOR IS NOT BEHAVING CORRECTLY WITH CUSTOM MADE SCREENS. APAR SE67590 OSP-INCORROUT DBCS SESSION WITH AUTOMATIC RESIZE SET SHOWS PART OF PREVIOUS SCREEN APAR SE67591 OSP-UNPRED PRINT SCREEN (LOCAL COPY) IS NOT INCLUDED IN A MACRO WHEN RECORDED. APAR SE67632 OSP-INCORROUT DATA IS DROPPED WHEN SQL STATEMENT IS COPIED FROM MULTIPLE CELLS (EXCEL) AND PASTE ON ACS 5250 ON MAC APAR SE67640 OSP-INCORROUT ACS BATCH PROCESSING, WINDOWS ERRORLEVEL NOT WORKING, ONLY 0 WILL BE RETURNED APAR SE67643 OSP-UNPRED CRED. CACHE NOT USED WHEN HOD FILE HAS SET "USE DEFAULT USER NAME ..." AND SYSTEM CONFIG HAS "PROMPT EVERY TIME" APAR SE67649 OSP-INCORROUT ACS 5250 EMULATION WILL SOMETIMES STILL SHOW THE BORDER OF A PREVIOUS SCREEN APAR SE67669 OSP-INCORROUT EURO SIGN NOT SHOWN IN FONT IBM3270-1251 APAR SE67670 OSP-UNPRED MINUS SIGN FOR NUMBER NOT PASTE APAR SE67698 OSP-ACCESS CLIENT SOLUTIONS-GRID LINES NOT PRINTING CORRECTLY ON PRINT SCREEN COLLECTION APAR SE67739 OSP-UNPRED PASTING, COPY OF TABLE, DATA INTO EXCEL ADDS A BLANK LINE TO THE LAST LINE APAR SE67744 OSP-INCORROUT ACS UPLOAD OF NEGATIVE CURRENCY VALUES FROM EXCEL FAILS APAR SE67755 OSP INCORROUT-ACCESS CLIENT SOLUTIONS-SPOOLED FILE GENERATED BY APW WITH BAR CODE PRINTS INCORRECTLY APAR SE67764 OSP OSP-UNPRED HOTSPOTS NOT WORKING WHEN HOST CODE PAGE IS SET TO 838 --------------------------------- Version = 1.1.7.0 Build date = March 2017 ESS Level = LCD8-2010-16 --------------------------------- The following features have been added: 1. Initial release of Schemas Database management interface Supported object actions include: -Manage definitions -Manage descriptions -Generate SQL -Work with properties -Object rename -Create new database object -Show object references -Index advisor (raw and condensed) -Explain SQL -Table data actions (view, clear, copy, initialize) -Integrates with Visual Explain -Integrates with SQL Plan Cache -Much more 2. Enhancements to Run SQL Scripts - Added CL Prompter - Added upload results - Improved formatting - Enhanced SQL highlighting - Many new 'Insert from Examples' (built using SQL Services) 3. Several fixes including: APAR SE66556 OSP-UNPRED CURSOR POSITIONING ISSUES JUMPING FROM INPUT FIELDS IN DBCS ENVIRONMENT APAR SE66557 OSP-UNPRED CURSOR MOVES IN PROTECTED FIELD USING ARROW KEYS,IT DOES NOT JUMP TO THE NEXT AVAILABLE ENTRY FIELD APAR SE66572 OSP-UNPRED MSGFI002 UNABLE TO FIND FDFX FILE ON ACS DATA TRANSFER UPLOAD WHEN SAVED DTTX AND FDFX FILE NAMES ARE APAR SE66577 OSP-INCORROUT ACS EMULATION CURSOR MOVES INCORRECTLY TO PROTECTED FIELD APAR SE66595 OSP RUN SQL SCRIPTS - KEYBOARD KEY: END QUIT GOING TO THE END OF THE LINE, AND WENT TO THE START OF THE NEW LINE APAR SE66633 OSP-INCORROUT ACS DATA TRANSFER MAY ALLOW UNINTENTIONAL JOIN OF A FILE MEMBER TO ITSELF APAR SE66647 OSP-INCORROUT ACS PRINTER EMULATION OUTPUT, RIGHT BOARDER COULD NOT BE MINIMIZED APAR SE66667 OSP-UNPRED THAI SESSION IN ENGLISH MODE SOME KEYS STILL TYPE THAI CHARACTERS APAR SE66686 OSP-MSGSQL0104 ACS RUN SQL SCRIPT FAILS WITH SQL0104 WHEN SEVERAL STATEMENTS WITH CASE(SUBSTR ARE RUN APAR SE66700 OSP-UNPRED CLIENTFILE AND HOSTFILE EMPTY NOF FILLED IN DATA TRANSFER REQUEST FILE APAR SE66703 OSP-INCORROUT SSL DATA TRANSFER CONNECTION REQUIRES MULTIPLE PROMPTS FOR CREDENTIALS APAR SE66803 OSP-WAIT BYPASS SIGNON NOT WORKING APAR SE66826 OSP-INCORROUT ACCESS CLIENT SOLUTIONS DATA TRANSFER UPLOAD FAILS ON CURRENCY FIELD APAR SE66867 OSP-UNPRED CURSOR POSITIONING ISSUE USING ARROW KEYS APAR SE66875 OSP-UNPRED NEW SPECIFIED OUTPUT FILE IN SAVED DATA TRANSFER NOT USED WHEN USED APAR SE66882 OSP-INCORROUT ACCESS CLIENT SOLUTIONS FAILING TO SHOW CORRECT SQL QUERY OUTPUT OF AN ENCRYPTED FIELD APAR SE66894 OSP-INCORROUT ACCESS CLIENT SOLUTIONS BAR CODE NOT PRINTING CORRECTLY FOR JAPANESE SPOOLED FILE APAR SE66929 OSP-THREADS-UNPRED RUNNING QUERY, THE QUERY STATUS IN LINE 24 OF 5250 IS NOT DISPLAYED APAR SE66981 OSP/PLUGIN=CERTDL ONLY DOWNLOADS THE LOCAL CERTIFICATE AUTHORITY ON THE SYSTEM APAR SE66997 OSP-UNPRED ENTER SBCS CHARACTER, SHIFT-IN AND SHIFT-OUT REPLACES TWO DBCS CHARACTERS APAR SE67007 OSP-INCORROUT EMULATOR LAUNCHED DATA TRANSFER FAILS WITH MSGFI002 THE SYSTEM CANNOT FIND THE PATH SPECIFIED APAR SE67061 OSP-INCORROUT ACS SCRATCH PAD DOES NOT BEHAVE CORRECTLY WITH TABS ENABLED. --------------------------------- Service Pack Level = LCD8-2010-15 Build date = January 2017 --------------------------------- The following features have been added: 1. Enhanced Printer Output filter to support multiple output queues and User-Specified Data. 2. Enhanced Data Transfer to support Dos Random. 3. Enhancements to restrict functions using Application Administration. 4. A bridge for running EHLLAPI with 5250 applications is available on the Update web site. 5. Several fixes including: APAR SE62680 OSP-INCORROUT ACS 114 HLLLENGTH IS NOT UPDATED APAR SE66061 OSP-INCORROUT ACCESS CLIENT SOLUTIONS GRID LINE PRINTS INCORRECTLY ON XEROX IN ESCP MODE WITH CUSTOMIZED PDT FILE APAR SE66062 OSP-INCORROUT ACCESS CLIENT SOLUTIONS DATA WRAPPING TO SECOND LINE WHEN PRINTED ON XEROX IN ESCP MODE USING CUSTOM PDT FILE APAR SE66121 OSP-INCORROUT ACS SOME CHARACTERS WILL NOT BE SHOWN WHEN USING HOST CODE PAGE 1112 IN THE EMULATION SETUP AND IBM3270 1257 FONT APAR SE66129 OSP-INCORROUT ACS USING MLTCHCFLD DDS KEYWORD, A DESELECTION OF AN OPTION VIA A MOUSE CLICK WILL NOT WORK. APAR SE66158 OSP-INCORROUT ACS NUMERIC 8,0 DATA WILL BE SHOWN IN AN EXCEL SHEET IN AN EXPONENTIAL NOTATION APAR SE66174 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS CHARACTER SPACING AND VERTICAL LINES INCORRECT WHEN USING ESC_P.PDF APAR SE66200 OSP-UNPRED KEYBOARD FILE LOCATION (KEYREMAPFILE) NOT WRITTEN WITH FULL PATH. APAR SE66201 OSP-UNPRED YEN SIGN IS CLEARED WHEN IT IS ENTERED ON A W TYPE FIELD WITH IME AUTO START ON APAR SE66247 OSP-INCORROUT DISPLAY FILE WITH DDS WINDOW BORDER HAS SOME ROWS THAT ARE LEFT WITH SAME COLOR AS TEXT ROW APAR SE66249 OSP-UNPRED HIGH RESOLUTION SCREENS, FONT RENDERING IS POOR. APAR SE66253 OSP-INCORROUT DOTTED / DASHED LINE WRAPPING WHEN PRINTING THROUGH ACCESS CLIENT SOLUTIONS PRINTER SESSION TO XEROX APAR SE66254 OSP-INCORROUT PRINT LINES WRAPPING WHEN PRINTING THROUGH ACCESS CLIENT SOLUTIONS PRINTER SESSION TO XEROX PRINTER APAR SE66255 OSP-INCORROUT LINES PER INCH DIFFERENT WHEN PRINTING THROUGH ACCESS CLIENT SOLUTIONS PRINTER SESSION TO XEROX PRINTER APAR SE66261 OSP-INCORROUT .PMP FILE TYPES NOT GETTING SAVED IN THE EXPORT CONFIGURATION APAR SE66271 OSP-INCORROUT STRPCCMD FAILS WITH NOT RECOGNIZED AS AN INTERNAL OR EXTERNAL COMMAND, OPERABLE PROGRAM OR BATCH FILE APAR SE66281 OSP-UNPRED GRID LINE DOES NOT DISAPPEAR WHEN GOING TO THE NEXT SCREEN APAR SE66299 OSP-INCORROUT 8 LPI NOT PRINTING CORRECTLY THROUGH ACCESS CLIENT SOLUTIONS PRINTER SESSION APAR SE66315 OSP-UNPRED PASSWORD NOT CACHED USING A BATCH FILE WITH /PLUGIN=LOGON APAR SE66340 OSP-MSGCPF2110 ACS FILE TRANSFER INCORRECTLY ADDS IASP NAME TO LIBRARY LIST. APAR SE66385 OSP-INCORROUT JAPANESE SPECIAL CHARACTER NOT PRINTED THROUGH ACCESS CLIENT SOLUTIONS PRINTER SESSION APAR SE66414 OSP-INCORROUT ACCESS CLIENT SOLUTIONS DOWNLOAD PRINTER OUTPUT OF*LINE SPOOLED FILE INCORRECT APAR SE66415 OSP-INCORROUT ACCESS CLIENT SOLUTIONS NOT ALL PAGES OF SPOOLED FILE PRINTS TO XEROX PRINTER USING CUSTOM PDT FILE APAR SE66416 OSP-INCORROUT ACCESS CLIENT SOLUTIONS POSITIONS OF CHARACTERS INCORRECT PRINTING TO XEROX WITH CUSTOMIZED PDT APAR SE66468 OSP-UNPRED PARAMETER *SHARE FOR /USERID FOR CFG PLUGIN DOES NOT WORK APAR SE66469 OSP-INCORROUT MSGGEN005 ILLEGAL HEXADECIMAL CHARACTER N AT INDEX N WHEN USING ACS VISUAL EXPLAIN ON STORED PROCEDURE. APAR SE66482 OSP-UNPRED LEFT ARROW KEY WILL NOT SKIP TO PREVIOUS INPUT FIELD APAR SE66483 OSP-UNPRED CURSOR POSITIONING NOT WORKING CORRECTLY USING THE UP ARROW KEY APAR SE66504 OSP-INCORROUT DOWN ARROW KEY WILL NOT SKIP TO CORRECT POSITION ON NEXT INPUT FIELD APAR SE66526 OSP-INCORROUT-ACS PRINTER OUTPUT DOWNLOAD IN TEXT FORMAT IGNORES PAGE RANGE --------------------------------- Service Pack Level = LCD8-2010-14 Build date = October 2016 --------------------------------- The following features have been added: 1. Added Integrated File System (IFS) action and icon for newly defined 5250 emulation sessions. 2. Added hover text revealing file description when browsing files within Data Transfer. 3. Several fixes including: APAR SE65439 OSP-INCORROUT APW SYMBOL NOT PRINTED THROUGH ACCESS CLIENT SOLUTIONS PRINTER SESSION APAR SE65475 OSP-INCORROUT TEXT POSITION DIFFERENT USING ACS PRINTER SESSION WITH JAVA PRINT SERVICES APAR SE65488 OSP-MSGSQL5016 USING RUN SQL SCRIPTS WITH *SYS SYSTEM NAMING CONVENTION MSGSQL5016 IS RETURNED APAR SE65498 OSP-INCORROUT ACS WIDTH OF GRID LINES INCORRECT WHEN PRINTING THROUGH ACCESS CLIENT SOLUTIONS PRINTER SESSION APAR SE65513 OSP-INCORROUT ACS DATA TRANSFER DB CREATION WIZARD WILL HANG FOR SHEETS WITH MORE THAN 8999 CELLS APAR SE65517 TIME OF DAY AND CREATION DATE ARE INCORRECT AFTER APPLYING THE 1.1.6.0 BUILD 6320 DATED AUGUST 1, 2016. APAR SE65518 OSP-INCORROUT ACS FILE TRANSFER DOWNLOAD PACKET FIELDS ARE PADDED WITH SPACES EVEN IF PAD WITH LEADING ZEROS IS SPECIFIED APAR SE65525 OSP-INCORROUT ACS DATA TRANSFER NOT REMOVING SPACES FROM CHARACTER NUMERIC VALUES APAR SE65541 OSP-INCORROUT ACCESS CLIENT SOLUTIONS PRINTER SESSION PRINTS AMIKAKE ( SHADING ) INCORRECTLY APAR SE65542 OSP-INCORROUT ACCESS CLIENT SOLUTIONS 1 MM GAP IN AMIKAKE (SHADING) AFTER TEST FIX APAR SE65543 OSP-INCORROUT ACCESS CLIENT SOLUTIONS APW DOUBLE MAGNIFIED GRID LINES NOT PRINTING APAR SE65549 OSP-INCORROUT KEYBOARD FAST UP AND FAST DOWN FUNCTIONS MISSING APAR SE65565 OSP-INCORROUT DATA TRANSFER FROM IBM I WHERE CLAUSE DOESN'T ALLOW TO SPECIFY A VALUE ON COMPARE POPUP SCREEN APAR SE65567 OSP-INCORROUT-ACESSS CLIENT SOLUTIONS ( ACS ) CHARACTERS SHIFTED RIGHT IN PRINTED OUTPUT APAR SE65568 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS ( ACS ) BLANK PAGE ADDED IN PRINTER OUTPUT APAR SE65569 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS ( ACS ) UNEXPECTED EQUAL SIGN (MARK) PRINTED THROUGH ACS PRINTER SESSION APAR SE65571 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS ( ACS ) APW MAGNIFY DOES NOT WORK APAR SE65573 IBM I ACCESS CLIENT SOLUTIONS PRINTER OUTPUT LOOSES COLUMN SORTING CRITERIA AFTER AN ACTION SUCH AS DELETE. APAR SE65575 OSP-INCORROUT ACS DATA TRANSFER FROM SYSTEM I INTO A XLSX WILL DELETE LEADING SPACES / BLANKS APAR SE65576 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS PRINTED OUTPUT STARTING LOWER ON THE PAGE APAR SE65578 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS PRINTER SESSION NOT PRINTING APW GRID LINES APAR SE65606 OSP-UNPRED MIGRATION OF TOOL BAR FILE DESTROYS JAPANESE CHARACTERS APAR SE65640 OSP-INCORROUT ACS DISPLAY SESSION USING CP 1112 WILL NOT SHOW ALL CHARACTERS. APAR SE65641 OSP-INCORROUT IBM I ACS WINDOWS_APPLICATION SINGLE USER INSTALL SCRIPT DOES NOT INSTALL TO /USERS/USER_ID/IBM/CLIENT SOLUTIONS APAR SE65649 OSP-INCORROUT ACS GRID LINE CLEAR WILL NOT CLEAR ALL GRID LINES APAR SE65652 OSP-UNPRED IBM I ACCESS CLIENT SOLUTIONS CRASHES ON OPEN USING ACSLAUNCH_32.EXE OR ACSLAUNCH_64.EXE AFTER MOVING TO ACS 1.1.6 APAR SE65668 OSP-INCORROUT DDS OVERLAY OR WINDOW MENU LETTERS FROM THE SCREEN UNDERNEATH DISPLAY IN THE ACTIVE MENU APAR SE65694 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS APW FORM FEED OCCURRING IN BOX / FRAME WHEN PRINTING APAR SE65695 OSP-INCORROUT STRPCCMD DOESN'T WORK WHEN USING %TEMP% APAR SE65712 OSP-UNPRED 5250 SESSION PAGE OVERLAYS BLEED THROUGH APAR SE65717 OSP-INCORROUT ACS OIA INDICATOR CAN'T CHANGE TO JAPANESE KANA ZENKAKU IF CUSTOMER PUTS THE CURSOR ON DBCS CHARACTER (O-FIELD). APAR SE65733 OSP-UNPRED ACS DATA TRANSFER REMOVES PRECEDING BLANKS WHEN FILE TYPE IS SET TO MICROSOFT EXCEL 2007-2010(.XLSX) APAR SE65734 OSP-UNPRED BACKGROUND SCREEN BLEEDS THROUGH WINDOW SCREEN APAR SE65736 OSP-INCORROUT-ACCESS CLIENT SOLUTIONS UNABLE TO PRINT TO FUJI XEROX PRINTER WITH CUSTOM PDT FROM XEROX APAR SE65749 OSP-UNPRED STRANGE BEHAVIOR CHARACTER INPUT BY MS-IME APAR SE65751 OSP-UNPRED THE ACS DOWNLOAD TO ASCII TEXT IS NOT HANDLING THE POSITIONS FOR THE SIGN WELL. APAR SE65754 OSP-INCORROUT ACCESS CLIENT SOLUTIONS CPI / SPACING INCORRECT USING IBM 5577 PDT APAR SE65757 OSP-INCORROUT ACCESS CLIENT SOLUTIONS SPOOLED FILE SPACING / CPI DIFFERENT WHEN PRINTING SPOOLED FILE APAR SE65759 OSP-INCORROUT ACCESS CLIENT SOLUTIONS LETTERS PRINT LOWER ON PAGE THROUGH ACS PRINTER SESSION USING IBMK14YOKO PAGES PDT APAR SE65769 OSP-UNPRED SO/SI GENERATE FUNCTION NOT AVAILABLE APAR SE65770 OSP-UNPRED SI CHARACTER IS REMOVED WHEN FIELD-EXIT IS USED WHEN THE CURSOR IS AT THE LEFT END OF THE FIELD APAR SE65771 OSP-UNPRED TYPING SINGLE BYTE CHARACTER WITH AUTOMATIC IME ON DOES NOT WORK APAR SE65774 INCORROUT DATA TRANSFER UPLOAD FAILS FROM XLSX WITH HOST FIELD TYPE: DECIMAL, CLIENT FIELD TYPE: DATE USING ACS LOCALE JA_JP APAR SE65786 OSP-PERFM ACS DATA TRANSFER IS USING A STATIC SCROLLABLE CURSOR. APAR SE65799 OSP-INCORROUT ACS 5250 SESSION FAILS TO CONNECT WITH SSL ENABLED. APAR SE65800 OSP-INCORROUT ACCESS CLIENT SOLUTIONS ONLY HALF PAGE PRINTED WHEN PRINTING THROUGH PRINTER SESSION USING IBMK14TATE PDT FILE APAR SE65813 OSP-UNPRED SI/SO GENERATE OPTION INCORRECTLY WORKS ON FIELD TYPES J AND W APAR SE65824 OSP-MSGCPF5411 QUERY WITH ENCRYPTED DATA RESULTS IN CPF5411 APAR SE65844 OSP-UNPRED WHEN DDS MOUBTN IS BEING USED, DEFINED FOR RIGHT DOUBLE CLICK DOES NOT WORK CORRECTLY APAR SE65846 OSP-INCORROUT POPUP WINDOW DOES NOT HAVE A COMPLETE BORDER APAR SE65847 OSP-INCORROUT MIGRATING .WS FILE SHOWS SUCCESSFUL. NEW .HOD FILE NOT CREATED APAR SE65858 OSP-INCORROUT ACCESS CLIENT SOLUTIONS APW GRID LINE NOT PRINTING CORRECTLY WIHT PDT IBM5577 - B02 F02 G02 H02 APAR SE65882 OSP-INCORROUT NUMERIC FIELDS ARE LEFT ALIGNED AFTER DATA TRANSFER, SO NO LEADING SPACES APAR SE65883 OSP-INCORROUT EHLLAPI PROGRAM RECEIVES INVALID DATA WITH ACS SESSION HOST CODEPAGE 939 APAR SE65901 OSP-PERFM ACS WHERE CLAUSE CALLDBMAINTFOROPENOROPTIMIZE PARENS INCORRECT SQL STMT DATA TRANSFER APAR SE65952 OSP-UNPRED LARGE DATA-TRANSFER FROM A REMOTE SYSTEM CRASHES APAR SE65973 OSP-INCORROUT GRID LINE NOT PRINTING IN EXPECTED AREA USING XEROX PDT FILE APAR SE65975 OSP-INCORROUT ACCESS CLIENT SOLUTIONS FONT SIZE AND SPACING INCORRECT WITH IBM5577 PDT APAR SE65991 OSP-INCORROUT ACCESS CLIENT SOLUTIONS GRID LINES PRINT INCORRECTLY USING IBM5587 PDT APAR SE66005 OSP-UNPRED ENDING ACS DATA TRANSFER ENDS ALL SESSIONS TOO APAR SE66105 OSP-INCORROUT ACCESS CLIENT SOLUTIONS UNABLE TO PRINT TO FILE USING QWPDEFAULT WSCST OBJECT APAR SE66136 OSP-MSGGEN005-MSGGEN001 ISSUED WHEN DOWNLOADING SPOOLED FILES THROUGH ACCESS CLIENT SOLUTIONS PRINTER OUTPUT --------------------------------- Service Pack Level = LCD8-2010-13 Build date = July 2016 --------------------------------- The following features have been added: 1. Integrated File System (IFS): - Copy/Paste files between IBM i partitions - Send files to multiple IBM i partitions - Download/Upload files to/from PC - Other actions include New Folder, Delete, Rename, Properties 2. Enhancements to 5250 emulation: - Smart card enablement on Windows for SSL client authentication 3. Enhancements to SQL Performance Center: - Visual Explain - Compare - SQL plan cache tab - Show Statements for both the SQL plan cache and saved data 4. Enhancements to Run SQL Scripts: - Visual Explain integration - JDBC Configuration Manager - Job Log Viewer - SQL Details for Job - Global Variables and Special Registers tab - Enhanced messages pane - SQL Formatter 5. Enhancements to Data Transfer: - Support for character and numeric truncation - Support for including column names/headings when downloading to text file types - Usability improvements to Create IBM i DB File wizard - Enablement for Active Calc Spreadsheet on Mac - Ability to override default sheet name during download 6. Deployment/Install: - Support for silent mode when used in combination with /AdminConfig - Multi-user installation on Windows - Ability to restrict the Printer Output filter to Current user 7. Several fixes including: APAR SE62793 OSP-INCORROUT MSGDB0036 DATA TRUNCATION WITH ACS DATA TRANSFER APAR SE64279 OSP-INCORROUT SECURE CONNECTION THAT FIRST CONNECT TO AS-RMTCMD TO DOWNLOAD APP ADMIN DATA DOESN'T PROMPT FOR SSL CA CERT TRUST APAR SE64599 OSP-INCORROUT ACSLAUNCH_WIN-64.EXE IS REMOVING THE EXTRA SPACES WHEN USING STRPCCMD APAR SE64607 OSP-UNPRED ACCESS CLIENT SOLUTIONS, DEFAULT PRINTER APAR SE64623 OSP-INCORROUT ACS DATA TRANSFER TO SOURCE PHYSICAL FILE APAR SE64633 OSP-INCORROUT ACS RUN SQL SCRIPT FAILS WITH PARSING ERROR WHEN NESTED CASE IS USED IN AN EXPRESSION APAR SE64697 OSP-INCORROUT ACS DB CREATION WIZARD FOR NEW FILE TRANSFER WILL NOT HANDLE DECIMAL PLACES CORRECTLY. APAR SE64705 OSP-THREADS-UNPRED DESTINATION ADDRESS" SETTING IN .HOD USING IP ADDRESS FOR NAMED CONNECTION APAR SE64719 OSP-UNPRED GRDLIN DISAPPEARS BY SCREEN TRANSITION APAR SE64763 OSP-UNPRED COPY/PASTE OF A DATE IS INCORRECTLY DONE APAR SE64774 OSP-INCORROUT ACS DISPLAY SESSION / COPY AS IMAGE WITH SCREEN SIZE 27X132 CONTAINS IMAGE FROM A PREVIOUS SCREEN APAR SE64796 OSP-UNPRED UNABLE TO CREATE ACS PRINTER SESSION WITH HOST PRINT TRANSFORM SET TO NO APAR SE64861 OSP-INCORROUT ACS FILE SCAN PRODUCES INCORRECT FDFX FILE APAR SE64865 OSP-INCORROUT ACS COPY PASTE OF HEX VALUES LIKE 0X01 ETC. WITH CRASH OEM APP APAR SE64870 OSP-INCORROUT ACS HOD FILE MODIFIED VIA NOTEPAD EDITOR WILL NO LONGER BE RECOGNIZED AS A VALID CONFIGURATION FILE APAR SE64925 OSP-INCORROUT ACS HMC CONSOLE JAPANESE SOFTWARE AGREEMENT WILL NOT BE SHOWN CORRECTLY APAR SE64941 OSP-UNPRED CONSOLE BAR INCORRECT INFORMATION, NOT WORKING WELL TO MULTIPLE PARTITIONS ON SAME SYSTEM APAR SE64957 OSP-INCORROUT ACS PSHBTNCHC DID NOT WORK CORRECTLY APAR SE64968 OSP-UNPRED THE IBM I FIELD REFERENCE FILE NAME IS NOT CORRECT - THE IBM I FILE NAME IS NOT CORRECT APAR SE64972 OSP-UNPRED WINDOW SIZING WAS NOT CONSISTENT WHEN USING DUAL MONITORS APAR SE65004 OSP-UNPRED COLUMN SEPARATOR SET TO LINE GOES THROUGH DBCS CHARACTERS APAR SE65012 OSP-UNPRED INITIATE SQL DETAILS FROM ACS RUN SQL SCRIPTS NO DATA IS SHOWN IN NAVIGATOR FOR I APAR SE65065 OSP-UNPRED OPEN SESSIONS IN A NEW TAB (UNCHECKED) PREFERENCE APAR SE65068 OSP-UNPRED ACS MSGGEN001 POSTED IF USER EXIT DENIES ACCESS APAR SE65073 OSP-UNPRED FIELDS FOR DISPLAY FILE NOT CLEARED WITH DBCS SESSION APAR SE65102 CA400XW1-INCORROUT IBM I ACCESS CLIENT SOLUTIONS 5250 EMULATOR HANGS WHEN PASTING MORE THAN 1 LINE INTO FIELD WITH SCROLL BAR APAR SE65111 OSP-UNPRED ROWS ON SUBFILE ARE MISSING ON A 27X132 ACS SESSION APAR SE65144 OSP-UNPRED BLANKS ARE ADDED IN THE DOWNLOADED FILE WHEN DBCS CHARACTERS ARE IN THE FIELD. APAR SE65147 OSP-INCORROUT "HOST FIELD: CHARACTER, CLIENT FIELD: NUMERIC" UPLOAD TO IBM I FAILS WHEN WORKING IN A GERMAN ENVIRONMENT APAR SE65167 OSP-UNPRED ALIGNMENT NOT CORRECT FOR DOWNLOAD TO A TEXT FILE APAR SE65195 OSP-INCORROUT ACS FILE TRANSFER WITH NONE US ASCII TEST FILES WILL NOT WORK DUE TO COMMA AS DECIMAL SEPARATOR APAR SE65212 OSP- WINDOWS DEFAULT PRINTER ALWAYS USED WHEN JAVA PRINT SERVICE IS YES IN ACS PRINTER SESSION APAR SE65215 OSP-INCORROUT CURSOR DOES NOT MOVE CORRECTLY WHEN PRESSING LEFT ARROW KEY. APAR SE65216 OSP-INCORROUT ERROR HAPPENS WHEN A HORIZONTAL SCROLL BAR IS ENABLED. APAR SE65233 OSP-UNPRED GRID LINE NOT SHOWN AT THE TOP OF THE ACS 5250 EMULATION SCREEN APAR SE65244 OSP-INCORROUT DBCS CHARACTER IN OIA FIELD GET CHANGED IMPROPERLY WHEN THE CURSOR IS MOVED ON THE DBCS FIELD. APAR SE65247 OSP- APW VERTICAL GRID LINE MISSING WHEN PRINTED THROUGH ACCESS CLIENT SOLUTIONS APAR SE65253 OSP-INCORROUT TEXT COLOR IS INCORRECT WITH ACCESS CLIENT SOLUTIONS APAR SE65271 OSP-UNPRED WHEN DDS MOUBTN IS BEING USED, MOUSE CLICK DOES NOT WORK CORRECTLY WITH HCP 939 APAR SE65286 OSP-INCORROUT ACS EMULATION IS NOT WORKING CORRECTLY WITH MNEMONIC APAR SE65287 OSP-UNPRED ZONED DECIMAL VALUES IN FIELD ARE SET TO 0 INSTEAD OF SINGLE NUMBERS 1 THROUGH 9 AFTER UPLOAD APAR SE65288 OSP-INCORROUT THE IBM I ACS 5250 EMULATOR MAY NOT CORRECTLY CLEAR THE GRIDLINES (DDS KEYWORD GRDLIN) FROM A PREVIOUS SCREEN APAR SE65298 OSP-UNPRED ACS STREML3270 CPF5063 NEGATIVE RESPONSE 10050151 APAR SE65309 OSP-UNPRED VIETNAMESE CHARACTERS MISSING FROM "CHARACTERS" IN KEYBOARD MAPPING APAR SE65325 OSP-ACCESS CLIENT SOLUTIONS (ACS) - APW DOTTED LINE NOT PRINTED THROUGH PRINTER SESSION APAR SE65347 OSP-INCORROUT ACS HCP1399 HOD BRIDGE INCORRECT CHARACTER CONVERSION USING EHLLAPI APAR SE65438 OSP-INCORROUT EXTRA PAGES PRINTED FOR DBCS SPOOLED FILE THROUGH ACCESS CLIENT SOLULTIONS PRINTER SESSION APAR SE65455 OSP-INCORROUT ACS DB CREATION WIZARD WILL NOT HONOR LAST ROW FOR XLSX SHEETS APAR SE65456 OSP-INCORROUT ACS DB CREATION WIZARD WILL ELECT WRONG SCALE FOR EXCEL SHEET APAR SE65459 OSP-INCORROUT ACS DATA TRANSFER DB CREATION WIZARD FROM ACTIVE SPREADSHEET WRONG NUMERIC SCALE APAR SE65467 OSP-INCORROUT ACS DATA TRANSFER DB CREATION WIZARD WILL CHOOSE WRONG FIELD TYPE FOR CELL WITH A FUNCTION APAR SE65478 OSP-INCORROUT ACS DATA TRANSFER FDFX FILE CREATED IN WRONG LOCATION APAR SE65487 OSP-INCORROUT TRAILING BLANKS PROBLEMS WHEN UPLOADING UTF-8 CSV FILE TO TYPE G DBCS-GRAPHIC DATA APAR SE65489 OSP-INCORROUT ACS DATA TRANSFER DB CREATION WIZARD WILL NOT HONOR LAST ROW OF XLS SHEET FOR FILED SIZE CALCULATION --------------------------------- Service Pack Level = LCD8-2010-12 Build date = March 2016 --------------------------------- The following features have been added: 1. Printer Output: Additional actions for Hold, Release, Move, Delete, plus several performance and usability enhancements. 2. Enhancements to 5250 emulation including: - Custom positioning of watermark - New toolbar action for Printer Output - Capability to specify the starting index for Workstation ID - Grid Line support for DBCS PDT - Usability improvements to printer output - Capability to disable default right-mouse click 3. Capability to easily check and monitor for product updates. 4. Several fixes including: APAR SE62282 OSP-INCORROUT THE DBCS CHARACTERS ARE MISSING WITHIN THE PDT SUPPORT. THE OUTPUT IS GARBAGE. APAR SE63789 OSP-UNPRED MSGGEN003 - COULD NOT GET COOKIE FOR AUTHENTICATION WHEN "NAVIGATOR FOR I" IS CLICKED WITH ACS 1.1.5 EIM CONFIGURED APAR SE63815 OSP-UNPRED COPY DBCS DATA FROM 5250 NOT CORRECTLY PLACED IN THE CELLS OF A SPREADSHEET APAR SE63817 OSP-INCORROUT DDS 'PULLDOWN' MENU NOT RESPONSIVE TO MOUSE CLICK APAR SE63826 SBCS KANA INCORROUT PRINTING WITH HOST CODEPAGE 930, 939 & 1399 & CUSTOMIZED PDT COMPILED ON ACS. YIELDS UNEXPECTED RESULTS. APAR SE63863 OSP-INCORROUT LIBREOFFICE WILL DIE AFTER UPLOADING DATA FROM A OPEN SPREADSHEET WITH ACS APAR SE63864 OSP-UNPRED RUN SQL SCRIPTS - SQL STATEMENT WITH CASE FAILS WITH SQL0104 APAR SE63890 OSP-UNPRED ACS MACRO CREATION. HOST ACCESS MACRO EDITOR=>SCREENS TAB. OPTION=FALSE CAUSED HANG CONDITION, APAR SE63898 OSP-PAR-940XCOM ACS PDT PRINT CREATE SAMPLES FOLDER IN IBM I ACCESS CLIENT SOLUTIONS (32-BIT) 1.1.5.0 BUILD ID: 5492 IS EMPTY APAR SE64037 OSP-INCORROUT ACS SESSION HANGS CALLING PGM USING DDS FROM DSPSIZ(24X80 *DS3) TO DSPSIZ(27X132 *DS4) APAR SE64077 OSP-INCORROUT ACS SYSTEM DROP-DOWN LIST ON WRONG DISPLAY APAR SE64164 OSP-UNPRED HOST CODE PAGE 1148 BELGIUM NOT AVAILABLE APAR SE64168 OSP-THREADS-UNPRED ACS 5250 LINUX HANGS APAR SE64218 OSP-UNPRED FTP BATCH EXECUTED WITH STRPCCMD SHOWS NO RESPONSE STATUS MESSAGES IN THE FTP LOG AND NO COMMAND WINDOW OPENED APAR SE64250 OSP-D/T5585-PAR-940XCOM PCOMM GRID LINE / MAGNIFIED APW / DDS CHARACTERS IS NOT PRINTED USING PDT. APAR SE64318 OSP-INCORROUT ACS WILL SHOW MSGDB0036 WHEN LIB IN THE LIBL CONTAINS FRENCH APAR SE64420 OSP-INCORROUT ACS WILL NOT WORK CORRECTLY WITH DDS KEYWORD ENTFLDATR --------------------------------- Service Pack Level = LCD8-2010-11 Build date = December 2015 --------------------------------- The following updates have been added: 1. Database options have been added to the main GUI for: - Run SQL Scripts - SQL Performance Center 2. Enhancements to 5250 emulation including: - keyboard customization "Search for Key" will display default keystroke - URL hotspots that span multiple lines are allowed - the scratch pad area can be resized 3. Several fixes. --------------------------------- Service Pack Level = LCD8-2010-10 Build date = October 2015 --------------------------------- The following features have been added: 1. Enhancements to the installation script for Windows so administrators can more easily customize and deploy an installation. 2. Enhancements to 5250 emulation including: - Add more raster fonts from PCOMM - Migration utility should recognize kmp & pmp file types - PDT support for DBCS 3. Several fixes including: APAR SE62629 OSP-WAIT .HOD FILE NEVER OPENS WHEN LAUNCHING AFTER .BAT FILE THAT DOES /PLUGIN=LOGON APAR SE62715 OSP-INCORROUT STICKY POPUP PAD DOES NOT SYNC WHEN CHANGED APAR SE62736 OSP-INCORROUT ACS HLLAPI PCSQUERYWORKSTATIONPROFILE RESULTS DO NOT INCLUDE PATH APAR SE62805 OSP-INCORROUT NUMERIC DATA IN ROW X, COLUMN X HAS TOO MANY DIGITS FOR THE IBM I FIELD (XXXXX). MAXIMUM VALUE WILL BE USED APAR SE62816 OSP-THREADS-UNPRED ACS 5250 EMULATOR INDENTATION ISSUE APAR SE62853 OSP-INCORROUT WHEN HOTSPOT URL 3D BUTTON IS SELECTED FILE: SHOWS AS A HOTSPOT AND OPENS WINDOWS EXPLORER. APAR SE62937 OSP-UNPRED THE FPN HOTSPOT BUTTON APPEARS IN THE MIDDLE OF A WORD -------------------------------- Service Pack Level = LCD8-2010-09 Build date = July 2015 --------------------------------- The following features have been added: 1. Installation Script for Windows 2. Enhancements to 5250 emulation including: - Change default behavior for right - Add Command+t for creating a new tab on Mac - Add FieldExit+Enter as a new keyboard Host Function 3. Several fixes including: APAR SE62296 OSP-INCORROUT STRPCCMD FAILS WHEN COMMAND HAS EMBEDDED SPACES APAR SE62313 OSP-UNPRED ERROR JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTIONSTACK SAVING SESSION WHEN LOCALE JA_JP IS SET APAR SE62333 OSP-UNPRED JAVA EXCEPTION WHEN RUNNING ACSLAUNCH_WIN-32.EXE OR ACSLAUNCH_WIN-64.EXE OVER UNC PATH. --------------------------------- Service Pack Level = LCD8-2010-08 Build date = April 2015 --------------------------------- APAR SE61488 OSP-INCORROUT KEYBOARD MAPPING NOT MIGRATED TO ACS CLIENT KMP FILE FROM IAWIN KMP FILE. APAR SE61539 OSP-INCORROUT WHEN USING THE DUP KEY FIELD PROCESSING GET AN ERROR "ENTER KEY NOT ALLOWED IN THIS FIELD". APAR SE61599 OSP-INCORROUT PROMPTED FOR SIGNON IN KERBEROS CONFIGURED HOD SESSION, AFTER DISCONNECT AND RESIGNON. APAR SE61611 OSP-INCORROUT DATA TRANSFER FILE MIGRATION FROM IAWIN TO ACS FAILS: THE FILE TYPE OF THE REQUEST IS UNSUPPORTED OR NOT VALID. APAR SE61637 OSP-INCORROUT KEYBOARD MAPPING INCORRECT KEY SHOWS UNKNOWN KEYCODE 0X0 --------------------------------- V1R1M4 GA Level = LCD8-2010-07 Build date = February 2015 --------------------------------- The following features were added for V1R1M4: 1. Several enhancements to 5250 emulation including: - tabbed sessions that share a common presentation space - save a view of multiple sessions for easy restart of multiple sessions - additional watermark customizations - ability to add user provided fonts - migration wizard for .ws profiles - support for Host Code pages: 1130, 1132, 1164 & 1377 - optional input character validation based on host code page - print emulation enhancements - additional mouse wheel customizations - cursor customization when doing a paste - additional keyboard mapping options: Character Backspace, Character Advance, APL screen attributes - maximum sessions allowed has been increased to 52 2. HMC Probe Utility for finding all partitions managed by an HMC 3. /file option added to RMTCMD allowing multiple commands 4. Easier deployment and setup for Mac and Linux 5. QuickStartGuide for Windows, Mac & Linux 6. GettingStarted reformatted in html (English only) 7. Several fixes including: APAR SE60944: OSP-UNPRED COLUMN SEPARATOR AS LINE INCORRECT WITH HCP 939 APAR SE61324 OSP-INCORROUT PC5250 .WS MIGRATED TO .HOD AND USER IS PROMPTED FOR SIGNON WHEN SESSION CONFIGURED FOR KERBEROS AUTHENTICATION. --------------------------------- Service Pack Level = LCD8-2010-06 Build date = October 2014 --------------------------------- APAR SE59743: OSP-WAIT ACS TRANSFER TO EXCEL PAUSES WHEN COMPLETE APAR SE59986: OSP-INCORROUT ACS TRANSFER TO OPEN SPREADSHEET WITH NETWORK DRIVE --------------------------------- Service Pack Level = LCD8-2010-05 Build date = July 2014 --------------------------------- APAR SE59497: UNPRED-HLIC PRINTING TO LOCAL PRINTER VIA ACS ON AN UBUNTU LINUX 14.4 SYSTEM RESULTS IN NO OUTPUT AND NO OBVIOUS ERROR APAR SE58786: OSP-MSGCPF5411-PAR-940XCOM ACS 5250 SESSION FAILS WITH CPF5411 FEEDBACK CODE 00002501 ON SCREEN WITH MORE THAN 256 INPUT FIELDS APAR SE59260: UNPRED-HLIC-94XXMISC IF ONE SESSION IS DOING A RUNQRY COMMAND, THEN ALL OTHER SESSIONS ARE LOCKED APAR SE59391: OSP-UNPRED DDS DISPLAY FILES RESPONSE INDICATOR FOR CHANGE KEYWORD REMAINS *ON AFTER THE FORMAT IS REDISPLAYED --------------------------------- Service Pack Level = LCD8-2010-04 Build date = March 2014 --------------------------------- APAR SE57901: OSP-INCORROUT TRIMRECTANGLEREMAINAFTEREDIT IS NOT SET CORRECTLY WHEN IMPORTING WORKSTATION FILE APAR SE58392: OSP-INCORROUT INCOMPLETE DATA TRANSFER USING ACCESS CLIENT SOLUTIONS WITH XLS FILE --------------------------------- Service Pack Level = LCD8-2010-03 Build date = January 2014 --------------------------------- APAR SE57584: OSP-F/QJVAUTLJVM-T/QUOCMD-RC1-MSGJVA0122 JAV0122 RC1 IS RECEIVED WHEN A USER DOES ACS DATA TRANSFER USING RUNJVA --------------------------------- Service Pack Level = LCD8-2010-02 Build date = October 2013 --------------------------------- APAR SE56526: OSP-INCORROUT ACS DATA TRANSFER UPLOAD FAILS WHEN USING FORMATTED NUMERIC FIELDS IN .XLS FORMAT APAR SE56609: OSP-UNPRED ACS SPOOL FILE IN TEXT FORMAT WONT OPEN IN GEDIT LINUX ENVIRONMENT. APAR SE56738: OSP-UNPRED WHEN ADDING A NEW BUTTON TO THE 5250 EMULATOR TOOL BAR, IT DOES NOT ALLOW THE ICON TO BE CHANGED ------------------------------------------------------------------- [END OF DOCUMENT]