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 the database (INMOD routines)
- Output records before they are sent to the client system (OUTMOD routines)
The following table illustrates how FastExport supports both INMOD and OUTMOD routine calls in the FastExport job script.
| 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 the 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.
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.