Using the REPEAT Command - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

When updating a Teradata Database, sometimes a particular change needs to be made repeatedly. A large number of import data records might need to be inserted into a table, or a large multi-statement request might need to update several rows. Rather than entering each SQL request individually, use the REPEAT command and issue the request once. This makes the batch scripts much smaller and eliminates the repetitive effort that would otherwise be required when using BTEQ interactively.