DB Data Sink Update updates or overwrites all records that match a selected key. This component does not insert new records. If there are no matching records, DB Data Sink Update does not display an error message.
Use this component to update existing records, not insert new records.
If the update values violate any restrictions of the
underlying table or object (for example: constraints, referential
integrity, unique index definition), an error message occurs. The
selected Key Value attribute is independent of any existing index
definitions.
