Datastage warnings with Oracle

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

Post Reply
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Datastage warnings with Oracle

Post by abc123 »

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
Premium Member
Posts: 16
Joined: Wed May 07, 2014 11:29 am

Post by Damonsal »

what is you requirement, why you want to do this way ?
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Post by abc123 »

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
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Post by abc123 »

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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Post by abc123 »

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?
Post Reply