DSXchange

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.

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

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.