Programming Structure - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
oqw1608578437373.ditamap
dita:ditavalPath
ovd1619195504008.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.