UpsertOnUpdate

Default Value Data Type Required

false

String

No

Description

This property specifies whether the connector execute UPDATE statements as UPSERT statements.

  • true: If the condition of the WHERE clause in the UPDATE statement is false, then the connector inserts the data as a new row in the database.
  • false: If the condition of the WHERE clause in the UPDATE statement is false, then the connector does not insert or update any data.

For more information about how the connector handles UPSERT statements, see UPSERT.

Note:

This property is not supported when the connector executes multiple statements in a single execute or executeUpdate call. To execute multiple UPSERT statements, use the UPSERT syntax.

Related topics