All About ACS: Application Package - May 2022 の更新

# Application Package - May 2022 の更新
ODBC などプラットフォーム固有の機能を提供する ACS Application Package ですが、May 2022 の更新が提供されました。

[以前の情報](https://qiita.com/6onoda/items/4f6f478d54098ff21325)では、March 2022 の予定となってたようですが、IBM i 7.5 の発表に合わせたのでしょう。2022 年 5 月の利用可能になりました。

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

Window、Linux、Mac、PASE と4つの環境用のApplication Packageがありますが、すべて更新されています。

> **Windows Application Package last updated May 2022 (Latest Updates)**
The next available update is planned for May 2023
Features include: ODBC, .Net, and OLE DB, AFP printer driver, (Readme, More info)
ESS Service Pack Level = LCD8-2011-16
>
> **Linux Application Package last updated on May 2022 (Latest Updates)**
The next available update is planned for May 2023
Features include: ODBC, Programming Toolkit, (Readme, More info, Installation and usage guide)
ESS Service Pack Level = LCD8-2012-16
>
> **Mac Application Package last updated on May 2022 (Latest Updates)**
The next available update is planned for May 2023
Features include: ODBC, Programming Toolkit
>
> **PASE Application Package last updated on May 2022 (Latest Updates)**
The next available update is planned for May 2023
Features include: ODBC, Programming Toolkit

各々の詳細内容は、下記のリンクをご覧ください。

## Windows Application Package の更新

* [IBM i Access - ACS Updates for Windows](https://www.ibm.com/support/pages/ibm-i-access-acs-updates-windows)

修正情報以外の記載はありません。

## Linux Application Package の更新

* [IBM i Access - ACS Updates for Linux](https://www.ibm.com/support/pages/ibm-i-access-acs-updates-linux)

```
Version: 1.1.0.26
Build Date = May 2022
---------------------------------
- Unify version number with IBM i Access Client Solutions Windows Application
  Package
- Add support for IBM i 7.5 PWDLVL 4
- Add support for IBM i 7.5 BOOLEAN SQL data type
- Add support for SQL_ATTR_CONNECTION_TIMEOUT and proper support for
  SQL_ATTR_LOGIN_TIMEOUT. In addition, cwbcopwr can be used to set send and
  receive socket timeouts.
- Add cwbcopwr utility
- SQL_DESC_OCTET_LENGTH and SQL_DESC_DISPLAY_LENGTH now take in to account any
  expansion that might occur due to CCSID conversion. For instance, a CHAR(10)
  EBCDIC column will now return 20 instead of 10 for the above attributes when
  the client is in UTF-8 since extended ASCII characters take 2 bytes in UTF-8
  but only 1 byte in EBCDIC. This allows retrieving the full column data in
  PHP's odbc and pdo_odbc extensions, especially on IBM i 7.4 and beyond where
  the default PASE CCSID is 1208.
- Fix bug on big endian systems where error message text would be blank in some
  cases
- Fix getaddrinfo error reporting on macOS and PASE systems. These
  were not being mapped correctly, giving odd error messages.  For example:
  "rc=8 - CWB0008 - Insufficient personal computer resources" instead of 
  "rc=11001 - CWBCO1004 - Remote address could not be resolved"
- Allow SQL_ATTR_ROW_ARRAY_SIZE to change after data has been (pre-)fetched.
- Remove duplicate DBCLOB() CCSID 13488 row returned by SQLGetTypeInfo when
  called with SQL_ALL_TYPES
```
いろいろ書いてありますね。

Version が 1.1.0.26 になっています。これは Windows Application Package と合わせました。
**IBM i 7.5 の新機能に対応しました。**
cwbcopwr ユーティリティが用意され、タイムアウトの設定が可能になりました。
cwbcopwr ユーティリティは、以前の Access for Linux で用意されていたユーティリティです。
**SQL_DESC_OCTET_LENGTH と SQL_DESC_DISPLAY_LENGTH が CCSID 変換を考慮した長さを返すようになりました。**
など、いろいろな拡張がされているようです。

## Mac Application Package の更新

* [IBM i Access - ACS Updates for Mac](https://www.ibm.com/support/pages/ibm-i-access-acs-updates-mac)

```
This service pack is supported on all Intel and Apple Silicon Macs running macOS Catalina (10.15) and newer.
```

サポート対象に「Apple Silicon Macs」が含まれています。いわゆる **M1 Mac がサポート**されるようです。

```
---------------------------------
Version: 1.1.0.26
Build Date = May 2022
---------------------------------
- Unify version number with IBM i Access Client Solutions Windows Application
  Package
- Add support for IBM i 7.5 PWDLVL 4
- Add support for IBM i 7.5 BOOLEAN SQL data type
- Add support for SQL_ATTR_CONNECTION_TIMEOUT and proper support for
  SQL_ATTR_LOGIN_TIMEOUT. In addition, cwbcopwr can be used to set send and
  receive socket timeouts.
- Add cwbcopwr utility
- SQL_DESC_OCTET_LENGTH and SQL_DESC_DISPLAY_LENGTH now take in to account any
  expansion that might occur due to CCSID conversion. For instance, a CHAR(10)
  EBCDIC column will now return 20 instead of 10 for the above attributes when
  the client is in UTF-8 since extended ASCII characters take 2 bytes in UTF-8
  but only 1 byte in EBCDIC. This allows retrieving the full column data in
  PHP's odbc and pdo_odbc extensions, especially on IBM i 7.4 and beyond where
  the default PASE CCSID is 1208.
- Fix bug on big endian systems where error message text would be blank in some
  cases
- Fix getaddrinfo error reporting on macOS and PASE systems. These
  were not being mapped correctly, giving odd error messages.  For example:
  "rc=8 - CWB0008 - Insufficient personal computer resources" instead of 
  "rc=11001 - CWBCO1004 - Remote address could not be resolved"
- Allow SQL_ATTR_ROW_ARRAY_SIZE to change after data has been (pre-)fetched.
- Remove duplicate DBCLOB() CC
```

更新リストは Linux 版と同じですね。

## PASE Application Package の更新

* [IBM i Access - ACS Updates for PASE](https://www.ibm.com/support/pages/ibm-i-access-acs-updates-pase)

```
This service pack is supported on IBM i 7.3 and later.
```

**PASE 版は 7.3 以降で稼働します。**
EOS になった 7.2 まででは稼働しないので注意が必要です。

```
Version: 1.1.0.26
Build Date = May 2022
---------------------------------
- Unify version number with IBM i Access Client Solutions Windows Application
  Package
- Add support for IBM i 7.5 PWDLVL 4
- Add support for IBM i 7.5 BOOLEAN SQL data type
- Add support for SQL_ATTR_CONNECTION_TIMEOUT and proper support for
  SQL_ATTR_LOGIN_TIMEOUT. In addition, cwbcopwr can be used to set send and
  receive socket timeouts.
- Add cwbcopwr utility
- SQL_DESC_OCTET_LENGTH and SQL_DESC_DISPLAY_LENGTH now take in to account any
  expansion that might occur due to CCSID conversion. For instance, a CHAR(10)
  EBCDIC column will now return 20 instead of 10 for the above attributes when
  the client is in UTF-8 since extended ASCII characters take 2 bytes in UTF-8
  but only 1 byte in EBCDIC. This allows retrieving the full column data in
  PHP's odbc and pdo_odbc extensions, especially on IBM i 7.4 and beyond where
  the default PASE CCSID is 1208.
- Fix bug on big endian systems where error message text would be blank in some
  cases
- Fix getaddrinfo error reporting on macOS and PASE systems. These
  were not being mapped correctly, giving odd error messages.  For example:
  "rc=8 - CWB0008 - Insufficient personal computer resources" instead of 
  "rc=11001 - CWBCO1004 - Remote address could not be resolved"
- Allow SQL_ATTR_ROW_ARRAY_SIZE to change after data has been (pre-)fetched.
- Remove duplicate DBCLOB() CCSID 13488 row returned by SQLGetTypeInfo when
  called with SQL_ALL_TYPES
```

拡張の記述は Linux 版、Mac 版と共通です。

## 入手先

4 種類プラットフォームに応じた Application Package が下記からダウンロード可能です。
ただし、Windows Application Package は、英語 64 ビット版のみです。

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

32 ビット版の Windows Application Package や日本語版が必要な場合(英語版でも ODBC 登録画面が英語になるだけで、日本語データ処理には問題ないのですが)は「[ESSからダウンロード](https://qiita.com/6onoda/items/dfac8d44e791801e49fe)」してください。


## 次回は May 2023
Application Package の次回の更新は May 2023 が予定されています。

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

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