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

Last updated at 2022-06-01Posted at 2022-06-01

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やビジネスパートナーに問い合わせることは、固くお断りします。

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up