doc-exports/docs/dws/dev/dws_06_0259.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

3.8 KiB

COMMIT | END

Function

COMMIT or END commits all operations of a transaction.

Precautions

Only the transaction creators or system administrators can run the COMMIT command. The creation and commit operations must be in different sessions.

Syntax

1
{ COMMIT | END } [ WORK | TRANSACTION ] ;

Parameter Description

  • COMMIT | END

    Commits the current transaction and makes all changes made by the transaction become visible to others.

  • WORK | TRANSACTION

    Optional keyword has no effect except increasing readability.

Examples

Commit the transaction to make all changes permanent:

1
COMMIT;

Helpful Links

ROLLBACK