Posted: Thu Feb 06, 2003 6:55 pm
That's exactly what a reference input does.
For example, if you are reading Table1 with your main input (let's call the link "Table1" and the key column "keyvalue"), the reference key expression for accessing Table2 on a reference input link is Table1.keyvalue
Similarly, the reference key expression for accessing Table3 on its reference input link is also Table1.keyvalue
Alternately you could use a UV stage to access the hashed files as UniVerse tables, and construct user-written SQL to have the join performed in the database.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
For example, if you are reading Table1 with your main input (let's call the link "Table1" and the key column "keyvalue"), the reference key expression for accessing Table2 on a reference input link is Table1.keyvalue
Similarly, the reference key expression for accessing Table3 on its reference input link is also Table1.keyvalue
Alternately you could use a UV stage to access the hashed files as UniVerse tables, and construct user-written SQL to have the join performed in the database.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518