Procedure - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities
A complete Teradata MultiLoad job includes:
  • Invoking Teradata MultiLoad
  • Logging on to the database and establishing the Teradata MultiLoad support environment
  • Specifying the Teradata MultiLoad tasks
  • Logging off from the database and terminating Teradata MultiLoad.

Use the following procedure as a guide in writing Teradata MultiLoad job scripts.

  1. Invoke Teradata MultiLoad, specifying run-time options:
    • Normal or abbreviated (brief) printout
    • Character set
    • Alternate error message file
    • Standard input file/device
    • Standard output file/device
    • Alternate run file
  2. Establish the Teradata MultiLoad support environment as shown in the following table.
    Teradata MultiLoad Support Environmental Commands  
    Command Description
    ACCEPT Specify an external data source file and character fields for setting utility variables for a Teradata MultiLoad job.
    DATEFORM Specify the form of the DATE data type specifications for the Teradata MultiLoad job.
    DISPLAY Write a specified text message to a specified file.
    IF, ELSE, and ENDIF Provide conditional control of the execution process.
    LOGON Establish a session with the database.
    LOGTABLE Specify the restart log table that maintains checkpoint information for the Teradata MultiLoad job.
    ROUTE MESSAGES Specify an alternate destination for Teradata MultiLoad utility output messages.
    RUN FILE Transfer processing control to an alternate run file.
    SET Assign a value to a specific utility variable for the Teradata MultiLoad job.
    SYSTEM Submit an operating system command to the client system.
    Teradata SQL statements Submit a supported Teradata SQL statement to the database.
    As a minimum, this part of the Teradata MultiLoad job must include:
    • A LOGTABLE command to specify the restart log table.
    • A LOGON command to provide a logon string that is used to connect all Teradata SQL and Teradata MultiLoad utility sessions with the database.
  3. Specify the Teradata MultiLoad task as shown in the following table.
    Commands that Specify Teradata MultiLoad Tasks 
    Command Description
    BEGIN MLOAD and BEGIN DELETE MLOAD Signify the beginning of a Teradata MultiLoad import or delete task.
    DELETE Remove rows from the target tables or views.
    DML LABEL Specify a label and error treatment options for one or more immediately following INSERT, UPDATE, or DELETE commands.
    END MLOAD Signify the end of the Teradata MultiLoad task and initiate the task processing.
    FIELD Specify a field of the input record to be used to supply values for variables in the SELECT statement.
    FILLER Describe a field of the input data record that is not referenced, but used only to indicate the relative position of the following FIELD command data.
    IMPORT Specify either a file name or an INMOD routine as the input data source, referencing a previously specified LAYOUT command.
    INSERT Add new rows to the target tables or views.
    LAYOUT Specify, in conjunction with immediately following FIELD, FILLER, or TABLE commands, the layout of the input data records on the client system. (Reference this layout specification in a subsequent IMPORT command.)
    PAUSE ACQUISITION Pause an import task during the acquisition phase.
    TABLE Specify a table whose column names and data descriptions are used with the data records sent to the database.
    UPDATE Change the field values in existing rows of the target tables or views.
  4. To specify another Teradata MultiLoad task:
    1. Use the support commands listed in Step 2 to modify the Teradata MultiLoad support environment for the next task.
    2. Use the task commands listed in Step 3 to specify the next task.

    Repeat these steps for each task in a Teradata MultiLoad job.

  5. Use the LOGOFF command to disconnect all active sessions with the database and terminate Teradata MultiLoad on the client system.