How to implement multiple joins in DataStage?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sethu_ds
Participant
Posts: 2
Joined: Wed Nov 08, 2006 2:40 am

How to implement multiple joins in DataStage?

Post by sethu_ds »

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
tagnihotri
Participant
Posts: 83
Joined: Sat Oct 28, 2006 6:25 am

Re: How to implement multiple joins in DataStage?

Post by tagnihotri »

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

Post by chulett »

You'll notice the post is marked as a TX question... those really need to go in the proper forum to get any attention from the TX folks that hang out here.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

ray.wurlod wrote:But the subtopic tells us it's a mainframe job.
Doh! Hard to find the cheese at the end of this maze...
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Rats! :lol:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Somehow, I would have expected you to say Rattus! :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
sethu_ds
Participant
Posts: 2
Joined: Wed Nov 08, 2006 2:40 am

Clarification on the Query

Post by sethu_ds »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply