PRPC RDB operations are implemented as a single-statement transaction. RDB- methods immediately commit their changes to the database. However there is an alternative to implement this.
You can write a stored procedure to complete the insert/update operation. You can do the commit or rollback inside your stored procedure if any one of your operations fails. Invoke your stored procedure from a Connect-SQL.