When using SQL to update database objects, 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.