All About ACS: IBM i Access Client Solutions 1.1.8.7 利用可能

# IBM i Access Client Solutions 1.1.8.7 利用可能

予定通り、2021 年 04 月にACS 1.1.8.7 が利用可能になりました。
今回も、日本語処理特有の拡張は見られませんでした。

---

## 情報のリンク

ACS の情報を見るページをまとめておきます。

メインのページです。
[IBM i Access - Client Solutions](https://www.ibm.com/support/pages/ibm-i-access-client-solutions)

詳細のページです。最新バージョンの情報なとも載っています。

[IBM i Access - Client Solutions 5733XJ1](https://www.ibm.com/support/pages/ibm-i-access-client-solutions-5733xj1)

1.1.8.7 の情報に更新されていました。

>Base package last updated April 2021 version 1.1.8.7 (Latest Updates)
>
The next available update is planned for August 2021
>
ESS Service Pack Level = LCD8-2010-27
>
The current version of IBM i Access Client Solutions (as viewed from the main GUI by selecting Help ➜ About):
>
Version: 1.1.8.7
>
Build id: 1100
>
2021-04-12

ダウンロードと詳細情報はこちらです。
最近のブラウザーでは、ftp:// が開けなくなっているので、https:// で開けるようになっていますね。

* Download IBM i Access Client Solutions
https://www-01.ibm.com/marketing/iwm/platform/mrs/assets?source=swg-ia

* QuickStartGuide
https://www.ibm.com/support/pages/ibm-i-access-acs-quick-start-guide

* GettingStarted
https://www.ibm.com/support/pages/ibm-i-access-acs-getting-started

* Latest Updates (readmespacs)
https://www.ibm.com/support/pages/ibm-i-access-acs-updates

## 更新内容

更新内容は、上記の Latest Updates で確認できます。

### 機能拡張

>
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 combines 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)

### 修正・APAR

修正・APAR 一覧はこちら。

> 
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


## 

***
2021-04-19 作成
***
「All About ACS」では IBM i に対する新しいクライアント「IBM i Access Client Solutions」の情報をいろいろ提供していきます。
[記事一覧はこちら](http://qiita.com/6onoda/items/2dc925586d8d3b8644f2)で確認いたけます。

許可の無い転載を禁じます。
この記事は筆者の個人的な責任で無保証で提供しています。
当記事に関してIBMやビジネスパートナーに問い合わせることは、固くお断りします。
***