IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

BLOB or CLOB DataType

  • 1.  BLOB or CLOB DataType

    Posted Tue October 29, 2002 03:34 AM

    If one column is CLOB or BLOB datatype, for example, gif image or word doc,
    can XNODE support CLOB or BLOB datatype?
    if yes, how to query?

    thanks,

    Best Regards,

    Michael


    #webMethods
    #Tamino
    #API-Management


  • 2.  RE: BLOB or CLOB DataType

    Posted Mon November 11, 2002 05:50 PM

    Hi Michael,

    I think the answer to the question is no, Blobs/clobs are not supported via X-Node. The problem I forsee is that when a blob is returned from the SQL store it is in it’s raw form. The question then is how to embed this into an XML document? Without some form of encoding (e.g. base64) the binary object would invalidate the xml most likely. Therefore it is well advised to handle XML and non XML separately.

    Stuart


    #API-Management
    #Tamino
    #webMethods


Related Content