What’s in Your ODBC Driver?
Since IBM announced Yum support for installing the IBM i Db2 ODBC driver, as documented in our recent tutorial, users can update their driver more easily.
To help users determine what’s changed, IBM maintains a list of fixes and enhancements for each IBM i ODBC driver release.
IBM i ODBC driver update pages
IBM i, Mac, Linux, and Windows are given their own IBM i ODBC driver update pages:
- IBM i (PASE): https://www.ibm.com/support/pages/ibm-i-access-acs-updates-pase
- Mac: https://www.ibm.com/support/pages/ibm-i-access-acs-updates-mac
- Linux: https://www.ibm.com/support/pages/ibm-i-access-acs-updates-linux
- Windows: https://www.ibm.com/support/pages/ibm-i-access-acs-updates-windows
Two kinds of updates
The update pages (all except Windows) contain two main update sections:
- APAR Fixes: fixes based on customer support requests
- Enhancements and Internal Fixes: fixes made on the initiative of the IBM driver team
Per the IBM i Db2 ODBC driver update page, here are a few notable recent fixes and enhancements:
Notable recent enhancements
Version 1.1.0.26 (May 2022 build)
- “Add support for IBM i 7.5 PWDLVL 4”
- “Add support for IBM i 7.5 BOOLEAN SQL data type”
- “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.”
SEIDEN NOTE: The “SQL…LENGTH” enhancement fixed a bug affecting “accented” characters and other characters represented by multiple bytes in UTF-8 (CCSID 1208).
Version 1.1.0.15 (May 2021 build)
- “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.”
Thanks to IBM’s Kevin Adler for telling me about these IBM update pages.
Leave a Reply
Want to join the discussion?Feel free to contribute!