Loading Data into Teradata Database - Teradata Database

Loading Data into Teradata Database

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.

Reference Information

Information on...	Is available in...
BTEQ commands, including PACK	Basic Teradata Query Reference
running batch jobs to submit BTEQ commands and Teradata SQL	Basic Teradata Query Reference