what goes to oracle enterprise stage's reject

djoni · Post by **djoni** » Thu Apr 26, 2007 8:04 am

I have an Oracle enterprise output stage in a job. What kind of errors in input records cause the records to go to the reject link of the stage? (the method of the stage is set to Upsert).

DSguru2B · Post by **DSguru2B** » Thu Apr 26, 2007 8:22 am

A bunch of errors. The list is vast. In general, anything thats against the rules of table definition will be rejected. Like data truncation errors, date format incorrect, fk constraints etc. etc.

gbusson · Post by **gbusson** » Thu Apr 26, 2007 8:27 am

Hi,

you can catch the Oracle error code, after the row.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 26, 2007 5:07 pm

The row from the input link plus an extra column called sqlcode.

djoni · Post by **djoni** » Fri Apr 27, 2007 7:48 am

ray.wurlod wrote:The row from the input link plus an extra column called sqlcode. ...

Can you please send me a small job that demonstrates a case, any simple one, where a bad input record goes to the reject link? With two input records, one bad, one good, and the Oracle table's DDL (two or three column).
My email is djonid@gmail.com.
Thanks a lot.
Djoni

sud · Post by **sud** » Fri Apr 27, 2007 8:51 am

djoni wrote:
ray.wurlod wrote:The row from the input link plus an extra column called sqlcode. ...
Can you please send me a small job that demonstrates a case, any simple one, where a bad input record goes to the reject link? With two input records, one bad, one good, and the Oracle table's DDL (two or three column).
My email is djonid@gmail.com.
Thanks a lot.
Djoni

I just shared your email with a friend who loves to bust mail servers with spam

DSguru2B · Post by **DSguru2B** » Fri Apr 27, 2007 9:08 am

your funny sud

djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible.
Your query is not that hard, at all. Pass two records with identical primary keys to a table with insert option. One will be inserted, the other will go down the reject link.

sud · Post by **sud** » Fri Apr 27, 2007 9:10 am

DSguru2B wrote:your funny sud

haha hey djoni .. sorry, cudnt resist the temptation of cracking a joke

djoni · Post by **djoni** » Fri Apr 27, 2007 1:16 pm

sud wrote:
DSguru2B wrote:your funny sud
haha hey djoni .. sorry, cudnt resist the temptation of cracking a joke

IBM Support said the reject link did not work!!!

djoni · Post by **djoni** » Fri Apr 27, 2007 1:17 pm

DSguru2B wrote:your funny sud
djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible.
Your query is not that hard, at all. Pass two records with identical primary keys to a table with insert option. One will be inserted, the other will go down the reject link.

Even IBM Support could never make it work

djoni · Post by **djoni** » Fri Apr 27, 2007 1:19 pm

DSguru2B wrote:your funny sud
djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible.
Your query is not that hard, at all. Pass two records with identical primary keys to a table with insert option. One will be inserted, the other will go down the reject link.

It's OK. Good luck with your friends trying to crack gmail

sud · Post by **sud** » Fri Apr 27, 2007 2:13 pm

djoni wrote:
sud wrote:
DSguru2B wrote:your funny sud
haha hey djoni .. sorry, cudnt resist the temptation of cracking a joke
IBM Support said the reject link did not work!!!

You are kidding ! It works and works big time. Just try it!!

DSguru2B · Post by **DSguru2B** » Fri Apr 27, 2007 2:22 pm

For primary key being the same for two or more records, if you use Upsert method then you might not see rejects as the very first one will be inserted and the second and so on, will be updates. Choose upsert method and then you will see. I am surprised IBM said the reject does not work.

djoni · Post by **djoni** » Fri Apr 27, 2007 2:51 pm

DSguru2B wrote:For primary key being the same for two or more records, if you use Upsert method then you might not see rejects as the very first one will be inserted and the second and so on, will be updates. Chose load or just insert method and then you will see. I am surprised IBM said the reject does not work.

When you have a reject link with Load, you can never remove the warning sign on the stage!
The reject link is applicable for Upsert only, applicable but does not work, that's it

sud · Post by **sud** » Fri Apr 27, 2007 2:58 pm

When you have a reject link with Load, you can never remove the warning sign on the stage!
The reject link is applicable for Upsert only, applicable but does not work, that's it

All jokes apart, it WORKS. And yes, you are right, it is applicable only for upsert mode. Just try it, everybody uses it !! And, a sample from anyone will not help you since the db connections won't be valid at your end. Infact, what you are totally ignoring is that this is one of the most simple things to do. So just give it a try and if it doesn't work, we will walk you through it.