...

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

...

Limitations

• The current version of the IBM i Access ODBC driver

...

• 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.
• Installation of the odbc package beta is not as does not support calls to stored procedures with CLOB parameters.
• Installation of the odbc package is not as simple as most NPM packages. The package has to be built from source code at installation time – see below.
• 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.

...

Follow the instructions for installing necessary pre-requisites, depending on your operating system. When installing the package itself it's recommended to install the latest beta version, due to performance issues in the current release. To do that, run this command from your Profound.js installation directory instead of using the command suggested on the NPM page:

...

, depending on your operating system.

Note: The odbc package is a native add-on for Node.js, which means that it must be compiled from C++ code into a native executable on the source system. Normal releases of the odbc package install pre-built binaries. However, the beta version actually has to be built on the source system. Native add-on builds are managed by NPM, but require some additional tools to be installed on the system:

• Python
• Visual Studio C++ Compiler (Windows)
• GNU C++ compiler and GNU Make (Other platforms)GNU Make
• Python

If you get an error attempting to install the betapackage, ensure that these tools are installed/configured properly on your system.

...

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. 

...