DBUpdateSetter

From Fmepedia

This page contains a Custom Transformer created by an fmepedia user.   See the attached files list at the foot of this page for the zip file containing this custom transformer.

Created by: Dmitri Bagh

This transformer helps to run database writers in UPDATE mode.

In order to update feature attributes in a database the following conditions should be met:

• two attributes fme_db_operation and fme_where should be added. The first should be set to UPDATE, and in the second we specify a condition;
• features should have no geometries;
• feature should not have any attributes, which are not being updated. This transformer allows deleting all these attributes.
• only one feature should be sent to the writer (multiple features would simply repeat the same operation, wasting time).

This transformer takes care of all these steps.