Hi,
I am using a lookup(using transfromer) in server job on a hash file. For each input record, I want to extract multiple records from the hash file. The moment I make any column as the key, the duplicates are removed from the hash file.
Please help
multiple reference records from hash file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are no duplicates in a hashed file. The hashed file has a primary key. By definition, the key to a hashed file - the Primary Key - is unique. A primary key is unique in every database of which I am aware.
What are you trying to accomplish?
What are you trying to accomplish?
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.