DSXchange

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?

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.

Great chulet, I never knew about this option.

Thanks,
Sumit

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

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

-Sumit

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.