Code Example - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
16.20
Published
November 2020
Language
English (United States)
Last Update
2020-11-19
dita:mapPath
ghk1527114222323.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following macro was defined prior to execution:

create macro ins_row
(
    p1 integer,
    p2 varchar(32000)
)as(
   insert into table1
   (col1,col2)
   values(:p1,:p2);
);

For the Stream driver, add this EXECUTE statement to the DML group:

EXECUTE ins_row INSERT;

And this schema is built:

Schema * strSchema=new Schema(“input”);
strSchema->AddColumn(“col1”,TD_INTEGER,4);
strSchema->AddColumn(“col2”,TD_VARCHAR, 32000);
strConn->AddSchema(strSchema);