Usage Notes - 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

The following table describes the things to consider when using the LAYOUT command.

LAYOUT Usage Notes 
Topic Usage Notes
CONTINUEIF and INDICATORS Processing When both CONTINUEIF and INDICATORS are specified:
  • Teradata MultiLoad processes all of the CONTINUEIF specifications before performing the INDICATORS processing
  • If the CONTINUEIF columns start in position 1, then any indicator bytes will follow the CONTINUEIF columns
Required Following Commands A LAYOUT command must be immediately followed by a combination of FIELD, FILLER, or TABLE commands. This sequence of commands, referenced by the layoutname, may describe one or more record formats contained in one or more client data sources. (See the redefinition options for FIELD, FILLER, and TABLE commands).

The LAYOUT command sequence is terminated by the first subsequent command that is not a FIELD, FILLER, or TABLE command.

Using the Same LAYOUT Command in More Than One Teradata MultiLoad Task Reference the same layoutname specification in more than one Teradata MultiLoad task, provided that:
  • Each task is delimited by BEGIN MLOAD and END MLOAD commands in a single job step
  • The LAYOUT command appears before any IMPORT commands that reference it