Types of hash file in command window

rajiivnb · Post by **rajiivnb** » Sun Mar 20, 2005 9:24 pm

Hi Group,

Can any one tell me wht are all the types and its functionality of creating hash files in a command window,

eg.,

CREATE.FILE TEST 19

thnx in advance.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 21, 2005 3:01 am

Types 1, 19 and 25 are not hashed files. Types 1 and 19 are directories; type 25 is a B-tree.
Types 2 through 18 are static hashed files with different hashing algorithms. Type 30 is a dynamic hashed file. Static hashed files do manage their "table space" automatically; dynamic hashed files do.

They are all created with the CREATE.FILE command. For static hashed file you must provide the file type, modulo (number of groups) and separation (size of each group). For dynamic hashed files there are six tuning parameters, but in general the default values for these are suitable. This is the default type of hashed file for DataStage.

You can get more information from searching this Forum, from Ascential's "DataStage Essentials" class, and from IBM's UniVerse manual library