n8n Node for IBM DB2

This is a community node for n8n that allows you to run SQL queries against an IBM DB2 database.

Installation

Follow the installation guide in the n8n documentation.

1. Go to Settings > Community Nodes.
2. Select Install.
3. Enter @simhateja/n8n-nodes-ibm-db2 in the Enter npm package name field.
4. Agree to the risks and click Install.

After installing the node, you can use it in your workflows.

Usage

This node provides a single action: running a query.

1. Drag the IBM DB2 node into your workflow.
2. Create new credentials by providing your DB2 database Hostname, Port, Database name, User, and Password.
3. In the Query field, enter the SQL query you wish to execute.

The node will output the data returned by the SELECT statement, or an empty item for operations like CREATE, INSERT, UPDATE, or DELETE.

Local Development & Testing

This node can be tested locally using the IBM DB2 Docker container.

1. Run the local database: docker run -itd --name db2_test -p 50000:50000 -e DBNAME=testdb -e DB2INSTANCE=db2inst1 -e DB2INST1_PASSWORD=password -e LICENSE=accept --privileged=true ibmcom/db2
2. Use the following credentials in n8n:
   • Hostname: localhost
   • Port: 50000
   • Database: testdb
   • User: db2inst1
   • Password: password #� �n�8�n� � �