TD Connector:After SQL

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kumar66
Participant
Posts: 265
Joined: Thu Jul 26, 2007 12:14 am

TD Connector:After SQL

Post 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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How have you set up transaction handling?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar66
Participant
Posts: 265
Joined: Thu Jul 26, 2007 12:14 am

Post by kumar66 »

Hi Ray,

The Transaction is set to '0'.

Thanks.
Post Reply