Example 3: INSERT - Parallel Data Pump

Teradata® Parallel Data Pump Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Data Pump
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
kpf1641281806652.ditamap
dita:ditavalPath
ovd1619195504008.ditaval
dita:id
ouq1478611619316
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);