DSXchange

Posted: **Thu Jan 30, 2003 1:27 am**

Hi All,

I am using stage constraint and abort rows as 1. When I run the job it stops immd when it violates the constraint but also it commits all the records till it processed. I don't want that to happen. Any chance of getting rollback in this if one record violates the constraint.

I am using oracle database. and the Rows per transactions is set to 0.

Kamal

Posted: **Thu Jan 30, 2003 3:19 am**

Did you enable transaction grouping in your OCI Stage?

Posted: **Thu Jan 30, 2003 3:53 am**

Hi Uneumann,

Iam Using 5.2 and Row per Transactions is set to '0'. I did't get what you are mention about Transaction Grouping, Kindly clear this.
Thanks,

Kamal

Posted: **Thu Jan 30, 2003 4:07 pm**

Transaction grouping is only relevant where there is more than one input link into the stage driving Oracle.

DSXchange

Oracle Commit...

Oracle Commit...