- If a Teradata MultiLoad job uses the FROM, FOR, or THRU options to request a range of records from an FDL-compatible INMOD routine, then Teradata MultiLoad bypasses any default record checkpointing.
If the database experiences a restart/ recovery operation, Teradata MultiLoad starts over and gets the records again from the beginning of the range.
Under these same circumstances, if the BEGIN MLOAD command included a CHECKPOINT rate other than 0, Teradata MultiLoad terminates with an error condition.
- If a Teradata MultiLoad job does not request a range of records, then Teradata MultiLoad performs checkpointing either by default or per the job specifications.
If the database experiences a restart/ recovery operation, and the INMOD routine supports recovery, Teradata MultiLoad continues the data acquisition activity from the last recorded checkpoint.
Note, however, that the source sequence numbers generated by Teradata MultiLoad may not correctly identify the sequence in which the INMOD routine supplied the records. The data is still applied correctly, however, despite this discrepancy.
An FDL-compatible INMOD routine with the INFILE specification of a Teradata MultiLoad IMPORT command cannot be specified.
- Teradata MultiLoad performs the file read operation
- The INMOD routine acts as a pass-through filter
The combination of an FDL-compatible INMOD routine with a Teradata MultiLoad INFILE specification is not valid because an FDL-compatible INMOD routine must always perform the file read operation.