Syntax - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-10
dita:mapPath
lsl1527114222348.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities


where the following is true:

charpos1 and charpos2
Start and end character positions of a field in each input record that contain extraneous information
For example:
  • Use charpos1 to ignore only the single specified character.
  • Use charpos1 THRU to ignore all characters from charpos1 through the end of the record.
  • Use THRU charpos2 to ignore all characters from the beginning of the record through charpos2.
  • Use charpos1 THRU charpos2 to ignore all characters from charpos1 through charpos2.
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.
  • In z/OS, this is a DDNAME. (See Usage Notes.)
  • In UNIX OS and Windows, this is the path name for a file.

    If the path name contains embedded white space characters, the entire path name must be enclosed in single or double quotes.

    If the path name is enclosed by single quotes and there is an embedded single quote, then an escape character needs to precede the embedded single quote. Likewise, if the path name is enclosed by double quotes and there is an embedded double quote, then an escape character needs to precede the embedded double quote.

    If the path name contains single or double quotation marks, it should be enclosed in either single or double quotation marks.

var
Name of the Teradata MultiLoad 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.