Case Insensitive Lookup Throwing a Warning

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
jerome_rajan
Premium Member
Premium Member
Posts: 376
Joined: Sat Jan 07, 2012 12:25 pm
Location: Piscataway

Case Insensitive Lookup Throwing a Warning

Post by jerome_rajan »

Hi All,

I am trying to do a case insensitive lookup on a varchar2(255) NOT Nullable column but am getting the following warning

Unrecognized Type specific format: {case-insensitve} on Key "COL_NM".

What could the reason be?
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn

Life is really simple, but we insist on making it complicated.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Did you create the record schema manually?

If not, you seem to have uncovered a bug, which you should report to your official support provider.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Case Insensitive Lookup Throwing a Warning

Post by SURA »

varchar2(255)
VS
varchar(255)
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
jerome_rajan
Premium Member
Premium Member
Posts: 376
Joined: Sat Jan 07, 2012 12:25 pm
Location: Piscataway

Post by jerome_rajan »

Thanks for the reply. I did not create the schema manually. In fact, I am sourcing it from an Oracle table.

The actual lookup is being performed on two keys - one of which is this varchar column and the other is an integer. Could this be a problem though I don't see any reason for that.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn

Life is really simple, but we insist on making it complicated.
jerome_rajan
Premium Member
Premium Member
Posts: 376
Joined: Sat Jan 07, 2012 12:25 pm
Location: Piscataway

Re: Case Insensitive Lookup Throwing a Warning

Post by jerome_rajan »

SURA wrote:varchar2(255)
VS
varchar(255)
Sorry, I meant varchar(255)
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn

Life is really simple, but we insist on making it complicated.
Post Reply