DataFlux Data Management Studio 2.6: User Guide

Update Rows Tab

You can use the Update Rows tab to define the target table, the affected fields, and the WHERE clauses included in an Update Rows node in a process job. (The Update Rows node is used to construct an update against a target table.) The Update Rows tab contains the following elements:

• Target Table - Selects the table that you want to update. Click Open Table to review its data. Click Options to specify options for the target table.
• Set - Specifies one or more fields to be updated. You can use the tools to add, delete, edit, and navigate among the fields. You can set the value of a field as follows: select a field (such as another field to compare to), define a case statement, and define a subquery or expression.
• Where - By default, specifies that all rows in the table should be modified. Deselect All rows to create WHERE clauses that will confine the updates to a subset of the target table. For information about creating WHERE clauses, see Where Tab.