Overview - FastExport

This section describes the different types of routines and when they might be used.

INMOD and OUTMOD Routines

The terms INMOD and OUTMOD are acronyms for input modification and output modification routines. These are user‑written routines that FastExport and other load/export utilities can call to provide enhanced processing functions on:

Input records before they are sent to Teradata Database (INMOD routines)

Output records before they are sent to the client system (OUTMOD routines)

Table 14 illustrates how FastExport supports both INMOD and OUTMOD routine calls in the FastExport job script.

Table 14: INMOD and OUTMOD Routines 

FastExport Command	Specify	Write to Routine
IMPORT	INMOD	Read and preprocess input data values from files on the client system. These would then provide the USING data for a subsequent SELECT statement.
EXPORT	OUTMOD	Validate and preprocess export data records from Teradata Database before writing them to files on the client system.

Notify Exit Routines

A notify exit routine specifies a predefined action to be performed whenever certain significant events occur during a FastExport 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 EXPORT command, a routine can be provided to detect whether a FastExport job succeeds or fails, how many records are exported, the return code for a failed job, and so on.

Note: User exits (INMOD and Notify Exit) should not make calls to the Teradata Call Level Interface (CLIv2). It can cause the normal operation of the utility to behave with unexpected results, and prevent requests from completing normally.