Update Operator

Use the Update operator to invoke a database operation that performs SQL insert or update operations against a connected database.

The database operation must have the “Modifies Database” option set in order for it to work with an Update operation.

There are two ways to use an Update operator:

Mapped Parameter Mode
You can use an Update operator to perform single-row updates based on parameter values. In this mode, it behaves analogously to an Input Source, in that it has no input result set—it just takes the parameter values/expressions that you specify and passes them on to the database operation, returning a result set consisting of one row and one column (UPDATE_COUNT).
Batch Mode
Alternatively, you can route any flow whose result set matches the parameters of the database operation as an input to the Update operator. In order to use this mode:
- You must have connected an input to the Update operator.
- The input to the Update operator must have the same number of columns as the database operation has parameters.
- The data types of the result set columns (by ordinal position) and the parameters of the database operation (by ordinal position) must match.
- The database operation must be defined with the “Supports batch operations” option enabled.
In batch mode, the output of the Update operator can be either the input result set (passed through with no changes) or, as in mapped parameter mode, a single-row result set consisting of the UPDATE_COUNT column.

Note: An Update operator produces no output until the update operation is done, regardless of the mode.