User guide

Operator reference
172 Data Integration with Sybase Avaki Studio
Choosing a database operation
The Update operator executes a database operation defined in your Avaki domain. Use
the Browse… button to choose the database operation you want to execute. The opera-
tion you choose must have been defined with the “Modifies Database” option set to
“Yes” in order for it to work in an Update operator. (If you used Studio to create the data-
base operation, the option is a checkbox labelled “Operation modifies the database”.)
If you have already chosen a database operation, but you have changed its schema or
parameters, you can click the Refresh Schema Source button to refresh your Update
operator.
Mapping update parameters
If you’re using your Update operator in mapped parameter mode, you must map its
parameters. (If you are using batch mode, you don’t need to explicitly map parameters,
but the input schema must match the parameter types as described in “Batch Mode” on
page 169.)You configure parameter mappings for an Update operator similarly to the
way you do for an Input Source element. See “Mapping input parameters” on
page 144 for details on mapping Input Source parameters.