Where do we set Errors Allowed for oracle stage in Datastage

Fon Silvers · Post by **Fon Silvers** » Mon Sep 10, 2012 1:56 pm

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.

chulett · Post by **chulett** » Mon Sep 10, 2012 2:53 pm

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.

Fon Silvers · Post by **Fon Silvers** » Tue Sep 11, 2012 8:56 am

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.

jerome_rajan · Post by **jerome_rajan** » Tue Sep 11, 2012 9:08 am

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.