Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
mallikharjuna
Participant
Posts: 81 Joined: Thu Nov 30, 2006 7:46 am
Location: india
Post
by mallikharjuna » Mon Sep 06, 2010 12:58 am
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.
Sreenivasulu
Premium Member
Posts: 892 Joined: Thu Oct 16, 2003 5:18 am
Post
by Sreenivasulu » Mon Sep 06, 2010 1:26 am
You can set the transaction size. Setting it to 0 means ALL / None approach
Regards
Sreeni
mallikharjuna
Participant
Posts: 81 Joined: Thu Nov 30, 2006 7:46 am
Location: india
Post
by mallikharjuna » Mon Sep 06, 2010 2:07 am
Sreenivasulu wrote: You can set the transaction size. Setting it to 0 means ALL / None approach
any other way?
MALLI
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Sep 06, 2010 6:43 am
Any other way to answer your second question? No.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Mon Sep 06, 2010 10:25 am
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.