DSXchange

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

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

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.

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.

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...

Rats!

Somehow, I would have expected you to say Rattus!

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

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.