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

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;