17.00 - Code Example - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.00
Published
November 30, 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
fcz1544831938753.ditamap
dita:ditavalPath
obe1474387269547.ditaval

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);