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
  • 1.  Nested Query

    Posted Thu October 30, 2003 07:42 AM

    Hi
    I have a document that has for example an element which is itself a doc in the tamino database. Now I want to replace the element with the name doc in tamino.
    I thought of having a nested query.
    eg.“update replace input()/Doc/name
    with for $q in input()/Name return $q” but then I get an error.
    Please advice
    Regards


    #Tamino
    #API-Management
    #webMethods


  • 2.  RE: Nested Query

    Posted Wed November 26, 2003 03:23 AM

    I’m not sure I understand your description. Let’s say the database has documents “a” and “b”, where “a” has a pointer to the “b” document:





    this is the replacement data

    You want to modify by replacing with , right? You need to use the FLWU syntax:

    update for $bref in input()/a/bRef
    do replace $bref
    with input()/b[@id=$bref/@id]

    Bill


    #API-Management
    #webMethods
    #Tamino