Name
END
-- Commits the current transaction
Synopsis
END [ WORK | TRANSACTION ]
|
Inputs
- WORK
Optional keyword. It has no effect.
- TRANSACTION
Optional keyword. It has no effect.
Outputs
- COMMIT
Message returned if the transaction is successfully committed.
- NOTICE: COMMIT: no transaction in progress
If there is no transaction in progress.
Description
END is a synonym for
COMMIT.
Notes
The keywords WORK and TRANSACTION can be omitted.
Use ROLLBACK
to abort a transaction.
Usage
To make all changes permanent:
Compatibility
SQL92
There is no END statement in SQL92.