Syntax - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
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.