# n8n-nodes-ibmi-db2

> n8n Community node to query a DB2 instance for iSeries

Latest version **1.0.3** (published 2024-01-30) · MIT license · 0 weekly downloads

## Install

```sh
npm install n8n-nodes-ibmi-db2
pnpm add n8n-nodes-ibmi-db2
yarn add n8n-nodes-ibmi-db2
bun add n8n-nodes-ibmi-db2
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.3 |
| Published | 2024-01-30 |
| First published | 2023-11-02 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 1 |
| Unpacked size | 91.5 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 6 |
| Author | Tony Morello |
| Maintainers | tonymorello |
| Keywords | n8n-community-node-package, IBMi, AS400, DB2 |

## Links

- npm: https://www.npmjs.com/package/n8n-nodes-ibmi-db2
- Repository: https://github.com/tonymorello/n8n-nodes-ibmi-db2
- Issues: https://github.com/tonymorello/n8n-nodes-ibmi-db2/issues
- npm.io page: https://npm.io/package/n8n-nodes-ibmi-db2

## Dependencies (1)

- [node-jt400](https://npm.io/package/node-jt400.md) ^4.4.1

## Recent versions

- 1.0.3 (latest) — 2024-01-30
- 1.0.2 — 2024-01-10
- 1.0.0 — 2023-11-07
- 0.1.1 — 2023-11-03
- 0.1.0 — 2023-11-02

## README

# n8n-nodes-ibmi-db2

This is an n8n community node. It lets you query a DB2 instance running on iSeries (AS400) in your n8n workflows.

I created this node for internal use (initially based off of [GeorgeJeffcock/n8n](https://github.com/GeorgeJeffcock/n8n)'s repo for reference as I was learning how to write custom nodes).  
It uses node-jt400 to establish a TCP/IP connection to the database and runs a query returning the results as data that can be used in n8n.

[n8n](https://n8n.io/) is a [fair-code licensed](https://docs.n8n.io/reference/license/) workflow automation platform.

[Installation](#installation)  
[Operations](#operations)  
[Credentials](#credentials)  
[Compatibility](#compatibility)  
[Resources](#resources)  

## Installation

Follow the [installation guide](https://docs.n8n.io/integrations/community-nodes/installation/) in the n8n community nodes documentation.

## Operations

* **Query** - Execute a SQL query
* **Insert** - Insert rows in database
* **Update** - Update rows in database
* **Delete** - Delete rows in database

## Credentials

The node supports the following credentials/settings:
* **Host** - _TCP/IP host name/address of the database server_
* **User** - _User name for connecting to the database_
* **Password** - _Password for connecting to the database_
* **Database** (optional) - _Default database/schema_
* **Libraries** (optional) - _Specifies one or more libraries that you want to add/replace in the library list_
* **Port** (optional) - _Connection port_
* **Translate Binary** (optional) - _Specifies whether binary data is translated. If this property is set to "true", then BINARY and VARBINARY fields are treated as CHAR and VARCHAR fields (Default: True)_
* **Translate Boolean** (optional) - _Specifies how Boolean objects are interpreted when setting the value for a character field/parameter. Setting the property to "false", would store the Boolean object in the character field as either "1" or "0 (Default: False)"_

## Compatibility

Developed and tested on n8n v1.14.2. I did not test any previous version, so if you feel like trying and reporting back I will update this README.

## Resources

* [n8n community nodes documentation](https://docs.n8n.io/integrations/community-nodes/)
* [node-jt400 npm page](https://www.npmjs.com/package/node-jt400)
* [IBM Toolbox JDBC properties](https://www.ibm.com/docs/en/i/7.5?topic=ssw_ibm_i_75/rzahh/javadoc/com/ibm/as400/access/doc-files/JDBCProperties.htm)

---
_Source: https://npm.io/package/n8n-nodes-ibmi-db2 · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._