I kept the hash file key column data length as Char(2000). But the key column is not accepting more than 768 charecters. Can anyone please let me know how i can overcome this limitation.
Thanks.
Hash File Key field limitation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The maximum permissible MAXKEYLENGTH setting is 768.
You simply can not make it 2000.
What the heck are you trying to do?!!!
Small is good, as far as hashed files are concerned.
You simply can not make it 2000.
What the heck are you trying to do?!!!
Small is good, as far as hashed files are concerned.
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.
Hash File Key field limitation
Thanks a lot for your replies. But is it possible to use Sequential file stage instead of Hashfile stage for lookupups. Please let me know.