Page 1 of 1
Hash Files
Posted: Thu Jan 22, 2009 3:05 am
by dineshrk
When writing data to Hash files it is treating the below values as one and over writing the data.
256785A
256785a
Is there a solution to it as they are distinct values for me.
Re: Hash Files
Posted: Thu Jan 22, 2009 5:48 am
by sachin1
i have taken your values and taking datatype as varchar with length 10 it creates 2 different record in hash file.
please can you check at your end.
Posted: Thu Jan 22, 2009 6:28 am
by chulett
As noted, they are two distinct values. Please double-check your findings.
Posted: Thu Jan 22, 2009 8:42 am
by kandyshandy
Check whether you have a downcase or upcase function before loading the data to hash file.
Posted: Thu Jan 22, 2009 2:58 pm
by ray.wurlod
A hash file is for trimming a block of hash. DataStage uses hashed files.