how about search Key word for clob field ?

anfan2000 · #1 (**permalink**) 09-13-06, 03:53

How about used UCASE or TRANSLATE function for Clob Field (>5M)
(TRANSLATE (CLOB(MORE_INFO) like '%KEYWORD%') ) --> Error 22001: [IBM][CLI Driver][DB2/NT] SQL0433N Value '{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttb l{\f0\fnil\' is too long"

can't you help me.
Thanks

Wim · #2 (**permalink**) 09-13-06, 09:46

The TRANSLATE funtion states:

Quote:

The arguments may be either strings of data type CHAR or VARCHAR, or graphic strings of data type GRAPHIC or VARGRAPHIC. They may not have data type LONG VARCHAR, LONG VARGRAPHIC, BLOB, CLOB, or DBCLOB.

Internet Services

Web Development

Digital Marketing

Consumer Tech