Matching Lower Case and Upper Case data in Search

[rstockton]

Is there any way to configure OnDemand to match Upper Case to Lower Case data in a search?  It appears that Index information given in a search has to match the case of the data that was loaded.  Example data was loaded with Index information ABC and the search criteria was entered as abc or Abc and the search result comes back as not found.

Thanks,

Russell

[ewirtz]

Hi Russel,
beginning with DB2 V10 you can create an index like:
CREATE INDEX qual.tablex1
  ON qual.table
  (lower(attr,' ') asc );

Of course this has to be done within DB2. Ondemand does not support this

regards

Egon

[Greg Ira]

Try defining the field in the application group as either Upper or Lower case.  If you use mixed you are required to match cases when searching.

[rstockton]

Thanks Greg, I defined the fields as UPPER and that worked. 

[Alessandro Perucchi]

Hi Russel,
beginning with DB2 V10 you can create an index like:
CREATE INDEX qual.tablex1
  ON qual.table
  (lower(attr,' ') asc );

Of course this has to be done within DB2. Ondemand does not support this

regards

Egon

Well you are right, from a standard way CMOD doesn't support this, BUT you can do it through the table space user exit. And it will involved some C/C++ programming skills.