Hi
For rejecting rows purpose we are maintaining Errortable_log
in this table fields like Error_number,Errordescription,someotherfields.
here through linkvariable DBMSCode i am capturing Errornumber Ex:like
ORA-0091 like that but I have to capture error_description along with number like Uniquekey constraint vialation or primary key whatever Error number along with error description with out hardcoding.please give me the help on this.
Regards
y.srini.
how to capture Errordescription into ErrorTable
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, it doesn't... or at least I haven't seen that returned anywhere from an OCI stage. Give it a shot and let us know. Typically I believe you will find that you have to farm that, post job, from the job logs. ![Confused :?](./images/smilies/icon_confused.gif)
Glad to be proven wrong!
![Confused :?](./images/smilies/icon_confused.gif)
Glad to be proven wrong!
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It does from ODBC stage.
Another possibility would be to execute an oerr command to translate the code into text. Sometimes the text, with both explanation and recommendation, can be a tad long-winded however.
![Wink :wink:](./images/smilies/icon_wink.gif)
Another possibility would be to execute an oerr command to translate the code into text. Sometimes the text, with both explanation and recommendation, can be a tad long-winded however.
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.