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