More than one record from transform stage

rdy · Post by **rdy** » Thu Jul 22, 2004 9:19 am

I'm using a transform with a sequential file input and ODBC lookup. I want to extract all the records in the ODBC that match the key value in the sequential file.

However, the transform currently grabs the FIRST record in the ODBC that matches, and not the rest.

I know there's a setting somewhere that says "grab all the matching records". Anyone know where that is?

chulett · Post by **chulett** » Thu Jul 22, 2004 9:46 am

You need to go to the Link Properties of the Transformer stage you are doing the lookups from. It is there on the Inputs tab that you'll find a check box for Reference Link with multi row result set.

sumitgulati · Post by **sumitgulati** » Thu Jul 22, 2004 10:47 am

Great chulet, I never knew about this option.

Thanks,
Sumit

chulett · Post by **chulett** » Thu Jul 22, 2004 11:12 am

Applicable to both the ODBC and UV stages, by the way.

sumitgulati · Post by **sumitgulati** » Thu Jul 22, 2004 11:16 am

Yaa, and I guess Hash File always takes the last record.

-Sumit

ray.wurlod · Post by **ray.wurlod** » Fri Jul 23, 2004 4:59 am

If you're doing a lookup to a hashed file (even via a UV stage) using the key, then it returns "that" row, not the first, not the last. In hashed files (all UV tables are hashed files), the key is UNIQUE.