Loading Data into Teradata Vantage - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

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.