Example 4: INSERT - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
oqw1608578437373.ditamap
dita:ditavalPath
ovd1619195504008.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

An input data source contains a series of 10- to 40-byte records. Each record contains the primary index value (EmpNum) of a row that is to be inserted successively into the Employee table whose columns are EmpNo, Name, and Salary.

.BEGIN LOAD SESSION number ;
.LAYOUT Layoutname;
.FIELD EmpNum 1 INTEGER;
.FIELD Name * (VARCHAR (30));
.FIELD Sal * (DECIMAL (7,2));
.DML LABEL DMLlabelname;
INSERT Employee (EmpNo, Name, Salary) VALUES (:EmpNum, :Name, :Sal);
.IMPORT INFILE Infilename LAYOUT Layoutname  APPLY DMLlabelname;
.END LOAD;