fme_db_transaction

As each feature is processed by the writer, it is checked for an attribute called fme_db_transaction.

The value of this attribute specifies whether the writer should commit or rollback the current transaction. The value of the attribute can be one of:

  • COMMIT_BEFORE
  • COMMIT_AFTER
  • ROLLBACK_AFTER
  • IGNORE

If the fme_db_transaction attribute is not set in any features, the entire write operation occurs in a single transaction.

To use this capability, the Transaction Interval (for ArcSDE, this is called Features Per Transaction) must be set to VARIABLE.