# IBM Db2 - Update actions

Workato offers both batch and conditional update row actions. This flexibility enables you to closely match the actions necessary for your recipe, and to fulfill your business needs.

# Update rows by condition

Update the columns of multiple rows that match the WHERE condition.

# Input fields

Table
Required field
Select a table to update. This can be done either by selecting a table from the pick list, or toggling the input field to text mode and typing the full table name.
WHERE condition
Optional field
Row(s) that match this specified condition will be updated (e.g. <code>status = true</code>). SQL sub-queries are supported.
Rows > Rows fields
Optional field
This is a dynamically generated list of input fields, based on the columns in the target table. Specify what data to insert into each column here.

# Output fields

Rows affected
Number of rows that were updated

# Update a batch of rows

Update multiple rows to different values in one step, based on incoming data in a list datapill.

This provides higher throughput when moving a large number of records from an external app to IBM Db2.

# Input fields

Table
Required field
Select a table to update. This can be done either by selecting a table from the pick list, or toggling the input field to text mode and typing the full table name.
Rows > Rows source list
Required field
The datapill to input is the source of the batch of rows to update to the table. This can come from any trigger or action that outputs a list datapill.
Rows > Rows fields
Optional field
This is a Dynamically generated list of input fields, based on the columns in the target table. Map data to be inserted from the Rows source list datapill.
Unique key
Required field
Select a unique key column to identify rows for the update. Performance can be improved if the selected unique key is indexed.

# Output fields

Rows affected
Number of rows that were updated


Last updated: 9/30/2022, 8:08:55 AM