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

Dyanamic Joins in Tamino 4.1

  • 1.  Dyanamic Joins in Tamino 4.1

    Posted Fri February 07, 2003 05:07 PM

    Hi,

    Does Tamino support the ability to create dynamic joins?

    I have a prospect that is interested in having data retrieved from Tamino from 2 different Doctypes in the same Collection, but only access the 2nd Doctype depending on the user query.

    I know that you can manually create the joins using the Tamino Schema editor, but how can this be created dynamically?

    Thanks,

    Thanks,

    Brian Garner
    Advisory Systems Engineer, Softtware AG Canada
    416.364.1133 x.261 office


    #Tamino
    #webMethods
    #API-Management


  • 2.  RE: Dyanamic Joins in Tamino 4.1

    Posted Tue February 11, 2003 04:31 AM

    Brian,
    With Tamino 4.1, you can use XQuery to do the joins. Example: Returns all books for which a review exists, with all authors, title and the review text:
    for $b in input()/bib/book, $a in input()/reviews/entry
    where $b/title = $a/title
    return { $b/author } { $b/title } { $a/review }

    So, just build the query statement dynamically and you are good to go.
    Carl


    #webMethods
    #Tamino
    #API-Management


Related Content