15.10 - Description - MultiLoad

Teradata MultiLoad Reference

Programming Reference


The Teradata MultiLoad utility is an efficient way to deal with batch maintenance of large databases. Teradata MultiLoad is a command-driven utility for fast, high-volume maintenance on multiple tables and views in Teradata Database.

A single Teradata MultiLoad job performs a number of different import and delete tasks on database tables and views:

  • Each Teradata MultiLoad import task can do multiple data insert, update, and delete functions on up to five different tables or views.
  • Each Teradata MultiLoad delete task can remove large numbers of rows from a single table.
  • Use Teradata MultiLoad to import data from:

  • Disk or tape files (using a custom Access Module) on a mainframe-attached client system
  • Input files on a network-attached workstation
  • Special input module (INMOD) programs written to select, validate, and preprocess input data
  • Access modules
  • Any device providing properly formatted source data
  • The table or view in the database receiving the data can be any existing table or view for which privileges for maintenance tasks have been granted.

    Note: Full tape support is not available for any function in Teradata MultiLoad for network-attached client systems. To import data from a tape, a custom access module that interfaces with the tape device must be written. For information about how to write a custom access module, L the Teradata Tools and Utilities Access Module Programmer Guide (B035‑2424).