Syntax - Parallel Data Pump

where the following is true:

var

Name of the utility variable that is to be set with the value accepted from the designated source

Character string values appear as quoted strings in the data file.

env_var

Environment variable that provides the value for the specified utility variables (var)

fileid

Data source of the external system.

The external system DD (or similar) 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 labelled or nonlabelled (if the operating system supports it).

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:

• If charpos1 is specified, Teradata TPump ignores only the single specified character position.
• If charpos1 THRU character positions are specified, Teradata TPump ignores character positions from charpos1 through the end of the record.
• If THRU charpos2 is specified, Teradata TPump ignores character positions from the beginning of the record through charpos2.
• If charpos1 THRU charpos2 is specified, Teradata TPump ignores character positions from charpos1 through charpos2.