INMOD and OUTMOD Routines - FastExport

Teradata® FastExport Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
jaa1691573250507.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
rto1478610027076
Product Category
Teradata Tools and Utilities
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.

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