Page 1 of 1
Types of hash file in command window
Posted: Sun Mar 20, 2005 9:24 pm
by rajiivnb
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.
Posted: Mon Mar 21, 2005 3:01 am
by ray.wurlod
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