Programming Structure - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

Programming Structure

Table 21 defines the structure by programming language for communicating between Teradata MultiLoad and INMOD or notify exit routines.

 

Table 21: Programming Routines by Language 

For routines written in

the programming structure for each parameter is

Assembler

First parameter:

RRECORD  DSECT
RTNCODE  DS   F
RLENGTH  DS   F
RBODY    DS   CLxxxxx

Note: In the RBODY specification, the body length xxxxx is:

  • 32004 for Teradata for Windows
  • 64004 for Teradata Database for UNIX
  • Second parameter:

    IPARM    DSECT
    RSEQ     DS   F
    PLEN     DS   H
    PBODY    DS   CL100

    C

    First parameter:

    struct {
              long Status;
              long RecordLength;
              char buffer[xxxxx];
            }

    Note: In the char buffer specification, the buffer length xxxxx is:

  • 32004 for Teradata for Windows
  • 64004 for Teradata Database for a UNIX OS
  • Second parameter:

    struct {
              long  seqnum;
              char  parm[80];
            }

    COBOL

    First parameter:

    01 INMOD-RECORD.
           03 RETURN-CODE PIC S9(9) COMP.
           03 RECORD-LENGTH PIC 9(9) COMP.
           03 RECORD-BODY PIC X(xxxxx)

    Note: In the RECORD-BODY specification, the body length xxxxx is:

  • 320004 for Teradata for Windows
  • 64004 for Teradata Database for UNIX
  • Second parameter:

    01 PARM-STRUCT.
           03 SEQ-NUM PIC 9(9) COMP.
           03 PARM-LEN PIC 9(4) COMP.
           03 PARM-BODY PIC X(80).

    PL/I

    First parameter:

    DCL 1 PARMLIST,
             10 STATUS FIXED BINARY(31,0)
             10 RLENGTH FIXED BINARY(31,0)
              10 REC CHAR(xxxxx)

    Note: In the REC CHAR specification, the length xxxxx is:

  • 32004 for Teradata for Windows
  • 64004 for Teradata Database for UNIX
  • Second parameter:

    DCL 1 PARMLIST,
             10 SEQNUM FIXED BINARY(31,0)
             10 PLENGTH FIXED BINARY(15,0)
             10 PBODY CHAR(80)

    In each structure, the records must be constructed so that the left-to-right order of the data field corresponds to the order of the field names specified in the Teradata MultiLoad LAYOUT command and subsequent FIELD, FILLER, and TABLE commands.

    Table 22 shows the entry points for notify exit routines.

     

    Table 22: Entry Points for Notify Exit Routines 

    Routine Language

    Entry Point

    IBM C on z/OS platforms

    _dynamn

    C on UNIX and Windows platforms

    _dynamn

    COBOL and PL/I on z/VM and z/OS platforms

    DYNAMN