Example 3: INSERT - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
ioq1544831946920.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities
.LAYOUT lname;
.FIELD first 1 somedatatype;
.FIELD f2nd * anydatatype;
.
.
.
.FIELD flast * datatype;
.DML LABEL label;
INSERT INTO targetable (col1, col2, ... colast)
VALUES (:f2nd, :first, ... :flast);