Loading Data into Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

BTEQ Input Stream

Use the following BTEQ input stream to load (import) data into Analytics 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.

For information about BTEQ commands, including PACK, see Basic Teradata® Query Reference, B035-2414.

For information about running batch jobs to submit BTEQ commands and Teradata SQL, see Basic Teradata® Query Reference, B035-2414.