Application Package - May 2022 の更新

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

以前の情報では、March 2022 の予定となってたようですが、IBM i 7.5 の発表に合わせたのでしょう。2022 年 5 月の利用可能になりました。

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

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

Linux Application Package の更新

IBM i Access - ACS Updates for 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

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

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

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

次回は May 2023

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

2022-06-01 作成

「All About ACS」では IBM i に対する新しいクライアント「IBM i Access Client Solutions」の情報をいろいろ提供していきます。
記事一覧はこちらで確認いたけます。

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

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