COMMIT

Makes a transaction's changes to the database permanent, and ends the transaction.

Syntax

COMMIT;

Example

execute IBEBlock
as
begin
  ...
 
  EXECUTE STATEMENT 'create table mytable (id integer, data varchar(50))';
  COMMIT;
 
  INSERT INTO MYTABLE (ID, DATA) VALUES (1, NULL);
  COMMIT;

  ...
end