SEO

#1 (**permalink**) 02-27-2008, 02:30 AM

Hi,
I want to search clob data in SQL where clause so i need some
function.Can some pls tell me whether DB2 has some function which reads
clob column and return string like oracle has something dbms_lob.substr
??

Its urgent for me if someone can reply asap.

Ajay

#2 (**permalink**) 02-27-2008, 02:30 AM

cast(substr(clob_col,<start>,<length> as varchar(<length>) ?

James Campbell

"ajay" <agupta@in.ibm.com> wrote in
<1103620494.000268.17500@f14g2000cwb.googlegroups. com>:

>Hi,
>I want to search clob data in SQL where clause so i need some
>function.Can some pls tell me whether DB2 has some function which reads
>clob column and return string like oracle has something dbms_lob.substr
>??
>
> Its urgent for me if someone can reply asap.
>
>Ajay
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode