Page 2 of 2
Posted: Fri Apr 27, 2007 3:47 pm
by djoni
sud wrote: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.
Adjusting the db connection is easy, so email me your job that works
Posted: Fri Apr 27, 2007 3:55 pm
by sud
Posted: Fri Apr 27, 2007 4:01 pm
by djoni
whenever I request IBM support, they ask for the jobs to reproduce the problems at their installations, all types of jobs
Posted: Fri Apr 27, 2007 7:31 pm
by DSguru2B
You are right. Load wont work as it utliizes the sql loader. I have fixed my original post.
djoni, try to build a job at your current site in which you think the records should be rejected. Send that to IBM.
Posted: Sat Apr 28, 2007 3:34 am
by nick.bond
whenever I request IBM support, they ask for the jobs to reproduce the problems at their installations, all types of jobs
what do you mean by that? are you implying that these people who are helping you for free should also send you any job you request?
Posted: Sat Apr 28, 2007 6:50 am
by chulett
djoni wrote:sud wrote: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.
Adjusting the db connection is easy, so email me your job that works
nick.bond wrote:djoni wrote:whenever I request IBM support, they ask for the jobs to reproduce the problems at their installations, all types of jobs
what do you mean by that? are you implying that these people who are helping you for free should also send you any job you request?
It certainly seems that way.
Posted: Sat Apr 28, 2007 7:30 pm
by djoni
chulett wrote:djoni wrote:sud wrote: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.
Adjusting the db connection is easy, so email me your job that works
nick.bond wrote:djoni wrote:whenever I request IBM support, they ask for the jobs to reproduce the problems at their installations, all types of jobs
what do you mean by that? are you implying that these people who are helping you for free should also send you any job you request?
It certainly seems that way.
It's up to us invidividually, I just got one for this case. I have sent quite a few to those who need helps.
Posted: Sun Sep 13, 2009 1:18 pm
by Shashwat
Just disable the RCP option and send the few fields to the oracle enterprise and not the omplete struture of the table. You will see that all the rows go to reject file ionstead of table without warnings
Posted: Sun Sep 13, 2009 4:56 pm
by chulett
Hmmm... two and a half years later, they've probably moved on to other issues by now.
Posted: Tue Sep 15, 2009 11:09 am
by Sreenivasulu
Cool down joni...cool down.
This is a site where ideas are exchanged for free not fee
Posted: Tue Sep 15, 2009 11:10 am
by Sreenivasulu
Cool down joni...cool down.
This is a site where ideas are exchanged for free not fee
