Insert_filter

This filter should read records from the input connector, and add those records to the specified table. All insert errors will be sent to the output connector and no record will be returned. This filter should have 1 input connector and will be used for the INSERT statement.

Algorithm

General algorithm should be: filter should loop reading records from the input connector, and add those records into the specified table. 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 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]