Teradata MultiLoad Task Activity Commands - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
cgb1488824663145.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table lists the Teradata MultiLoad commands that perform task activities.

Teradata MultiLoad Task Activity Commands
Teradata MultiLoad Command Function
BEGIN MLOAD and BEGIN DELETE MLOAD Specifies:
  • The kind of Teradata MultiLoad task to be executed
  • The target tables in Teradata Database
  • The parameters for executing the task
DML LABEL Defines a label and error treatment options for a following group of DML statements.
END MLOAD Indicates completion of Teradata MultiLoad command entries and initiates execution of the task.
FIELD Used with the LAYOUT command to define a field of the data source record that is sent to Teradata Database.
FILLER Used with the LAYOUT command to define a field in the data source record that is not sent to Teradata Database.
IMPORT Identifies the data source, the layout used to describe the data record, and optional conditions for performing DML operations.
LAYOUT Introduces the record format of the data source to be used in the Teradata MultiLoad task. This command is followed by a sequence or combination of FIELD and TABLE commands.
LOGDATA Supplies parameters to the LOGMECH command beyond those needed by the logon mechanism, such as userid and password, to successfully authenticate the user.
LOGMECH Identifies the appropriate logon mechanism by name.
PAUSE ACQUISITION Temporarily suspends the acquisition phase of a Teradata MultiLoad job.
TABLE Used with the LAYOUT command to identify a table whose column names and data descriptions are used as the field names and data descriptions of the data source records.