Sequence If then else logic

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
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Sequence If then else logic

Post by tbtcust »

Hi all

I want to create Parent Sequence (ParentSeq) and three child Sequence (ChildSeq1, ChildSeq2, and ChildSeq3)

I want to pass ParentSeq a parameter and based on that parameter I execute either ChildSeq1, ChildSeq2, or ChildSeq3. Is this possible?

Thanks in advance for any help.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The Nested Condition stage is what you need. Check the job parameter value in the triggers to the child Job Activity stages, make sure they are mutually exclusive.
-craig

"You can never have too many knives" -- Logan Nine Fingers
mail2hfz
Premium Member
Premium Member
Posts: 92
Joined: Thu Nov 16, 2006 8:51 am

Post by mail2hfz »

I guess you can go for Nested condition stage in sequences. In Triggers tab place your parameter condition and branch it to respective Job sequences.
Create a sequence job with nested stage as the first one and three of your child sequences as the triggers for this stage. Call this sequence from your master/primary sequnce and supply your parameter in this sequence.
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Post by tbtcust »

Thanks chulett. That worked fine.
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Post by tbtcust »

Thanks chulett. That worked fine.
Post Reply