Hi,
im loading a hash file from a oracle View, which has around 4000 records.
The hash file is loaded successfully.
The problem is for few records junk values are there along with the required value
EX: 129943 enfienf
129943 is the required value,but im getting a junk value "enfienf",along with this. i checked the source View. The source data is fine .The problem is only in the hash file
Does any have idea regarding this and how to prevent this?
hash file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Sun Jan 29, 2006 3:57 am
hash file
PRASANNAKUMAR JAYARAJ
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No you're not, you're loading a hashed file.jprasannakumar wrote:im loading a hash file
My guess is that you've mishandled the metadata for the hashed file. Hashed files must have a primary key, and fields are accessed by position, rather than by name.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Another option - what specific Oracle client version are you using? I've seen similar behaviour, random 'junk' characters added to fields, with certain versions of the client. For me, it was specifically a 10g client and we had to 'downgrade' to a 9i client to get it to work properly, even though the source database was 10g.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers