Procedure - 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

Procedure

A complete Teradata MultiLoad job includes:

  • Invoking Teradata MultiLoad
  • Logging on to Teradata Database and establishing the Teradata MultiLoad support environment
  • Specifying the Teradata MultiLoad tasks
  • Logging off from Teradata 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 Table 26.

     

    Table 26: 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 Teradata Database

    LOGTABLE

    Specify the restart log table that will maintain 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 Teradata Database.

    Note: 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 Teradata Database.
  • 3 Specify the Teradata MultiLoad task as shown in Table 27.

     

    Table 27: 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 Teradata Database.

    UPDATE

    Change the field values in existing rows of the target tables or views.

    4 To specify another Teradata MultiLoad task:

    a Use the support commands listed in Step 2 to modify the Teradata MultiLoad support environment for the next task.

    b 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 Teradata Database and terminate Teradata MultiLoad on the client system.