COMMIT WORK and ROLLBACK WORK Statements

• The statement:

  COMMIT WORK;

  causes a checkpoint to be done, so that the changes made by all previous INSERT, UPDATE and DELETE are actually written to the database.

  An implicit COMMIT WORK statement is performed when the SQL interpreter is terminated.

• The statement:

  ROLLBACK WORK;

  causes all the changes made since the last COMMIT WORK statement to be abandoned.

Although it is required by the ANSI standard, the word WORK in these statements is redundant and can be omitted.

In the DP4 SQL Interpreter you can execute these statements by clicking on the appropriate buttons.