I am trying to perform a lookup on a table and all records are being rejected
The two keys that I am joining are
TypeA Char (30)
TypeB VarChar(20)
I changed the types so that they would be the same type and length and still they are all rejected. Can someone please tell me what I am doing wrong.
Thanks
Lookup Stage
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Its pretty obvious that column TypeA is of length 30 and type char. That means if you have "Alpha" as a value in TypeA, it will still have length of 30, whereas if you have the value "Alpha" in a colum varchar of length 30, its length will only be 5.
Krazykoolrohit is right, trim the inputs and change the char to varchar.
Krazykoolrohit is right, trim the inputs and change the char to varchar.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you trim a Char datatype in a parallel job, the result is immediately padded with the character specified in APT_STRING_PADCHAR. You will therefore also need to convert both columns (only temporarily if necessary) to VarChar.
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: 83
- Joined: Sat Oct 28, 2006 6:25 am
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Lookup Stage - Multiple Keys
Is it possible to user to different key lookups in one lookup stage.
i.e. Field_A.input = B.Code_Table
Field_C.input = B.Code_Table
How do I join multiple fields to one Code table field.
Thanks
i.e. Field_A.input = B.Code_Table
Field_C.input = B.Code_Table
How do I join multiple fields to one Code table field.
Thanks