Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    10

    Question Unanswered: How to compare two CLOB value in SELECT command

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: How to compare two CLOB value in SELECT command

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •