Programming Structure

Teradata Parallel Data Pump Reference

brand
Teradata Tools and Utilities
prodname
Parallel Data Pump
vrm_release
15.00
category
Programming Reference
featnum
B035-3021-034K

Programming Structure

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

 

Table 32: Programming Routines by Language 

Routine Language

Programming Structure

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 UNIX OS
  • Second parameter:

    struc
              long  seqnum;
              short parmlen;
              char  parm[80];
            }

    COBOL

    First parameter:

    01 INMODRECORD.
           03 RETURNCODE PIC S9(9) COMP.
           03 RECORDLENGTH PIC 9(9) COMP.
           03 RECORDBODY PIC X(xxxxx)

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

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

    01 PARMSTRUCT.
           03 SEQNUM PIC 9(9) COMP.
           03 PARMLEN PIC 9(4) COMP.

           03 PARMBODY 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 TPump LAYOUT command and subsequent FIELD, FILLER, and TABLE commands.