Update_filter

This filter should read records, set specified values to the fields and store them into the database. All update errors should be sent to the output connector and no record should be returned. This filter should have 1 input connector and will be used for the UPDATE statement.

Algorithm

General algorithm: filter should loop reading records from the input connector. Each record should be updated according to specified rules: set a specified value to a field, value can be taken from another field or can be a constant value or an expression.

The filter should check if there is an active transaction, if there is none then filter should silently start a new transaction using the current default transaction mode.

Cost calculation

Cost calculation: no cost calculation should be done for this filter, as it is irrelevant. Cost calculation result records received from the input connector should be transmitted as-is to the output connector.

See also

[Set_engine]