InterSystems Learning Services| InterSystems

Estás viendo como un 'Invitado'. No se registrará su progreso.

Diagrama de temas

Reference	Timestamp	Code
ObjectScript transaction pattern	02:30	Begin code: tstart Set status1 = account1.%Save() Set status2 = account2.%Save() If (status1 && status2) {tcommit} Else {trollback 1} End code.
ObjectScript bank transfer transaction	03:28	Begin code: Set account1 = ##class(Bank.Account).%OpenId(1) Set account2 = ##class(Bank.Account).%OpenId(2) Set account1.Balance = account1.Balance + 100 Set account2.Balance = account2.Balance - 100 Tstart Set status1 = account1.%Save() Set status2 = account2.%Save() If (status1 && status2) { Tcommit } Else { Trollback 1 } End code.
SQL transaction example	04:15	Begin code: START TRANSACTION; UPDATE bank.account SET Balance = Balance - 100 WHERE ID = 1; UPDATE bank.account SET Balance = Balance + 100 WHERE ID = 2; COMMIT; End code.
Nested transaction demonstration	04:42	Begin code: USER> TSTART USER> WRITE $TLEVEL 1 USER> TSTART USER> WRITE $TLEVEL 2 USER> TROLLBACK 1 USER> WRITE $TLEVEL 1 USER> TCOMMIT USER> WRITE $TLEVEL 0 End code.
SQL savepoint example	05:36	Begin code: START TRANSACTION; SAVEPOINT step1; UPDATE "Order" SET Status = 'Processing' WHERE ID = 12; SAVEPOINT step2; UPDATE OrderItems SET Qty = Qty + 1 WHERE OrderID = 12; ROLLBACK TO SAVEPOINT step2; COMMIT; End code.