Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
nkln@you
Premium Member
Posts: 271 Joined: Wed Nov 17, 2004 5:15 am
Location: US
Post
by nkln@you » Fri Aug 11, 2006 4:54 am
I need to store Oracle Errors in an error table. By using DBMS code we can store the Oracle Error code. But i need to store the description of that code also. i.e if 0RA-0001 ERROR occurs, i need to store unique constraint error also. Is there any way to do this in Datastage
Aim high
kumar_s
Charter Member
Posts: 5245 Joined: Thu Jun 16, 2005 11:00 pm
Post
by kumar_s » Fri Aug 11, 2006 5:35 am
Search for title
"Capturing ORACLE error", Hope this should help your requriement.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Aug 11, 2006 6:52 am
Or you might consider looking those up from another source rather then farming the logs just for that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Aug 11, 2006 10:37 pm
Use output link variables DBMSCODE and LASTERR. LASTERR contains the text.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Aug 11, 2006 10:45 pm
Not for Oracle.
-craig
"You can never have too many knives" -- Logan Nine Fingers