Syntax - 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


where the following is true:

tname
Table that is to receive rows created from input data records
If the table is not explicitly qualified by database name, the default database qualifies it.
cname
Column of the specified table that is to receive the value from a field of matching input records, where the value is identified by the corresponding entry in the fieldname list
fieldname
Field of an input record, whose value is given to a column of the specified table that is identified by the corresponding entry in the cname clause in this statement
If this statement did not specify a cname, the object’s CREATE statement provides the corresponding column identifier. This assumes that all columns from the table correspond to those specified in the original CREATE statement.
expression
Alternative to the fieldname clause, an expression that includes one or more actual fieldnames as terms may instead be used