Teradata MultiLoad Task Activity Commands - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata MultiLoad Task Activity Commands

Table 4 lists the Teradata MultiLoad commands that perform task activities.

 

Table 4: 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.