If the transaction mode is set to short, the access service is responsible for controlling the commitment of requests. After sending the request to the database, the access service automatically issues either:
A commit, if the request succeeds, or
A rollback, if the request fails.
The begin transaction phrase affects the behavior of short transactions as follows:
If the begin transaction is issued prior to the end of the request, it triggers a commit of all previous statements in the request and temporarily sets the transaction mode to long.
If the begin transaction is not issued prior to the end of a request, the request marks the end of the transaction, and the transaction is committed.
You can issue a commit or rollback to end the temporary long mode. Doing this causes the transaction mode to revert to its status before the begin transaction was issued.
If the batch is in temporary long mode and ends (exits) without a commit or rollback, the SQL statements are rolled back, and the transaction mode reverts to its original status.
