INMOD and Notify Exit Routines | Overview | Teradata FastLoad - 17.10 - Overview - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

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

INMOD Routines

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

When an INMOD routine is specified in the DEFINE command, it is the named routine, rather than a data source, that provides the input data records that Teradata FastLoad loads into the Teradata FastLoad table on the database.

Use INMOD routines to perform the following tasks:
  • Select and validate data records before passing them to the database
  • Convert fields in data records before passing them to the database
  • Read data directly from different database system data sets, such as IMS, TOTAL, and so on, and create and pass a consolidated data record to the database without using an intermediate tape or disk data set.

Notify Exit Routines

A Notify Exit routine specifies a predefined action to be performed whenever certain significant events occur during a Teradata FastLoad 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 routine in C (without using CLIv2) and using the NOTIFY command, a routine to detect whether a Teradata FastLoad job succeeds or fails, how many records were loaded, what the return code is for a failed job, and so on can be provided.