17.00 - Programming Structure - Parallel Data Pump

Teradata® Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-3021-220K

The following table defines the structure by programming language for communicating between Teradata TPump and INMOD or Notify Exit routines.

Programming Routines by Language 
Routine Language Programming Structure
Assembler First parameter:
RRECORD  DSECT
RTNCODE  DS   F
RLENGTH  DS   F
RBODY    DS   CLxxxxx
In the RBODY specification, the body length xxxxx is:
  • 32004 for Teradata for Windows
  • 64004 for Database for UNIX

Second parameter:

IPARM    DSECT
RSEQ     DS   F
PLEN     DS   H
PBODY    DS   CL100
C First parameter:
struct {
          Status;
          int RecordLength;
          char buffer[xxxxx];
        }
In the char buffer specification, the buffer length xxxxx is:
  • 32004 for Teradata for Windows
  • 64004 for Database for UNIX OS

Second parameter:

struc
          int seqnum;
          short parmlen;
          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)
In the RECORD-BODY specification, the body length xxxxx is:
  • 32004 for Teradata for Windows
  • 64004 for 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)
In the REC CHAR specification, the length xxxxx is:
  • 32004 for Teradata for Windows
  • 64004 for 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.