16.10 - Loading Data into Teradata Database - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

BTEQ Input Stream

Use the following BTEQ input stream to load (import) data into the Teradata Database:

.IMPORT DATA FILE=DeptData.imp
.REPEAT *
USING    DeptNo (SMALLINT),
         DeptName (VARCHAR(14)),
         Loc  (CHAR(3)),
         MgrNo  (SMALLINT)
INSERT INTO Personnel.newtable (DeptNo, DeptName,
         Loc,MgrNo)
VALUES   (:DeptNo, :DeptName, :Loc, :MgrNo);

where:

  • The REPEAT * command repeats the next request until the data in the import file is exhausted.
  • The term newtable refers to an empty table to receive the data being loaded.