MVSFORUMS.com

[jeeva_k]

I am working on a CICS - DB2 program which is used for Online search purpose.

In the program, I am using LIKE predicate in WHERE CLAUSE. This is working well for single byte data (eg: english), whose datatype is CHAR.
Using this, i am getting the search results on the online screen really fast

Japanese double byte is defined as VARCHAR in database. When i try LIKE predicate on this VARCHAR variable, i do get the result, but the performance is really slow.

Is there any way to improve the performance of this.

[kolusu]

jeeva_k,

Try using lookup in hex format

ex: if you are looking for 'abc%'

then use

where var_col like X'C1C2C3%'

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu