Looping in DataStage Jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
Looping in DataStage Jobs
Hi !
I have x number of conditions that I need to check. And if first condition passes, I don't need to go to the next one, otherwise I have to check the next condition, so on until all x conditions are checked.
x is a varibale .
Can anyone suggest me a way of achieving this in DataStage?
Any help is appreciated.
Thanks
S.
I have x number of conditions that I need to check. And if first condition passes, I don't need to go to the next one, otherwise I have to check the next condition, so on until all x conditions are checked.
x is a varibale .
Can anyone suggest me a way of achieving this in DataStage?
Any help is appreciated.
Thanks
S.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
You may have to write a routine for that.
But what is the controlling factor and where do you intend to store the list of conditions? How do you plan to use them?
Will they always use only one column or will multiple column come into picture?
You have loads of questions to answer before going down this route.
But what is the controlling factor and where do you intend to store the list of conditions? How do you plan to use them?
Will they always use only one column or will multiple column come into picture?
You have loads of questions to answer before going down this route.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
You may have to write a routine for that.
But what is the controlling factor and where do you intend to store the list of conditions? How do you plan to use them?
Will they always use only one column or will multiple column come into picture?
You have loads of questions to answer before going down this route.
But what is the controlling factor and where do you intend to store the list of conditions? How do you plan to use them?
Will they always use only one column or will multiple column come into picture?
You have loads of questions to answer before going down this route.
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
He could, but he won't. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met. We're not going to set any precedent that might undermine that, because we want to see DSXchange continue. Premium membership is not expensive, at less than 30c (Rs12) per day.datastagenewbie wrote:Sainath.Srinivasan,
I can't see your complete message, bcoz I am not a premium member. Is there anyway you can not classify it as a premium content. Thanks!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 17
- Joined: Tue Jun 23, 2009 6:44 pm
Re: Looping in DataStage Jobs
hi,
you can implement that loop condition with if else condition along with the logical operators in transformer stage.
if else condition for both input data and reference data.
Regards
Suresh
you can implement that loop condition with if else condition along with the logical operators in transformer stage.
if else condition for both input data and reference data.
Regards
Suresh
datastagenewbie wrote:Hi !
I have x number of conditions that I need to check. And if first condition passes, I don't need to go to the next one, otherwise I have to check the next condition, so on until all x conditions are checked.
x is a varibale .
Can anyone suggest me a way of achieving this in DataStage?
Any help is appreciated.
Thanks
S.
Suresh Angadi
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom