webMethods

webMethods

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
Expand all | Collapse all

Does Tamino 4.1.1.1 support "distinct-values" function?

  • 1.  Does Tamino 4.1.1.1 support "distinct-values" function?

    Posted Mon April 28, 2003 04:58 AM

    Does Tamino 4.1.1.1 support “distinct-values” function? As I know, I don’t support it yet. Well I want to know if there is any plan to support it. Without it, I can not group xml data on Tamino.


    #API-Management
    #webMethods
    #Tamino


  • 2.  RE: Does Tamino 4.1.1.1 support "distinct-values" function?

    Posted Tue April 29, 2003 08:33 PM

    Hello,
    the function distinct-values is currently not available in Tamino XQuery 4.
    It is high on the priority list for the next version.
    Under certain circumstances a workaround may be used with a self join like this:

    declare namespace tf = “http://namespaces.softwareag.com/tamino/TaminoFunction

    for $b in input()/bib/book
    where tf:getInoId(root($b)) eq
    min(
    for $c in input()/bib/book
    where $b/@year eq $c/@year
    return tf:getInoId(root($c))
    )
    return $b

    But be aware that such a complex construction is currently not optimized at all.

    Best regards
    Walter


    #Tamino
    #API-Management
    #webMethods