idb-connector

Node.js iDB Connector

The Node.js iDB Connector is a Node.js DB2 driver open source project from IBM.

Installation

npm i idb-connector

Then you can require in your code, as shown below.

    const db = require('idb-connector');

Quick Example

Example 1: Fectching data using the exec() API

    const db = require('idb-connector');
    const sSql = 'SELECT STATE FROM QIWS.QCUSTCDT';
    const dbconn = new db.dbconn();
    dbconn.conn("*LOCAL");
    const stmt = new db.dbstmt(dbconn);

    stmt.exec(sSql, (x) => {
      console.log("%s", JSON.stringify(x));
      stmt.close();
      dbconn.disconn();
      dbconn.close();
    });

Example 2: Fectching data using the fetchAll() API

    const db = require('idb-connector');
    const sSql = 'SELECT STATE FROM QIWS.QCUSTCDT';
    const dbconn = new db.dbconn();
    dbconn.conn("*LOCAL");
    const stmt = new db.dbstmt(dbconn);

    stmt.prepare(sSql, () => {
      stmt.execute(() => {
        stmt.fetchAll((x) => { 
          console.log("%s", JSON.stringify(x));
          stmt.close();
        });
      });
    });

Example 3: Call stored procedures

    const db = require('idb-connector');
    const sql = "CALL QXMLSERV.iPLUG512K(?,?,?,?)";
    const dbconn = new db.dbconn();
    dbconn.conn("*LOCAL");
    const stmt = new db.dbstmt(dbconn);

    const ipc = "*NA";
    const ctl = "*here";
    const xmlIn = "<xmlservice><sh>system 'wrksbs'</sh></xmlservice>";
    const xmlOut = "";
    
    stmt.prepare(sql, () => {
      stmt.bindParam([
        [ipc, db.SQL_PARAM_INPUT, db.BIND_STRING],
        [ctl, db.SQL_PARAM_INPUT, db.BIND_STRING],
        [xmlIn, db.SQL_PARAM_INPUT, db.BIND_CLOB],
        [xmlOut, db.SQL_PARAM_OUTPUT, db.BIND_CLOB]
      ], () => {
        stmt.execute((out) => { // 'out' is an array of output params
          for(let i = 0; i < out.length; i++)
            console.log(out[i]);
          stmt.close();
          dbconn.disconn();
          dbconn.close();
        });
      });
    });

API Reference

DeveloperWorks

Build

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 [e-mail]:litmis/nodejs-idb-connector.git
    cd nodejs-idb-connector
    npm install --build-from-source

Note: Gcc and python are required to compile the code.

License

MIT. View LICENSE file.

Changelog

1.1.5

• Refined docs and trace for scrollable cursor
• Added a new API stmt.getStmtDiag() as alias of stmt.stmtError()
• Added CHANGLOG.md
• Made buffer bigger for some unicode characters