Syntax - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities


where the following is true:

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 has embedded white space characters, the entire pathname must be endorsed in single or double quotes.
IGNORE charpos1 and charpos2
Start and end character positions of a field in each input record that contains 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.