Overview - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

This section describes the different types of input modification (INMOD) and Notify Exit routines, and when and how to use them.

User exits (INMOD and Notify Exit) should not make calls to the Teradata Call Level Interface (CLIv2) because it might cause the normal operation of the utility to behave with unexpected results and prevent requests from completing normally.

INMOD Routines

The term INMOD is an acronym for input modification routines. These are user-written routines that Teradata MultiLoad and other load/export utilities can use to provide enhanced processing functions on input records before they are sent to the database.

Use an INMOD routine to supply input records or to perform preprocessing tasks on the input records before passing them to Teradata MultiLoad. For example, such tasks could:
  • Generate records to be passed to Teradata MultiLoad
  • Read data directly from one or more database systems
  • Validate data records before passing them to Teradata MultiLoad
  • Convert fields in a data record before passing it to Teradata MultiLoad

Notify Exit Routines

An exit routine specifies a predefined action to be performed whenever certain significant events occur during a Teradata MultiLoad job.

Notify Exit routines are especially useful in operator-free environments, where job scheduling relies heavily on automation to optimize system performance.