Hash File Key field limitation

userds · Post by **userds** » Fri Jul 29, 2005 1:43 pm

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.

chulett · Post by **chulett** » Fri Jul 29, 2005 4:02 pm

Two things:

1) I believe max key length is controlled by a uvconfig file parameter. I have no idea what effect changing this would have.

2) Why in the world would you need a 2000 character key? Do you really need to do this?

ray.wurlod · Post by **ray.wurlod** » Fri Jul 29, 2005 8:43 pm

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.

userds · Post by **userds** » Sun Jul 31, 2005 8:03 pm

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.

chulett · Post by **chulett** » Sun Jul 31, 2005 8:31 pm

No, not directly. You might want to explain what you are trying to do, then you can get something less 'generic' in the way of advice.