REPEAT Command | Update Rows Using Multiple Requests | Basic Teradata Query - Updating Rows Using Multiple Requests - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

If all of the rows cannot be described by a formula, they must be described individually. The following requests, for example, update the salaries of two employees:

update workforce.employee set salary=salary*1.07
where empno = 10006;
update workforce.employee set salary=salary*1.07
where empno = 10013;

This approach is convenient for a few updates, but if there were hundreds of updates, the script would be very long and inflexible. Each entry would have to be edited to use the script for another list of employees.