Using the CommitWork Function
This function commits pending changes (inserts, updates, and deletes) to the database. When using CommitWork, remember that:
-
This function can be used only in an Application Engine program that has restart disabled.
-
The CommitWork function is useful only when you are processing SQL one row at a time in a single PeopleCode program, and you need to commit without exiting the program.
In a typical Application Engine program, SQL commands are split between multiple Application Engine actions that fetch, insert, update, or delete application data. You use the section or step level commit settings to manage the commits.
Related Topics