Articles in this section

Import data into IBM Db2

Anitha Abraham
Updated

Before you begin

Set up a connection to IBM Db2 if you don't have an existing connection that you can use.

Import data to the connected database

Create an import in Flow Builder or select an existing import to send records to IBM Db2.

Uses standard SQL queries to import and modify data. You can't use multiple SQL queries on a single flow step. If your flow requires multiple SQL queries, you must create one flow step for each query. To import data into IBM Db2, choose any of the following import type in How would you like records imported? .

Each import type is explained in the sections below.

Use batch insert SQL query

Tip

Click pencil_handlebars.svg to open the Build SQL query editor and ask Celigo AI to generate a query. Enter a description of your query in plain English in the space provided, and Celigo AI will attempt to generate a query based on your prompt.

The batch insert data option is helpful for moderate data volumes. integrator.io builds the insert query for you automatically for each batch of records.

import-ibm-db2-batch-insert.png

Destination table: Select the destination table into which the data must be inserted in either of these ways:

  • By validated table name: Begin typing the table name in the Destination table field, and any table that already exists in your IBM Db2 environment will display in a list filtered by the text you enter.

  • By referencing a dynamic lookup with a handlebars expression that identifies the destination table: Use a handlebars expression to reference the lookup using the following format:

    {{lookup.<lookup name>}}
Ex:
{{lookup.IBMDb2TableLookup}}

Use SQL query once per record

Execute a SQL query once for each record.

You can write your SQL command in the SQL query text field. Click Edit (pencil_handlebars.svg) to the right of the text field to open the SQL Query builder AFE.

import-ibmdb2-once-per-record.png

You might want to send each record as a separate operation if you're processing data from multiple sources or if the records are generated in real-time. Celigo can orchestrate such operations by calling SQL queries sequentially for each record, depending on the integration setup.

Example

Each INSERT INTO statement targets one record and inserts it individually into the table.This option may be less efficient than a batch insert since each INSERT operation will be executed separately, but it may be needed in situations where records are being inserted dynamically, such as with individual record processing or when handling complex data transformations.

INSERT INTO your_table_name
            (column1,
             column2,
             column3)
VALUES      ('value1',
             'value2',
             'value3');

Use SQL query once per page of records

Execute a SQL query once per page of data. You can write your SQL command in the SQL query text field. Click Edit (pencil_handlebars.svg) to the right of the text field to open the SQL Query builder AFE.

import-ibmdb2-once-per-page.png

Example

When performing a SQL query once per page of records, especially where you're dealing with large datasets, you can implement pagination using the LIMIT and OFFSET clauses in your SQL queries. This option allows you to process the records in smaller, manageable chunks to optimize performance.

SELECT column1,
       column2,
       column3
FROM   your_table_name
ORDER  BY some_column
LIMIT  100 offset 0;