15.10 - Overview - MultiLoad

Teradata MultiLoad Reference

prodname
MultiLoad
vrm_release
15.10
category
Programming Reference
featnum
B035-2409-035K

Overview

This section describes the different types of routines and when to use them.

Note: 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.

    For example, by writing an exit in C (without using CLIv2) and using the NOTIFY...EXIT option of the BEGIN MLOAD command, a routine to detect whether a Teradata MultiLoad job succeeds or fails, how many records were loaded, what the return code was for a failed job, and so on can be provided.