User guide

Data Integration with Sybase Avaki Studio 169
Update
Union properties
Double-click a Union operator to display the Union Properties dialog. You can edit the
name and description as described in “Properties dialogs” on page 58.
Removing duplicates
Select the Generate only distinct (non-duplicate) rows checkbox to eliminate from
the output result set any rows whose data duplicates that of a row already in the output.
Update
Use the Update operator to invoke an Avaki 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 opera-
tion.
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