17.10 - Code Example - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Release Date
June 2021
Content Type
Programming Reference
Publication ID
B035-2516-061K
Language
English (United States)

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