Starange Problem
Moderators: chulett, rschirm, roy
Starange Problem
I have one field coming in from the source with values
YES or NO
and I have in my Oracle table
1 YES
2 NO
3 UNKNOWN
what i have to do is compare the src value and i have to get the key(1 or 2 or 3)
both are varchar fields I am trimming to make sure there is no space too..but its never matching those values i checked the hash values and the src values looks everything same.
Did anybody ever got through these type of situation? if, suggest me..
nsm.
YES or NO
and I have in my Oracle table
1 YES
2 NO
3 UNKNOWN
what i have to do is compare the src value and i have to get the key(1 or 2 or 3)
both are varchar fields I am trimming to make sure there is no space too..but its never matching those values i checked the hash values and the src values looks everything same.
Did anybody ever got through these type of situation? if, suggest me..
nsm.
Re: Starange Problem
Post the code that does the comparison please.
Ogmios
Ogmios
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Does the job that pre-loads the hashed file that you use for reference lookups Trim the values on the way in, and declare the description field to be the key and the code field to be the non-key column?
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I think the code you need to populate the hashed file should be and that the hashed file's key column should be web_text.
Is this the case?
Code: Select all
SELECT upper(rtrim(web_text)),web_key FROM WEB_DIM
Is this the case?
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.
-
- Participant
- Posts: 9
- Joined: Mon Apr 28, 2003 4:42 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I think it's time for you to post the exact:
- (a) column definitions from the main input link
(b) column definitions from the reference input link
(c) reference key expression
(d) any constraint expression
(e) samples of data from main input link with text fields quoted
(f) samples of data from reference input link with text fields quoted
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.