How to compare two CLOB value in SELECT command

sangeethk · #1 (**permalink**) 01-14-04, 10:56

Hello,

This is some what related to my previous question,
"How to convert StringBuffer to Clob type in java"

The problem is I have one Clob type in my host language Java, I want to compare this value with each Clob value present in database(DB2) using SELECT command or by any other mean.

How can i do this?.

Can anyone please suggest me a solution

With regards,
sangeeth

n_i · #2 (**permalink**) 01-14-04, 12:41

Quote:

Originally posted by sangeethk
Hello,

This is some what related to my previous question,
"How to convert StringBuffer to Clob type in java"

The problem is I have one Clob type in my host language Java, I want to compare this value with each Clob value present in database(DB2) using SELECT command or by any other mean.

How can i do this?.

Can anyone please suggest me a solution

With regards,
sangeeth

I think you can only do it by retrieving each CLOB and comparing its character content with a Java object content. You cannot put two CLOBs in a WHERE (or any other) predicate.

Internet Services

Web Development

Digital Marketing

Consumer Tech