Overview - FastExport

Teradata FastExport Reference

Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

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 



    Write to Routine



    Read and preprocess input data values from files on the client system. These would then provide the USING data for a subsequent SELECT statement.



    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.