n8n-nodes-ibmi-db2 v1.0.3
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'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 is a fair-code licensed workflow automation platform.
Installation
Operations
Credentials
Compatibility
Resources
Installation
Follow the installation guide 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.