Code Example - Parallel Transporter

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