COMMIT Examples | SQL Statements | Teradata Vantage - 17.05 - COMMIT Examples - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

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;