Specifies where to continue execution after a transaction.
The END TRANSACTION
statement specifies the end of
a transaction. This is where to continue program execution following a COMMIT
or a ROLLBACK
The TRANSACTION or WORK keywords are optional and provides no functionality.
They are provided solely for compatibility with other MultiValue vendor products.
Caché MVBasic supports two sets of transaction statements:
These two sets of transaction statements should not be combined.
The following example performs database operations within a transaction.
It sets a variable x, which determines whether the transaction should be committed
or rolled back.
PRINT "Before the transaction"
PRINT "Transaction rolled back"
PRINT "This should not print"
PRINT "After the transaction"