OnDemand User Group
Support Forums => MP Server => Topic started by: rstockton on January 15, 2015, 12:20:12 PM
-
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
-
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
-
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.
-
Thanks Greg, I defined the fields as UPPER and that worked.
-
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.