Pegasus InfoCorp: Web site design and web software development company

COMMIT (l)

Commits the current transaction

SYNOPSIS

    COMMIT [ WORK | TRANSACTION ]
    

    WORK

    TRANSACTION

      Optional keywords. They have no effect.

    END

      Message returned if the transaction is successfully committed.

    NOTICE EndTransactionBlock and not inprogress/abort state

      If there is no transaction in progress.

DESCRIPTION

    COMMIT commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs.

    The keywords WORK and TRANSACTION are noise and can be omitted.

    Use rollback(l) to abort a transaction.

USAGE

    To make all changes permanent:

    COMMIT WORK;
    

COMPATIBILITY

    Full compatibility.