AnsweredAssumed Answered

Looking at the comit by profile for a database operation - my undrestanding that the comit by profile is eqirvalent to a batch count to 1 if you are only exectuting on statement - is thsi correct?

Question asked by f.renton974469 on Jan 14, 2018
Latest reply on Jan 16, 2018 by daniel.santana
Commit Option

The manual says

'Commit by Profile does a single commit after all statements in the profile have executed. This option avoids orphaned rows when the database profile contains multiple statements, for example tables that have a parent-child relationship'.

 

If there are multiple rows are these committed one at a time if only one statement in the operation.

Outcomes