Roll Back Problem in ODBC

[suryadev]

I used ODBC connector PX to insert and update records.

My job has around 30 ODBC connectors for the update and insert

When I run the job, to some part of it the records are updated and inserted in the tables but If all of a sudden the job aborts at some place.


Then some of the tables are loaded and some are not loaded.

But my requirement is If the job aborts none of the tables should be loaded, so there should be a roll back i.e the tables should be the same as before the job run.

any ideas about this issue..?