IBM Support

IBM i Access - ACS Updates

General Page

============================================================================
                       IBM i Access Client Solutions        
                   5733-XJ1 Cumulative Service Pack Level             
                               -------------                
                                LCD8-2010-27
                               -------------
        (c) Copyright IBM Corporation 2021.  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 SUPPORTAGREEMENT, 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


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 will 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


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.
         
 

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSB2FY","label":"IBM i Access Family"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 April 2021

UID

ibm16435227