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.