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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Back to discussions
Expand all | Collapse all

How can you do SQL selects to search through saved documents

  • 1.  How can you do SQL selects to search through saved documents

    Posted 01/02/04 12:14 PM

    We have our guarenteed documents being stored to an Oracle database. The documents themselves are stored in a blob coulmn. I need to search through these documents to do some analysis of who sent messages about a certain order and when. I have tried doing LIKE, SUBSTR, and INSTR in the where clause on the blob to no avail. Any ideas on how to interegate the saved documents?


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 2.  RE: How can you do SQL selects to search through saved documents

    Posted 02/25/04 05:16 PM

    We built a quick solution for TN documents saved to BizDoc table. Essentially we used the wm.tn.doc:view service, which, when given an internal DocID, will return the document as a BizDoc.

    For us the steps were

    1. Determine the internal DocID for the a particular Sender and external ID number

    Select DocID From BizDoc Where (NativeID = ‘%externalID%’ and OrigSenderID = ‘%senderID%’ and DocTypeID = ‘doctypeid’)

    1. Use the DocID returned for the wm.tn.doc:view service. Saved BizDoc returned.

    hope this helps

    Ted


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


Related Content