Hashed File:HASH.HELP.DETAIL command error

AdrianoBrazzola · Post by **AdrianoBrazzola** » Tue Jun 20, 2006 7:36 am

Hi

I am trying to determine the best structure for an hashed file using HASH.HELP.DETAIL command. The hash file is pathed, therefore I run the following command to enter a pointer in the VOC: SETFILE '\\datastageserver\..\hashedfilename'. I called the pointer with this name: hashedfilename. When I run HASH.HELP.DETAIL hashedfilename, I got the following error: Cannot process type 1,19,25 or 30 file "\\datastageserver\..\hashedfilename".

Do you have any idea why?

Thanks in advance

Adriano

chulett · Post by **chulett** » Tue Jun 20, 2006 7:51 am

It's only valid for Static hashed files, guessing yours is Dynamic.

AdrianoBrazzola · Post by **AdrianoBrazzola** » Tue Jun 20, 2006 8:01 am

chulett wrote:It's only valid for Static hashed files, guessing yours is Dynamic.

Yes it's dynamic....

ray.wurlod · Post by **ray.wurlod** » Tue Jun 20, 2006 2:43 pm

Use ANALYZE.FILE hashedfile STATS to report the sizing statistics then use the Hashed File Calculator to get a recommendation on minimum modulus. You only have two choices for hashing algorithm (sequential numeric keys or other keys) so that part is not rocket science.