# 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