Hash Files

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
dineshrk
Participant
Posts: 46
Joined: Thu Jun 26, 2008 9:14 pm

Hash Files

Post 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.
sachin1
Participant
Posts: 325
Joined: Wed May 30, 2007 7:42 am
Location: india

Re: Hash Files

Post 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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As noted, they are two distinct values. Please double-check your findings.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

Check whether you have a downcase or upcase function before loading the data to hash file.
Kandy
_________________
Try and Try again…You will succeed atlast!!
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

A hash file is for trimming a block of hash. DataStage uses hashed files.
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