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