| Info |
|---|
Support for ODBC was added in Profound.js 5.3.0. |
...
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.
...
| Code Block | ||
|---|---|---|
| ||
"databaseConnections": [
{
"name": "myIBMi",
"driver": "odbc",
"type": "db2i",
"credentialsFile": `${__dirname}/credentials`,
"driverOptions": {
"connectionString": "driverDRIVER=IBM i Access ODBC Driver;systemSYSTEM=myIBMi;namNAM=1;cmtCMT=0;unicodesqlUNICODESQL=1;tsftTSFT=1;dbqDBQ=,MYLIB,MYLIB2,MYLIB3",
"initialSize": 10,
"maxSize": 10,
"shrink": false
}
}
] |
...
For example, in the above configuration the library list is set to "MYLIB MYLIB2 MYLIB3" with no default schema, using the "dbq" connecting string option, and commitment control is disabled via the "cmt" option. The following settings are required by Profound.js and should be set on all connections:
| Option | Required Value |
|---|---|
| namNAM | 1 |
| unicodesqlUNICODESQL | 1 |
| tsftTSFT | 1 |
Creating a Credentials File
...
The credentials file is decrypted when the Profound.js server starts, and the user id and password are appended to the end of the "connectionString" like this:
| Code Block |
|---|
;uidUID={decrypted_userid};pwdPWD={decrypted_password}; |
When using this option, specify the "connectionString" without the "uidUID" and "pwdPWD" options.
Using ODBC Data Sources (optional)
...
| Code Block | ||
|---|---|---|
| ||
"databaseConnections": [
{
"name": "myIBMi",
"driver": "odbc",
"type": "db2i",
"credentialsFile": `${__dirname}/credentials`,
"driverOptions": {
"connectionString": "DSN=DATA_SOURCE_NAME;dbqDBQ=,DATALIB1,DATALIB2",
}
}
] |
...
| Code Block |
|---|
"databaseConnections": [
{
"name": "myIBMi",
"driver": "odbc",
"type": "db2i",
"credentialsFile": `${__dirname}/credentials`,
"driverOptions": {
"connectionString": "FILEDSN=DATA_SOURCE_NAME;dbqDBQ=,DATALIB1,DATALIB2",
}
}
] |
...