========
Download jt400.jar and copy in your path.
More info: http://jt400.sourceforge.net/
npm install jt400
var db = require('jt400');
var config = {
libpath: __dirname + '/jt400.jar',
drivername: 'com.ibm.as400.access.AS400JDBCDriver',
url: 'jdbc:as400://127.0.0.1/myDatabase;user=myUser;password=myPassword'
};
db.initialize(config);
db.execute('SELECT * FROM users');
db.on('execute', function(error, results){
if( error ){
console.log(error);
}
else{
console.log( results );
}
});
//INSERT and UPDATE statements must be run with executeUpdate()
db.executeUpdate("INSERT INTO users (name) VALUES ('bob')");
db.on('executeUpdate' function(error, rowCount) {
if( error ){
console.log(error);
}
else{
console.log( rowCount );
}
});
node app.js
Based on https://npmjs.org/package/jdbc