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.