15.00 - Overview - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

Overview

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 Teradata 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 Teradata Database.

Use INMOD routines to:

  • Select and validate data records before passing them to the Teradata Database
  • Convert fields in data records before passing them to the Teradata 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 Teradata 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.