We are working on Parallel extender on 8.1 on the AIX environment.
We are using ODBC enterprise stage to read and load data into MS SQL Sever 2005 tables.
How do we set commit intervals in this stage?
We will want commit to happen only after the entire load is complete. Incase the job fails due to various reasons, no record should get committed to the target table.
I am sure there must be a way out and requesting experts to help us out.
Thanks in advance
Commit intervals in ODBC Enterprise stage
Moderators: chulett, rschirm, roy
-
anitha_casturi
- Participant
- Posts: 21
- Joined: Wed Jun 30, 2004 3:48 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: