Nefarious Pickle Muncher
Unleash awesomeness. Private packages, team management tools, and powerful integrations. Get started with npm Orgs »

idb-connector

1.1.7 • Public • Published

Node.js iDB Connector

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

NPM

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 {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();
    });

Example 2: Fectching data using the fetchAll() API

    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();
        });
      });
    });

Example 3: Call stored procedures

    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();
        });
      });
    });

API Reference

DB2 for i Access APIs

Change Log

View CHANGELOG.md file.

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 git@bitbucket.org: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.

install

npm i idb-connector

Downloadsweekly downloads

127

version

1.1.7

license

MIT

repository

Gitbitbucket

last publish

collaborators

  • avatar
  • avatar
  • avatar
Report a vulnerability