Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
abc123
Premium Member
Posts: 605 Joined: Fri Aug 25, 2006 8:24 am
Post
by abc123 » Wed Jun 04, 2014 1:22 pm
Some Oracle errors are interpreted as warnings.
I know that I can set the warning limit to 1 so that the first warning is treated as an error no matter what the warning is for.
Is there a way to promote specific warnings to fatal errors?
Damonsal
Premium Member
Posts: 16 Joined: Wed May 07, 2014 11:29 am
Post
by Damonsal » Wed Jun 04, 2014 2:05 pm
what is you requirement, why you want to do this way ?
abc123
Premium Member
Posts: 605 Joined: Fri Aug 25, 2006 8:24 am
Post
by abc123 » Wed Jun 04, 2014 2:23 pm
For specific Oracle errors such as unique constraint errors, I would like it be promoted to a fatal error on the first one.
abc123
Premium Member
Posts: 605 Joined: Fri Aug 25, 2006 8:24 am
Post
by abc123 » Thu Jun 05, 2014 7:19 am
Any thoughts any one? Is there anyway to may be capture the text of the warning and raise a fatal error from within a job?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Jun 05, 2014 7:24 am
Are you sure you need this only for certain warnings? I seem to recall an option in most Oracle stages to 'Treat warnings as Fatal', hence the question.
-craig
"You can never have too many knives" -- Logan Nine Fingers
abc123
Premium Member
Posts: 605 Joined: Fri Aug 25, 2006 8:24 am
Post
by abc123 » Thu Jun 05, 2014 7:41 am
The Oracle stage has that option but that would be for all warnings. Is there any way to do this for specific warnings? Otherwise that's what I'll have to go with. Can I may be write a routine?