IBM Support

ODBC driver for the IBM i PASE environment

How To


Summary

The 64-bit ODBC driver for the IBM i PASE environment is now available.

Objective

This driver will allow applications making 64-bit ODBC API calls to access DB2 for IBM i

Environment

PASE and QSH environments on the IBM i

Steps

The 64-bit ODBC driver for the IBM i PASE environment is available at the main IBM Access Client Solutions page.
The download is named "IBMiAccess_v1r1_PASE_AP.zip"
Within the .zip archive is an rpm which can be installed with (version numbers may have changed):
      $ yum install ibm-iaccess-1.1.0.14-0.ibmi7.2.ppc64.rpm
Note that the driver package has dependencies on open source packages:
  • GNU C Library
  • Red Hat Package Manager (rpm)
  •  unixODBC   - Execute "odbcinst -j" to view configuration details
For details regarding installing open source packages on the IBM i, please see:
Getting started with Open Source Package Management in IBM i ACS
Create a test .odbc.ini file:
marquis@RCH730B:~$ cat .odbc.ini
[rch730b]
Description             = IBM i Access ODBC Driver 64-bit
Driver                  = IBM i Access ODBC Driver
System                  = rch730b
UserID                  = MyIBMiUSRPRF
Password                =
Naming                  = 0
DefaultLibraries        = QGPL
Database                =
ConnectionType          = 0
CommitMode              = 2
ExtendedDynamic         = 1
DefaultPkgLibrary       = QGPL
DefaultPackage          = A/DEFAULT(IBM),2,0,1,0,512
AllowDataCompression    = 1
MaxFieldLength          = 32
BlockFetch              = 1
BlockSizeKB             = 128
ExtendedColInfo         = 0
LibraryView             = ENU
AllowUnsupportedChar    = 0
ForceTranslation        = 0
Trace                   = 0
marquis@RCH730B:~$
Test the ODBC connection using the "isql" tool which is part of the unixODBC product:
$ isql <ODBC_DSN_NAME> <myIBMiUSRPRF> <myIBMiPASSWD>
...and then a simple SQL statement such as "select * from qiws.qcustcdt":
image-20190528121231-1

Additional Information

Note that this driver is 64-bit only and the driver name has changed from the name used in the Linux driver:
IBM i Access ODBC Driver 64-bit
...to:
IBM i Access ODBC Driver
64-bit odbc.ini DSNs from the Linux product (and DSN-less connections) will need to be updated to reflect the new name.
This product shares many similarities with the IBM i Access Client Solutions - Application Package for Linux and the same utilities (cwbmedic,  cwbping, and cwbtrc) are available within directory /QOpenSys/pkgs/bin/ . View the complete file list with:
$ rpm -qlp ibm-iaccess*.ppc64.rpm
 
Please see the related URLs below for configuration and diagnostic details.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB08","label":"Cognitive Systems"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0"}]

Document Information

Modified date:
05 July 2021

UID

ibm10885929