User guide

Operator reference
170 Data Integration with Sybase Avaki Studio
• 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, like in mapped parameter mode, a single-row
result set consisting of the UPDATE_COUNT column.
Connections
The Update operator takes zero or one input result sets, which can be the output of an
Input Source or of any other operator. It produces exactly one output result set. The
schema of the output result set is either the same as the input or a single column named
UPDATE_COUNT, of type INTEGER. See “Specifying the output” on page 173 for
details.
Performance notes
An Update operator produces no output until the update operation is done, regardless
of the mode.
Required Connection