DataFlux Data Management Studio 2.7: User Guide

Update Rows Node

Use an Update Rows node to construct an SQL statement that will update the rows in a table in a process job. For more information about the tabs at upper left of this dialog, click the following links:

• Update Rows tab
• Settings tab
• SQL Code tab
• Inputs tab
• Outputs tab
• Node Connections tab
• Log tab

You can update one or more selected fields in a target table. You can also set options that are injected before or after the table name or after the end of the standard update statement in the code. Finally, you can add one or more WHERE clauses to the query to specify which subset of rows in the target table to update.

Related Topics

• Updating Rows in a Target Table