...

The "odbc" driver does not allow non-SQL APIs (such as for direct program/procedure call, CL command, etc.) to run against the target system.

Known Issues

There are a few known issues in the odbc package and IBM i Access ODBC driver that affect Profound.js:

• The current beta version of the odbc package has a bug where the first character of any Unicode result column is lost.
• The current beta version of the odbc package has a bug where errors are not reported/handled properly when problems occur while establishing a connection (such as bad password, etc.). This can make it difficult to troubleshoot connection issues.
• The current version of the IBM i Access ODBC driver does not support calls to stored procedures with CLOB parameters.

Installation

The "odbc" driver utilizes 3 different components that need to be installed on the 'source' system only. Meaning, the system where you are running Profound.js and want to connect to IBM i.

...

An IBM account is required to access the downloads. Click on Downloads for IBM i Access Client Solutions, accept the license agreement, and use the ACS App Pkg link for the appropriate source operating system. For IBM i, use ACS PASE App Pkg. Installation instructions are included in each download package.

The IBM i version of the Application package installs via the open-source package manager "yum". See here for instructions on setting up yum on IBM i:

https://www.ibm.com/support/pages/node/706903

For Application Package installers for 32-bit Windows or languages other than English, visit the IBM ESS Website. 

...