Lu, Huayi a24ca60074 DWS DEVELOPER 811 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2023-01-19 13:37:49 +00:00

3.9 KiB

Raw Permalink Blame History

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

Parent topic: TCL Syntax

3.9 KiB Raw Permalink Blame History