Examples - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
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;
  • “ABORT” on page 277
  • “ROLLBACK” on page 462
  • SQL Request and Transaction Processing