Use the COMMIT command to make permanent the changes to the data or database structure made since the beginning of the transaction. COMMIT is used during transaction processing.
Options
WORK
WORK is optional and has no effect in R:BASE.
About the COMMIT Command
A transaction consists of all the commands executed since the last COMMIT or ROLLBACK command, or since you connected to the database if a COMMIT command has not been executed.
If you want to be able to process a group of commands, or transaction, without permanently affecting your data until you accept the changes, turn the AUTOCOMMIT setting off. R:BASE stores the information needed to reverse each modification made to the database in a Before Image file.
To accept a transaction and make the changes permanent, enter the COMMIT command after you have entered the transaction. The changes made by the commands in the transaction are made permanent and R:BASE clears the Before Image file to prepare it for the next transaction. The COMMIT command also releases all automatic table and database locks and executes any SET LOCK OFF commands included in the transaction. To reverse the transaction and undo the changes, enter the ROLLBACK command.
