npm i idb-connector
Then you can require in your code, as shown below.
const db = require('idb-connector');
const {dbconn, dbstmt} = require('idb-connector');
const sSql = 'SELECT STATE FROM QIWS.QCUSTCDT';
const connection = new dbconn();
connection.conn("*LOCAL");
const statement = new dbstmt(connection);
statement.exec(sSql, (x) => {
console.log("%s", JSON.stringify(x));
statement.close();
connection.disconn();
connection.close();
});
const {dbconn, dbstmt} = require('idb-connector');
const sSql = 'SELECT STATE FROM QIWS.QCUSTCDT';
const connection = new dbconn();
connection.conn("*LOCAL");
const statement = new dbstmt(connection);
statement.prepare(sSql, () => {
statement.execute(() => {
statement.fetchAll((x) => {
console.log("%s", JSON.stringify(x));
statement.close();
});
});
});
const idb = require('idb-connector'),
{dbconn, dbstmt, IN, OUT, CHAR, CLOB} = idb;
const sql = "CALL QXMLSERV.iPLUG512K(?,?,?,?)";
const connection = new dbconn();
connection.conn("*LOCAL");
const statement = new dbstmt(connection);
const ipc = "*NA";
const ctl = "*here";
const xmlIn = "<xmlservice><sh>system 'wrksbs'</sh></xmlservice>";
const xmlOut = "";
statement.prepare(sql, () => {
statement.bindParam([
[ipc, IN, CHAR],
[ctl, IN, CHAR],
[xmlIn, IN, CLOB],
[xmlOut, OUT, CLOB]
], () => {
statement.execute((out) => { // 'out' is an array of output params
for(let i = 0; i < out.length; i++)
console.log(out[i]);
statement.close();
connection.disconn();
connection.close();
});
});
});
View CHANGELOG.md
file.
Note that building isn't necessary for end users and is more for developers looking to compile the native Node.js extensions (C code).
git clone git@github.com:IBM/nodejs-idb-connector.git
cd nodejs-idb-connector
npm install --build-from-source
Note: Gcc and python are required to compile the code.
MIT. View LICENSE
file.