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
  • 1.  Problems with "update insert"

    Posted 05/15/10 04:15 PM

    Hello Everyone

    I’ve got a problem. My “update insert”-statement doesn’t work and i’ve got no idea why…

    my schema looks like:

    <?xml version = "1.0" encoding = "UTF-8"?>

    <xs:schema xmlns:tsd = “http://namespaces.softwareag.com/tamino/TaminoSchemaDefinition” xmlns:xs = “http://www.w3.org/2001/XMLSchema”>
    xs:annotation
    xs:appinfo
    <tsd:schemaInfo name = “Mensch”>
    <tsd:collection name = “Person”></tsd:collection>
    <tsd:doctype name = “Schueler”>
    tsd:logical
    tsd:contentclosed</tsd:content>
    </tsd:logical>
    </tsd:doctype>
    </tsd:schemaInfo>
    </xs:appinfo>
    </xs:annotation>
    <xs:element name = “Schueler”>
    xs:complexType
    xs:sequence
    <xs:element ref = “Name”></xs:element>
    <xs:element ref = “Vorname”></xs:element>
    <xs:element ref = “Bemerkung” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name = “Name” type = “xs:string”></xs:element>
    <xs:element name = “Vorname” type = “xs:string”></xs:element>
    <xs:element name = “Bemerkung” type = “xs:string”></xs:element>
    </xs:schema>
    [/list]

    the statement looks like:
    update insert

    aaa
    aa
    a

    into input()/sem03

    I can start the statement but now row is inserted in the database.
    I also don’t get an error. So i don’t have any idea why.

    the way, I get there

    1. create a database [sem03] - standard formatings
    2. create schema (see top)
    3. define the schema to the database
    4. validate tsd schema (on the database) - no errors occurs
    5. update insert statement (see top) - settings Server:http://192.168.0.88/tamino Database:sem03 Collection:Person

    thanks for your responding.


    #API-Management
    #webMethods
    #Tamino


  • 2.  RE: Problems with "update insert"

    Posted 05/17/10 01:56 PM

    Hi,

    the syntax you are using only allows to insert a new node into an already existing document. Looks like you intend to insert a new document.
    For this, please refer to fn:put function.

    Best Regards,

    Michael


    #API-Management
    #Tamino
    #webMethods