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:

datadesc
Type and length of data in the field
fieldname
Optional name of an input record field
The fieldname specification can be referenced by:
  • The NULLIF nullexpr expression of a FIELD command
  • The condition expression of the APPLY clause of an IMPORT command
A fieldname specification must obey the same construction rules as Teradata SQL column names.
startpos
Starting position of the specified field in the data records of an external data source
The startpos can be defined as:
  • An unsigned integer, which is a character position starting with 1
  • An asterisk, which means the next available character position beyond the preceding field