Example 4: INSERT - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
dmq1512702641516.ditamap
dita:ditavalPath
Audience_PDF_include.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;