17.00 - 17.05 - Loading Data into Teradata Vantage - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

BTEQ Input Stream

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

.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.