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


where the following is true:

fileid
Data source of the external system
The client system DD or equivalent statement specifies a file.
UNIX and Windows Systems
infilename (the path name for a file). If the path name has embedded white space characters, enclose the entire path name in single or double quotes.
If the path name is enclosed by single quotation marks and there is an embedded single quotation mark, then an escape character (single quotation mark) needs to precede the embedded single quotation mark. Likewise, if the path name is enclosed by double quotation marks and there is an embedded double quotation mark, then an escape character (double quotation mark) needs to precede the embedded double quotation mark.
If the path name contains single or double quotation marks, it should be enclosed in either single or double quotation marks.
z/OS
a true DDNAME.
If DDNAME is specified, Teradata TPump reads data records from the specified source.
A DDNAME must obey the same rules for its construction as Teradata SQL column names, except that:
  • the “at” sign (@) is allowed as an alphabetic character
  • the underscore (_) is not allowed
The DDNAME must also obey the applicable rules of the external system and may reference a sequential or VSAM data set.
If DDNAME represents a data source on magnetic tape, the tape may be either labeled or non-labeled (if the operating system supports it). The “at” sign (@) is allowed as an alphabetic character and the underscore (_) is not allowed.
charpos1 and charpos2
Start and end character positions of a field in each input record which contains extraneous information
Teradata TPump ignores the specified field(s) as follows:
  • charpos1: only the single specified character position is ignored.
  • charpos1 THRU: character positions from charpos1 through the end of the record are ignored.
  • THRU charpos2: character positions from the beginning of the record through charpos2 are ignored.
  • charpos1 THRU charpos2: character positions from charpos1 through charpos2 are ignored.