n8n-nodes-ibm-db2

This is an n8n community node that allows you to connect to IBM DB2 databases and execute SQL operations.

Installation

Follow the installation guide in the n8n community nodes documentation.

Operations

The IBM DB2 node supports the following operations:

• Execute Query: Run custom SQL queries
• Insert: Insert new records into a table
• Update: Update existing records in a table
• Delete: Delete records from a table

Credentials

You need to create IBM DB2 credentials with the following information:

• Host: The hostname or IP address of your DB2 server
• Port: The port number (default: 50000)
• Database: The name of the database to connect to
• Username: Your DB2 username
• Password: Your DB2 password
• SSL: Whether to use SSL connection (optional)
• Connection Timeout: Connection timeout in milliseconds (optional)

Prerequisites

Make sure you have the IBM DB2 client libraries installed on your system where n8n is running. You can download them from the IBM website.

Usage Examples

Execute Query

```sql SELECT * FROM employees WHERE department = 'IT' ```

Insert Record

• Table: employees
• Columns:
  • name: John Doe
  • email: [email protected]
  • department: IT

Update Record

• Table: employees
• Update Fields:
  • salary: 75000
• Where Condition: id = 123

Delete Record

• Table: employees
• Where Condition: id = 123

License

MIT