IBM Db2 - Insert Rows

This action enables you to insert multiple rows in a single step.

Insert rows

Input fields

Table

Required field

Select the target table or view. You can also toggle the input to text mode, and enter the name of the table or view as text.

Rows > Rows source list

Required field

The datapill is the source of the batched rows inserted into the table. Can originate from any trigger or action that generates a list datapill.

Rows > Rows fields

Optional field

Dynamically-generated list of input fields, based on the columns in the target table. The Rows source list datapill provides the map for inserting data.

Output fields

keys

Primary Key IDs of inserted rows. If inserting into a table without primary keys, this field is empty.

keys_count

Number of rows with inserted primary keys.