node-red-contrib-db2-for-i 0.0.3

A Node-RED node to use a IBM DB2 for i database

npm install node-red-contrib-db2-for-i

A Node-RED node to read and write to a DB2 for IBM i database from IBM i.

Install

Run the following command in your Node-RED user directory - typically ~/.node-red

npm install node-red-contrib-db2-for-i

Prereqs

5733OPS Open Source free products with options for Node.js and DB2 driver located in /QOpenSys/QIBM/ProdData/OPS/Node6/os400/db2i/lib/db2a

Usage

Allows basic access to a DB2 for i database.

msg.payload must hold the query for the database, and the result is returned in msg.payload.

Typically the returned payload will be an array of the result rows.

If nothing is found for the key then null is returned.

Basic Example here

Usage Details and Example

Input: msg.payload = SQL Query injected

Input: The msg.database payload for injecting the db name (ex: *LOCAL). Note: The associated Template node name is used as a connection name for connection reuse within a Node-RED flow. This node name is used as a connection name.

Input : Enter your credentials in the DB2 for i config node associated with the DB2 for i node : dbname = *LOCAL , and user profile and password (should be optional in the next release)

Output Result in msg.payload. Not return code for now...

The returned payload will be an array of the result rows.

If nothing is found for the key then null is returned.

Getting Started

Refer to the flow https://flows.nodered.org/flow/b255f32b8e07a5cc0c17e654fd338354

Node Info

Version: 0.0.3
Updated 2 weeks, 6 days ago
License: Apache-2.0

Downloads

0 in the last day
8 in the last week
148 in the last month

Nodes

  • DB2 for i Config
  • DB2 for i

Keywords

  • node-red
  • db2
  • ibm
  • ibmi
  • os400
  • ibm i
  • iseries

Maintainers

  • bmarolleau