IBM Db2 - Upsert rows action (batch)

This action allows you to perform an upsert (insert or update) of multiple rows in a single step.

The action checks if input data is in the table. If present, the system performs an update. Otherwise, it adds the data as a new row (insert).

Input

Table

Required field

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

Rows > Rows source list

Required field

The datapill that is the source of the batch of rows to insert into the table. Can originate from any trigger or action that returns a list datapill.

Rows > Rows fields

Optional field

Dynamically-generated list of input fields, based on the columns in the target table. Map the data from the Rows source list datapill.

Unique key

Required field

Select a unique key column to deduplicate rows.<br/ ><br/ >When you index the selected unique key, it improves the performance of the upsert action.

Output

Rows affected

Number of upserted rows.