17.05 - Example: Iterated Requests - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following example shows one way of performing an iterated request in BTEQ:

     .IMPORT DATA FILE = r13sales.dat;
     .REPEAT RECS 200 PACK 100

     USING (pid INTEGER, pname CHAR(12))
     INSERT INTO ptable VALUES(:pid, :pname);

The .REPEAT command specifies that BTEQ should read up to 200 data records and pack a maximum of 100 data records with each request.