jt400

nodejs jt400 wrapper

Configure

var jt400 = require('jt400').configure({host: 'myhost', user: 'myuser', password: 'xxx'});

SQL query

jt400.query('SELECT FIELD1, FIELD2 FROM FOO WHERE BAR=? AND BAZ=?', [1, 'a'])
.then(function (result) {
	var field1 = result[0].FIELD1;
	...
});

SQL update

jt400.update('update FOO set BAR=? WHERE BAZ=?', [1, 'a'])
.then(function (nUpdated) {
    ...
});

SQL insert

//insert list in one statement
var tableName = 'foo',
    idColumn  = 'fooid',
    rows = [
        {FIELD1: 1, FIELD2: 'a'},
        {FIELD1: 1, FIELD2: 'a'}
    ];
jt400.insertList(tableName, idColumn, rows)
.then(function (listOfGeneratedIds) {
    ...
});