Jsharmony-db-iseries NPM

==================

jsharmony-db-iseries

==================

jsHarmony Database Connector for DB2/AS400/iSeries via ODBC

Installation

npm install jsharmony-db-iseries --save

Usage

var JSHiseries = require('jsharmony-db-iseries');
var JSHdb = require('jsharmony-db');
var dbconfig = { _driver: new JSHiseries(), connectionString: "DSN=ODBC;Uid=DBUSER;pwd=DBPASS" };
var db = new JSHdb(dbconfig);
db.Recordset('','select * from C where C_ID >= @C_ID',[JSHdb.types.BigInt],{'C_ID': 10},function(err,rslt){
  console.log(rslt);
  done();
});

Note that iseries is by default UPPERCASE; literal selects will need to use explicit aliases to get lowercase result fields c_id as "c_id".

This library uses the NPM odbc library. Use any of the connection settings available in that library.

Database specific options

Connection options

{
  _driver: ...,
  connectionString: "...",
  options: {
    metadata_filter: [],
    automatic_compound_commands: true,
    idle_timeout: 1800000,
  }
}

metadata_filter

Default: []   // No metadata will be loaded by default

Array of strings to limit database schema introspection on application startup. Currently three formats are supported:

"SCHEMA.TABLE" - Individually specified tables
"SCHEMA.%" - All tables within SCHEMA
"%.%" - All schemas, all tables

automatic_compound_commands

Default: true

If enabled, the driver will automatically wrap db.Command statements in a BEGIN...END compound statement to save network roundtrips; otherwise statements must be executed individually.