DSXchange

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

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

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

Yes it's dynamic....

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.