InterSystems SQL Reference
ROLLBACK
|
|
ROLLBACK [WORK] ROLLBACK TO SAVEPOINT pointname
pointname | The name of an existing savepoint, specified as an identifier. For further details see the Identifiers chapter of Using InterSystems SQL. |
&sql(SET TRANSACTION %COMMITMODE EXPLICIT) WRITE !,"Set transaction mode, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL &sql(START TRANSACTION) WRITE !,"Start transaction, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL &sql(SAVEPOINT a) WRITE !,"Set Savepoint a, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL &sql(SAVEPOINT b) WRITE !,"Set Savepoint b, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL &sql(SAVEPOINT c) WRITE !,"Set Savepoint c, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL &sql(ROLLBACK) WRITE !,"Rollback transaction, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL
&sql(SET TRANSACTION %COMMITMODE EXPLICIT) WRITE !,"Set transaction mode, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL &sql(START TRANSACTION) WRITE !,"Start transaction, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL &sql(SAVEPOINT a) WRITE !,"Set Savepoint a, SQLCODE=",SQLCODE WRITE !,"Transaction level at a=",$TLEVEL &sql(SAVEPOINT b) WRITE !,"Set Savepoint b, SQLCODE=",SQLCODE WRITE !,"Transaction level at b=",$TLEVEL &sql(ROLLBACK TO SAVEPOINT b) WRITE !,"Rollback to b, SQLCODE=",SQLCODE WRITE !,"Rollback transaction level=",$TLEVEL &sql(SAVEPOINT c) WRITE !,"Set Savepoint c, SQLCODE=",SQLCODE WRITE !,"Transaction level at c=",$TLEVEL &sql(SAVEPOINT d) WRITE !,"Set Savepoint d, SQLCODE=",SQLCODE WRITE !,"Transaction level at d=",$TLEVEL &sql(COMMIT) WRITE !,"Commit transaction, SQLCODE=",SQLCODE WRITE !,"Transaction level=",$TLEVEL