The COMMIT or COMMIT WORK statement makes changes in the database permanent, terminating the transaction. To discard the changes, use the ROLLBACK command.
If you do not commit a transaction explicitly and the program does not make the commit for you automatically, the transaction will be rolled back. For example, the solidDB® SQL Editor (solsql) does not commit transactions by default.