Generating Routines - 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

The following table lists three sample program files which are provided with Teradata MultiLoad software that help generate and use INMOD, and Notify Exit routines in Teradata MultiLoad job scripts on workstation-attached Windows client systems. The listings of these sample files are presented later.

Sample INMOD and Notify Exit Programs 
Sample File Description
mlimod.c Source file for an INMOD routine
mlnotf.c Source file for a Notify Exit routine
going Source file for a Notify Exit extended object Name routine

Refer to the referenced sample file listings and use the following procedure to generate and use an INMOD or Notify Exit routine in the Teradata MultiLoad job:

  1. Edit the routine source file and make sure that the dynamn name is a __declspec.

    See the listing of the sample routine files later:

    • mlimod.c
    • mlnotf.c
  2. Use the following command to create a DLL:

    cl.exe /nologo /MTd /W3 /Zp1 /c /O2 -D _WINDOWS -D _MBCS -D _USRDLL -D _CRT_SECURE_NO_DEPRECATE -D WIN64 -D _WIN64 -D WIN32 -D TA_nt_x8664=1 /Fo sourcefilename.obj sourcefilename.c

    link.exe -largeaddressaware -incremental:no -nologo /machine:X64 -dll -subsystem:windows,5.02 /out:sourcefilename.dll sourcefilename.obj

    where sourcefilename is the name of the INMOD or Notify Exit routine source file. Successful command execution produces a file with the same name as the source file with the .dll file extension, as:

    sourcefilename.dll

    Successful command execution produces a file with the same name as the source file with the .dll file extension, as:

    sourcefilename.dll

  3. Use the sourcefilename.dll file name in the Teradata MultiLoad job script as follows:
    Routine Type Use the sourcefilename.dllFile as the
    INMOD INMOD modulename specification in the IMPORT of the Teradata MultiLoad job script.
    Notify Exit EXIT name specification of the NOTIFY option in the BEGIN MLOAD or BEGIN DELETE MLOAD command of the Teradata MultiLoad job script.