Results 1 to 2 of 2

Thread: xmlclob

  1. #1
    Join Date
    Jun 2002
    Location
    UK
    Posts
    525

    Unanswered: xmlclob

    I want to query an xmlclob field to return records where the xml document contains specific strings.

    How can I cast an xmlclob to a char/varchar so that I could use the like predicate?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: xmlclob

    Though easy, it is a bit tricky ...

    values(db2xml.clob(xmlclob-column))

    It is not sysibm.clob , rather it is db2xml.clob .... Normally, SYSIBM tends to be at the beginning of the function path

    You can use the like operator against CLOBs ...


    HTH

    Cheers

    Sathyaram

    Originally posted by Damian Ibbotson
    I want to query an xmlclob field to return records where the xml document contains specific strings.

    How can I cast an xmlclob to a char/varchar so that I could use the like 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
  •