Page 1 of 1
Where do we set Errors Allowed for oracle stage in Datastage
Posted: Mon Sep 10, 2012 1:56 pm
by Fon Silvers
We see the following in the oracle log file (for example ora.5636216.0.0.log) for a load job using Oracle stage.
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Where do we set this errors allowed =50 ?
How does the Oracle stage know that the limit is 50.
Is there a variable that we can manipulate to make the limit to zero.
Please let me know.
Posted: Mon Sep 10, 2012 2:53 pm
by chulett
50 is the Oracle default for sqlldr and is separate from job warnings. Zero isn't valid but you could set ERRORS=N to a large number as one of the OPTIONS the stage allows you to pass in, I would imagine.
Posted: Tue Sep 11, 2012 8:56 am
by Fon Silvers
Thank you so much for your response.
I couldn't see the whole message since I am not premium member but anyhow I do not see any option in the stage that would allow us to set the errors. We want a small number to set so that job will abort.
These are the only options I see in the stage.
additional connection options.
close and open commands
index mode
disable constaints
truncate
silently drop etc
Do we need to pass the ERRORS as a variable. If yes where do we pass it.
Posted: Tue Sep 11, 2012 9:08 am
by jerome_rajan
Assuming you have a reject link in the target connector, open the connector properties and click on the reject link in the graphic shown in the top left. The properties shown are probably what you are looking for.