Autocommit problem

[ronyx18]

Is there anyway I can set autocommit to false while using df.write.mode(append) with all other necessary option parameters?

The task is to run an insert and an update simultaneously and then run commit once both the transactions are successful.