Using the REPEAT Command

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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.