Usage Notes - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
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