How to Abort a DS job based on a condition

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
DSFreddie
Participant
Posts: 130
Joined: Wed Nov 25, 2009 2:16 pm

How to Abort a DS job based on a condition

Post by DSFreddie »

Hi All,

I have a requirement in my project where I need to abort a DS job based on a condition. ( If field.A not equal to field.B, then Abort the job).

The use of Sequencer is ruled out as I dont want to use one for just one job.

Thanks for your inputs.

Regards,
Freddie.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Transformer to detect condition and send row to a reject link on which you institute a row limit of 1.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
DSFreddie
Participant
Posts: 130
Joined: Wed Nov 25, 2009 2:16 pm

Post by DSFreddie »

Thanks Ray for your quick response.

However, I am given this task & instructed not to use a Transformer stage.

Is there any other way (through any other stage) to do it ?

(FYI Pls. The transformer stage/Sequencer/Routines-Scripts shouldnt be used)

Thanks,
Freddie
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is no other way.

<rant>Resist stupid requirements!</rant>
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If "they" think that it can be done, demand to know how.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
swapnilverma
Participant
Posts: 135
Joined: Tue Aug 14, 2007 4:27 am
Location: Mumbai

Post by swapnilverma »

brain teasers ?
Thanks
Swapnil

"Whenever you find whole world against you just turn around and Lead the world"
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Misplaced Transformer fear, I'd wager.
-craig

"You can never have too many knives" -- Logan Nine Fingers
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

How about using a filter to an abort operator?

Must be really irrational to include sequencers, routines and scripts along with transformers. I've seen odd reasons for restricting other stages as well :roll:

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Maybe it's an interview question.

I'll bet a small amount that, when "they" are presented with the Wrapped stage possibility, that they exclude that too.

You could always have an operator watch the values go by and pull the power plug when they see a bad value.
:wink:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

Hey, a hardware interface! I like it :P
- james wiles


All generalizations are false, including this one - Mark Twain.
Post Reply