I have a db2 query that contains multiple joins involving 4 or 5 tables. How do I implement it in DataStage? Do I have to have individual 'JOIN STAGE' for each of the join queries? or Is there any better way of doing this?
Thanks in Advance.
Regards,
Sethu S
How to implement multiple joins in DataStage?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 83
- Joined: Sat Oct 28, 2006 6:25 am
Re: How to implement multiple joins in DataStage?
Are you working on PX or server edition, will be my first question! But in general to answer your question yes we can implement joins in DS.
sethu_ds wrote:I have a db2 query that contains multiple joins involving 4 or 5 tables. How do I implement it in DataStage? Do I have to have individual 'JOIN STAGE' for each of the join queries? or Is there any better way of doing this?
Thanks in Advance.
Regards,
Sethu S
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
But the subtopic tells us it's a mainframe job.
The Join stage in mainframe jobs does a pairwise join so, to join five tables you would need to cascade four Join stages.
Probably it's easier to specify the join in the DB2 stage.
The Join stage in mainframe jobs does a pairwise join so, to join five tables you would need to cascade four Join stages.
Probably it's easier to specify the join in the DB2 stage.
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Clarification on the Query
Guyz,
First of all sorry for the late reply..
To clarify my query, Its a MVS job that I am trying to build.
As I had mentioned earlier, it will be involving multiple joins. I would like to know the best way of implementing it.
Thanks,
Sethu S
First of all sorry for the late reply..
To clarify my query, Its a MVS job that I am trying to build.
As I had mentioned earlier, it will be involving multiple joins. I would like to know the best way of implementing it.
Thanks,
Sethu S
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Buried among all the jocularity above is my answer.
The Join stage in mainframe jobs does a pairwise join so, to join five tables you would need to cascade four Join stages.
Probably it's easier to specify the join in the DB2 stage.
The Join stage in mainframe jobs does a pairwise join so, to join five tables you would need to cascade four Join stages.
Probably it's easier to specify the join in the DB2 stage.
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.