COMMIT Examples | SQL Statements | VantageCloud Lake - COMMIT Examples - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Example: INSERT Request

The INSERT request in the following example opens the transaction. COMMIT closes the transaction.

INSERT INTO employee (name, empno)
VALUES ('Sinclair P', 101)
WHERE dept = '400';
COMMIT;

Example: UPDATE Followed by COMMIT

The following UPDATE initiates the transaction and COMMIT WORK terminates it:

UPDATE parts SET part_num = 20555
WHERE location = 'seoul';
COMMIT WORK;