Overview - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
cgb1488824663145.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
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 Teradata 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.