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

See also:
ROLLBACK

back to top of page
<< INSERT INTO connection.table | IBEBlock | ROLLBACK >>