INMOD Routine Compatibility with Other Load Utilities - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use FDL-compatible INMOD routines that were created for FastLoad by including the FDLINMOD parameter as the USING (parms) option of the IMPORT command. Using this parameter provides compatible support operations, except for the way checkpointing is performed:
  • 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.

When an INMOD routine with the INFILE specification is 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.