{"_id":"loopback-connector-db2iseries","_rev":"53-a98cc7fe78e20c519a633e52907243eb","name":"loopback-connector-db2iseries","dist-tags":{"latest":"3.0.0"},"versions":{"1.0.1":{"name":"loopback-connector-db2iseries","version":"1.0.1","keywords":["IBM","StrongLoop","LoopBack","DB2","DataSource","Connector","iSeries"],"license":"Artistic-2.0","_id":"loopback-connector-db2iseries@1.0.1","maintainers":[{"name":"qpresley","email":"qpresley@ca.ibm.com"}],"homepage":"https://github.com/strongloop/loopback-connector-db2iseries","bugs":{"url":"https://github.com/strongloop/loopback-connector-db2iseries/issues"},"dist":{"shasum":"ecd5b4f4d12d905d98a18ed7268903fa6bc8fd41","tarball":"https://registry.npmjs.org/loopback-connector-db2iseries/-/loopback-connector-db2iseries-1.0.1.tgz","integrity":"sha512-HsTKtQBunbLlBZVTnC0Op/ozc9R48MTkmVquYNwTjIoThRDKOZkeKmJAnFJQPRF1Rp1CxGPTDU3W05WWh1nM8g==","signatures":[{"sig":"MEYCIQCgdMpAcMwiDRiHyilVHY7TrBeS11y//nDt+qF2KRKmjQIhAKYLUtohhlLC//UMEPvmT/oC81XpBhwueQKhPsutK6gr","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"ecd5b4f4d12d905d98a18ed7268903fa6bc8fd41","gitHead":"eb9b8b473cc058af13da3ba05bfb4f17f89c3a11","scripts":{"lint":"eslint ./ && jscs ./","test":"mocha --timeout 15000","pretest":"eslint ./ && jscs ./"},"_npmUser":{"name":"qpresley","email":"qpresley@ca.ibm.com"},"repository":{"url":"git://github.com/strongloop/loopback-connector-db2iseries.git","type":"git"},"_npmVersion":"2.15.9","description":"LoopBack Connector for IBM DB2 iSeries","directories":{},"_nodeVersion":"4.5.0","dependencies":{"async":"^1.5.0","debug":"^2.2.0","loopback-ibmdb":"^1.0.0","loopback-connector":"^2.3.0"},"devDependencies":{"rc":"^1.1.5","jscs":"^2.8.0","mocha":"^2.3.4","sinon":"^1.17.2","eslint":"^1.10.3","should":"^8.1.1","bluebird":"^2.9.9","eslint-config-strongloop":"^1.0.2","loopback-datasource-juggler":"^2.43.0"},"_npmOperationalInternal":{"tmp":"tmp/loopback-connector-db2iseries-1.0.1.tgz_1471641406842_0.7816345968749374","host":"packages-16-east.internal.npmjs.com"}},"1.0.2":{"name":"loopback-connector-db2iseries","version":"1.0.2","keywords":["IBM","StrongLoop","LoopBack","DB2","DataSource","Connector","iSeries"],"license":"Artistic-2.0","_id":"loopback-connector-db2iseries@1.0.2","maintainers":[{"name":"0candy","email":"ngcandy@ca.ibm.com"},{"name":"amir-61","email":"amirali.jfr61@gmail.com"},{"name":"bajtos","email":"mbajtoss@gmail.com"},{"name":"ibmcloud-admin","email":"rmg@ca.ibm.com"},{"name":"qpresley","email":"qpresley@ca.ibm.com"},{"name":"rfeng","email":"enjoyjava@gmail.com"},{"name":"richardpringle","email":"rpring9@gmail.com"},{"name":"ritch","email":"skawful@gmail.com"},{"name":"rmg","email":"r.m.graham@gmail.com"},{"name":"superkhau","email":"superkhau@gmail.com"},{"name":"tonyf-ibm","email":"tffrench@us.ibm.com"}],"homepage":"https://github.com/strongloop/loopback-connector-db2iseries","bugs":{"url":"https://github.com/strongloop/loopback-connector-db2iseries/issues"},"dist":{"shasum":"e42943b6bdf2c551b53aca9f725a551b59d57f87","tarball":"https://registry.npmjs.org/loopback-connector-db2iseries/-/loopback-connector-db2iseries-1.0.2.tgz","integrity":"sha512-58kJJIAQsvvhLyINBBq27k9mTUy/j9QShfge9nvNK76TahTmdg63xji3x5bczMyO6UcHSuM2AEBazTq4sYbWbg==","signatures":[{"sig":"MEUCIDyjPxhRldtsCYrrVdMgyjmVARCHoMVKVfKAHoO2KP9NAiEA5Ty7HxfBDU+HeX+tBtbneKzh09SMOdkj7ciMVTka4iA=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"e42943b6bdf2c551b53aca9f725a551b59d57f87","gitHead":"5d6687d5d94e83062885629bce4fa33f8dbc4dfb","scripts":{"lint":"eslint .","test":"mocha --timeout 15000","posttest":"npm run lint"},"_npmUser":{"name":"qpresley","email":"qpresley@ca.ibm.com"},"repository":{"url":"git://github.com/strongloop/loopback-connector-db2iseries.git","type":"git"},"_npmVersion":"2.15.9","description":"LoopBack Connector for IBM DB2 iSeries","directories":{},"_nodeVersion":"4.5.0","dependencies":{"async":"^1.5.0","debug":"^2.2.0","loopback-ibmdb":"^1.0.0","loopback-connector":"^2.3.0"},"devDependencies":{"rc":"^1.1.5","mocha":"^2.3.4","sinon":"^1.17.2","eslint":"^2.13.1","should":"^8.1.1","bluebird":"^2.9.9","eslint-config-loopback":"^4.0.0","loopback-datasource-juggler":"^2.43.0"},"_npmOperationalInternal":{"tmp":"tmp/loopback-connector-db2iseries-1.0.2.tgz_1478181104607_0.05024769459851086","host":"packages-18-east.internal.npmjs.com"}},"3.0.0":{"name":"loopback-connector-db2iseries","version":"3.0.0","keywords":["IBM","StrongLoop","LoopBack","DB2","DataSource","Connector","iSeries"],"license":"Artistic-2.0","_id":"loopback-connector-db2iseries@3.0.0","maintainers":[{"name":"rashmihunt","email":"rashmihunt@gmail.com"},{"name":"kjdelisle","email":"kjdelisle@gmail.com"},{"name":"hacksparrow","email":"captain@hacksparrow.com"},{"name":"thegman","email":"gpandya@live.com"},{"name":"jannyhou2016","email":"juehou@ca.ibm.com"},{"name":"davidcheung","email":"davidcheung@live.ca"},{"name":"loay","email":"gewily@ca.ibm.com"},{"name":"ibmcloud-admin","email":"rmg@ca.ibm.com"},{"name":"0candy","email":"ngcandy@ca.ibm.com"},{"name":"amir-61","email":"amirali.jfr61@gmail.com"},{"name":"tonyf-ibm","email":"tffrench@us.ibm.com"},{"name":"rmg","email":"r.m.graham@gmail.com"},{"name":"superkhau","email":"superkhau@gmail.com"},{"name":"bajtos","email":"mbajtoss@gmail.com"},{"name":"ritch","email":"skawful@gmail.com"},{"name":"rfeng","email":"enjoyjava@gmail.com"},{"name":"qpresley","email":"qpresley@ca.ibm.com"}],"homepage":"https://github.com/strongloop/loopback-connector-db2iseries","bugs":{"url":"https://github.com/strongloop/loopback-connector-db2iseries/issues"},"dist":{"shasum":"9123945665d7114657ab5acf2c5c5829d565e406","tarball":"https://registry.npmjs.org/loopback-connector-db2iseries/-/loopback-connector-db2iseries-3.0.0.tgz","integrity":"sha512-lD9gouP/xQ8Rnw+CSvfS0iu/gy6Y2Xy6FXWb4rTovNFHsfiNpkIxLmMqvgkAguhc5/wjLjdtleGKns6Su54/9A==","signatures":[{"sig":"MEYCIQC2Ijv8N39pi4w0/g8OEroa6JRLD+clKg3nNe2/jUKwqwIhAKyYXSn46L7NOuGAaoxtwAWnSH5EIAyeeWGzsIFACHkE","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"9123945665d7114657ab5acf2c5c5829d565e406","engines":{"node":">=4"},"gitHead":"d107afaa645dfd35497eafae7ec0a4110be068a0","scripts":{"lint":"eslint .","test":"mocha --timeout 15000 --require test/init.js","posttest":"npm run lint"},"_npmUser":{"name":"kjdelisle","email":"kjdelisle@gmail.com"},"repository":{"url":"git://github.com/strongloop/loopback-connector-db2iseries.git","type":"git"},"_npmVersion":"3.10.10","description":"LoopBack Connector for IBM DB2 iSeries","directories":{},"_nodeVersion":"6.9.5","dependencies":{"async":"^1.5.0","debug":"^2.2.0","loopback-ibmdb":"^2.0.0","strong-globalize":"^2.8.2","loopback-connector":"^4.0.0"},"devDependencies":{"rc":"^1.1.5","mocha":"^2.3.4","sinon":"^1.17.2","eslint":"^2.13.1","should":"^8.1.1","bluebird":"^2.9.9","eslint-config-loopback":"^4.0.0","loopback-datasource-juggler":"^2.43.0"},"_npmOperationalInternal":{"tmp":"tmp/loopback-connector-db2iseries-3.0.0.tgz_1498156034114_0.13328094617463648","host":"s3://npm-registry-packages"}}},"time":{"created":"2016-08-19T21:16:48.071Z","modified":"2024-07-09T12:43:14.117Z","1.0.1":"2016-08-19T21:16:48.071Z","1.0.2":"2016-11-03T13:51:46.455Z","3.0.0":"2017-06-22T18:27:15.224Z"},"bugs":{"url":"https://github.com/strongloop/loopback-connector-db2iseries/issues"},"license":"Artistic-2.0","homepage":"https://github.com/strongloop/loopback-connector-db2iseries","keywords":["IBM","StrongLoop","LoopBack","DB2","DataSource","Connector","iSeries"],"repository":{"url":"git://github.com/strongloop/loopback-connector-db2iseries.git","type":"git"},"description":"LoopBack Connector for IBM DB2 iSeries","maintainers":[{"email":"enjoyjava@gmail.com","name":"rfeng"},{"email":"r.m.graham@gmail.com","name":"rmg"},{"email":"dianahmlau@gmail.com","name":"dhmlau"},{"email":"jgorzinski@gmail.com","name":"theprez"},{"email":"qpresley@ca.ibm.com","name":"qpresley"}],"readme":"# loopback-connector-db2iseries\n\n[IBM® DB2® for iSeries](http://www-03.ibm.com/systems/power/software/i/db2/) is the database of choice for robust, enterprise-wide solutions handling high-volume workloads.\nIt is optimized to deliver industry-leading performance while lowering costs. The `loopback-connector-db2iseries`\nmodule is the LoopBack connector for DB2 for iSeries.\n\nThe LoopBack DB2 for iSeries connector supports:\n\n- All [create, retrieve, update, and delete operations](http://loopback.io/doc/en/lb2/Creating-updating-and-deleting-data.html).\n- [Queries](http://loopback.io/doc/en/lb2/Querying-data.html) with fields, limit, order, skip and where filters.\n\n## Installation\n\nEnter the following in the top-level directory of your LoopBack application:\n\n```\n$ npm install loopback-connector-db2iseries --save\n```\n\nThe `--save` option adds the dependency to the application's `package.json` file.\n\n## Configuration\n\nUse the [data source generator](http://loopback.io/doc/en/lb2/Data-source-generator.html) to add the DB2 for iSeries data source to your application.\nThe entry in the application's `server/datasources.json` will look something like this:\n\n```js\n\"mydb\": {\n \"name\": \"mydb\",\n \"connector\": \"db2iseries\"\n}\n```\n\nEdit `server/datasources.json` to add other supported properties as required:\n\n```js\n\"mydb\": {\n \"name\": \"mydb\",\n \"connector\": \"db2iseries\",\n \"username\": ,\n \"password\": ,\n \"database\": ,\n \"hostname\": ,\n \"port\": \n}\n```\n\nThe following table describes the connector properties.\n\nProperty          | Type   | Description\n---------------| --------| --------\ndatabase | String | Database name\nschema | String | Specifies the default schema name that is used to qualify unqualified database objects in dynamically prepared SQL statements. The value of this property sets the value in the CURRENT SCHEMA special register on the database server. The schema name is case-sensitive, and must be specified in uppercase characters\nusername | String | DB2 Username\npassword | String | DB2 password associated with the username above\nhostname | String | DB2 server hostname or IP address\nport | String | DB2 server TCP port number\nuseLimitOffset | Boolean | LIMIT and OFFSET must be configured on the DB2 server before use (compatibility mode)\nsupportDashDB | Boolean | Create ROW ORGANIZED tables to support dashDB.\n\n\nAlternatively, you can create and configure the data source in JavaScript code.\nFor example:\n\n```js\nvar DataSource = require('loopback-datasource-juggler').DataSource;\nvar DB2 = require('loopback-connector-db2iseries');\n\nvar config = {\n username: process.env.DB2_USERNAME,\n password: process.env.DB2_PASSWORD,\n hostname: process.env.DB2_HOSTNAME,\n port: 50000,\n database: 'SQLDB',\n};\n\nvar db = new DataSource(DB2, config);\n\nvar User = db.define('User', {\n name: { type: String },\n email: { type: String },\n});\n\ndb.autoupdate('User', function(err) {\n if (err) {\n console.log(err);\n return;\n }\n\n User.create({\n name: 'Tony',\n email: 'tony@t.com',\n }, function(err, user) {\n console.log(err, user);\n });\n\n User.find({ where: { name: 'Tony' }}, function(err, users) {\n console.log(err, users);\n });\n\n User.destroyAll(function() {\n console.log('example complete');\n });\n});\n```\n","readmeFilename":"README.md"}