sr******@yahoo.com (Srini) wrote in message news:<23**************************@posting.google. com>...
Hello DB2 Experts,
I have a Clob column and I need to search for a String in that.
Case insensitive search.
I tried,
select * from MyTable where UPPER(varchar(CLOB_COLUMN)) LIKE
'%some-data%'
[IBM][CLI Driver][DB2] SQL0171N The data type, length or value of
argument "1" of routine "UPPER" is incorrect. SQLSTATE=42815
DB2 version: DB2 on OS/390 07.01.0001
Appreciate any help.
Thanks,
Srini.
In "DB2 Universal Database for OS/390 and z/OS SQL Reference Version
7", for UCASE or UPPER function, it says that "string-expression .....
A character string argument ..... and must have an actual length that
is not greater than 255."
So, it seems that you can not change a string longer than 255 to upper
case with one UPPER or one TRANSLATE function.