Hi All,
How do I capture a reject file with sql code and sql error using oracle enterprise edition stage.
I am trying to insert 100,000 records into oracle data base. if there is only 1 bad record it rejects all the 100,000 records with a sql code 1403.
I want to capture only the specific record(s) that get rejected from Oracle enterprise edition stage in the reject file with sql error and sql code. it helps me to debug the data if that is case.
thanks
Mark
capture rejects using Oracle Enterprise edition stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
First off, what Write Mode are you using?
Have you drawn a reject link from the Oracle Enterprise stage? Direct this, through any other stage types you feel to be appropriate, to a Sequential File stage to capture the rejects.
Have you drawn a reject link from the Oracle Enterprise stage? Direct this, through any other stage types you feel to be appropriate, to a Sequential File stage to capture the rejects.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: capture rejects using Oracle Enterprise edition stage
Hi,pavan_test wrote:Hi All,
if there is only 1 bad record it rejects all the 100,000 records with a sql code 1403.
Mark
Can you explain more on this.