• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. Controlling Transactions

Controlling Transactions

A transaction is a user-defined sequence of database operations, which form an integral unit of work.

Starting transactions

DWS starts a transaction using START TRANSACTION and BEGIN. For details, see START TRANSACTION and BEGIN.

Setting transactions

DWS sets a transaction using SET TRANSACTION or SET LOCAL TRANSACTION. For details, see SET TRANSACTION.

Submitting a transaction

DWS commits all operations of a transaction using COMMIT or END. For details, see COMMIT.

Rolling back transactions

If a fault occurs during a transaction and the transaction cannot proceed, the system performs rollback to cancel all the completed database operations related to the transaction. For details, see ROLLBACK.

NOTE:

If an execution request (not in a transaction block) received in the database contains multiple statements, the statements will be packed into a transaction. If one of the statements fails, the entire request will be rolled back.