Page 1 of 1

TD Connector:After SQL

Posted: Fri Feb 08, 2019 3:59 am
by kumar66
Hi All,

Kindly clarify the below on Teradata Connector:

I have a job that writes to TD . First step is to insert the data to temp table and in after sql we are reading the data from temp table and insert into main table

For instance if the After SQL statement fails in the middle of the execution , for instance after inserting 100 records , those records will be committed or roll backed.

The properties in the TD Connector stage will be applicable to the After Sql as well ?

Please Advice.

Posted: Sun Feb 10, 2019 10:38 pm
by ray.wurlod
How have you set up transaction handling?

Posted: Tue Feb 12, 2019 5:20 am
by kumar66
Hi Ray,

The Transaction is set to '0'.

Thanks.