IBM i Access - ACS Updates for PASE

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.

-----------------
Table of Contents
-----------------
1.0 INSTALLATION INSTRUCTIONS
  1.1 SUPPORTED ENVIRONMENTS
  1.2 PREREQUISITES
  1.3 INSTALLING
2.0 RECOMMENDATIONS/RESTRICTIONS
  2.1 IBM i SERVER FIXES

3.0  KNOWN ISSUE (APAR) ABSTRACTS
  - SERVICE PACK LEVEL = 1.1.0.28 (May 2024)

  - SERVICE PACK LEVEL = 1.1.0.27 (November 2022)

3.0  KNOWN ISSUE (APAR) ABSTRACTS
--------------------------------------------------------
   This a list of Known Issue (APAR) fixes included in this service pack. Each service pack is cumulative. The current service pack includes all the fixes from the prior service pack levels.

---------------------------------
Version: 1.1.0.28
Build Date = May 2024
---------------------------------

---------------------------------
Version: 1.1.0.27
Build Date = November 2022
---------------------------------

---------------------------------
Version: 1.1.0.26
Build Date = May 2022
---------------------------------

---------------------------------
Version: 1.1.0.15
Build Date = May 2021
---------------------------------

---------------------------------

Version: 1.1.0.27
Build Date = November 2022
---------------------------------

- Add TLS (SSL) support using OpenSSL. This requires that the OpenSSL libraries provided by yum are installed, eg libopenssl1_1. OpenSSL version 1.1.1 is supported. Unlike with GSKit on Windows, FIPS mode is not supported.
- Add EnableKeepAlive connection string keyword to enable TCP keepalive support as an alternative to using cwbcopwr. Setting to 0 disables keepalives, 1 enables keepalives, and 2 uses the cwbcopwr value (default).
- Add Timeout connection string keyword to set the socket timeout (in seconds) when communicating with the server. This is an alternative to using the SQL_ATTR_CONNECTION_TIMEOUT connection attribute or cwbcopwr.
- Add LoginTimeout connection string keyword to set the connection timeout (in seconds) when initially connecting and logging in to the server. This is an alternative to using the SQL_ATTR_LOGIN_TIMEOUT connection attribute.
- Fix handling of QueryStorageLimit=*NOMAX. Previously, this would get interpreted as if 0 had been specified.

---------------------------------
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.15
Build Date = May 2021
---------------------------------

- Implement the current_date, current_time, current_timestamp, timestampadd, and timestampdiff ODBC scalar function escape sequences. For more details, refer to the following ODBC documents:
    https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/scalar-function-calls
    https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/time-date-and-interval-functions
- Add TrimCharFields connection option to trim trailing blank characters when retrieving CHAR and GRAPHIC fields. Setting this option to 1 will enable trimming, while setting it to 0 (default) will disable trimming.
- Add AlwaysCalculateResultLength connection option. Setting this option to 1 will prevent the driver from returning SQL_NO_TOTAL, while setting it to 0 (default) will allow the driver to return SQL_NO_TOTAL. Some applications do not expect SQL_NO_TOTAL (-4) and treat it as the actual length, causing problems. Note that calculating the actual result length can require repeated character conversion, so for performance reasons it's advised to not enable this feature unless absolutely necessary.