IBM Db2 - Insert rows action ​

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

Input ​

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 ​

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.