How implement a dataset join using Job Mainframe

jseclen · Post by **jseclen** » Thu Dec 04, 2003 11:26 am

Hi,

How use a Job Mainframe to make a search between 2 datasets. ..

DataSet1
|
| (search) ---> DataSet Output
|
--> DataSet2

What stage is recommended to make this.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 04, 2003 9:47 pm

If both sources are passive stages, then you can use a Join stage. Otherwise you have to use a Lookup stage. Read about both in the DataStage XE/390 Job Developer's Guide (which is in your DataStage documentation folder installed with your DataStage clients).

jseclen · Post by **jseclen** » Fri Dec 05, 2003 11:04 am

Hi Ray

But in the documentation say that stages (Join and Lookup) use one stage to the dataset and other stage to table but dont say it can be use to join 2 datasets ...

So, i will try with the join stage.

Thanks.