DSXchange

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).

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.

Hi,

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

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

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

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

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.

DSguru2B wrote:your funny sud

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

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!!!

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

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

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!!

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.

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

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.