Hash file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cnew
Participant
Posts: 5
Joined: Fri Oct 12, 2007 10:27 pm

Hash file

Post by cnew »

How to customize the hash file algorithm and also can somone tell me how to create static hash file. Thanks in advance.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

cnew - welcome to DSXChange.

there are just under 20 different builtin algorithms to hash the key into a bucket for hashed files. Only one of these, type 30, is a dynamic hashed file, all others are static hashed files.

The DSXchange Search is a powerful tool and if you use it on this subject you will find posts such as this one to answer your question.

The details of hashed files can be read from the IBM documentation for UniVerse (which is available for free download) - the two products are still almost identical. If there isn't sufficient information available in DSXChange you can read up on the intricacies of hashed files there and post any questions here - many of the members here come from the old Information/UniVerse worlds and a couple still consult in that space as well.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is no scope whatsoever for custom hashing algorithms. The supplied ones, particularly types 2, 18 and GENERAL and SEQ.NUM, work very well. They have been tuned to perfection over the years. To create a static hashed file choose a type between 2 and 18 inclusive. Use the Hashed File Calculator to generate the commands.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply