We are loading multiple Teradata tables through a single job.
While loading if the job fails then all the records which were inserted in the other tables in the same run should be rolled back. .i.e either all the records should be inserted in all the tables or no records should be inserted in any of the table at all.
Please suggest which stages to be used in DataStage Server job to achieve the same
apply table locks in teradata through DataStage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's fine, but it does not give you any rollback capabilities on the set of tables. You have to design another job to "undo" committed transactions on the other tables.
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.