DATABASE Commit transaction function

This article describes the RPA Database functionality to commit a database transaction.

For a full list of available functions, please read DATABASE functions.

Description

The Commit transaction function commits the current database transaction, persisting all changes made since the transaction began. After committing, the connection returns to autocommit mode.

Setting it up

To use the Commit transaction function, follow these instructions:

{{popups:rpas/add:action=db-commit}}

Once on a process map:

1. Navigate to the process where you would like to add the Commit transaction function
2. Click on the green button's drop-down (right side of the green button labelled "Process")
3. On the menu that appears, click on the "+ Activity" item
4. From here you can select the Commit transaction option
5. Click "Add" once you are done

Input parameters

Output variables

This action does not produce output variables.

Errors

Tips

• Only commit after verifying all changes are correct
• Once committed, changes cannot be rolled back

Related functions

• Begin transaction
• Rollback transaction