Example 2 - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
fel1608578437279.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

Multiple References to the Same Field

Consider a set of input records that contains a 25-character address field in positions 15 through 39, with the street number in the first seven positions and the street name in the last 18 positions.

The following example shows how to refer both to the address field as a whole and separately to the street name:

.FIELD ADDRESS 15 CHAR(25);
.FIELD STREET  22 CHAR(18);