Hi All,
My job design Dataset---> Transformer stage----> ODBC stage or OCI (Oracle).
Source has 3000 records, my job is aborted after loading in 1500 records. How to load the remaining records in my target Oracle table?
Another question: I want to load records if the job successfully completes. Is there any option for that in DataStage?
Thanks in Advance.
Job Aborted after loading 1500 records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
We are just guessing as to the likely cause without getting the detailed error message from you. The specific SQL or database error message. It could be your transaction log filling up or any one of a number of possible errors.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>