HI
We are using Parallel Job for Loading Some data in to Oracle Tables .
Lets say there are total 100 rows to load in to the Table ,for some reason It has loaded only 50 rows and how can we Rollback these rows from datastage as it is Half done.
Loading Problem
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Whether or not you can roll them back depends on your commit strategy. If you're using auto-commit, for example, the answer is clearly no - each row that has been inserted has also been committed. In this case you need a strategy for undoing the inserts. On the other hand, if you've specified that the entire load is a single transaction and this does not complete successfully, DataStage itself will issue the rollback request.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.