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?
More than one record from transform stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.