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

how to delete xml, but i don't know ino:id?

  • 1.  how to delete xml, but i don't know ino:id?

    Posted Thu September 09, 2004 07:14 AM

    If I want delete xml (ex:ino:@1)
    but I don’t know ino:id, how can i do?

    -----
    <%@ Page Language=“C#” %>
    <%@ Import Namespace = “SoftwareAG.Tamino.Api” %>
    <%@ Import Namespace = “SoftwareAG.Tamino.Api.DataAdapter” %>


    -----
    command.Delete(new TaminoUri(“./Property/@1”));
    If i want insert a value(ex;name=“peter”) to fine the xml,and delete this data , but I don’t know it docname, how can i do.

    I am use asp.net IIS 5.0

    thx


    #webMethods
    #webMethods-Tamino-XML-Server-APIs
    #API-Management


  • 2.  RE: how to delete xml, but i don't know ino:id?

    Posted Thu September 09, 2004 11:41 AM

    This may or may not be what you want: http://tamino.forums.softwareag.com/viewtopic.php?p=2980. This article is describing how to delete particular documents by specific search criteria.

    To be able to delete a specific document it is up to you to identify it. This means that either you need to know its name (docname or id) or it has to have a “primary key” that you can specify.


    #webMethods-Tamino-XML-Server-APIs
    #webMethods
    #API-Management


  • 3.  RE: how to delete xml, but i don't know ino:id?

    Posted Sat September 11, 2004 05:49 PM

    Can you give me some xquery and x-query example use asp.net, I find the tamino document but I don’t know how to add it to my asp.net program.
    -----
    Maybe use APIsimplesample collection, insert PropertyType=“3-Room-Apartment” or
    email= “Jenny.Agutter@inetmessaging.com” then delete the document.
    -----
    thx


    #API-Management
    #webMethods-Tamino-XML-Server-APIs
    #webMethods


  • 4.  RE: how to delete xml, but i don't know ino:id?

    Posted Mon September 13, 2004 11:02 AM

    Try out sample XQueries in the interactive interface. But I’d do a “return” rather than “delete” until you are sure that you can identify the document that you want to delete (use the “where” clause).


    #webMethods-Tamino-XML-Server-APIs
    #API-Management
    #webMethods


  • 5.  RE: how to delete xml, but i don't know ino:id?

    Posted Thu September 30, 2004 11:55 AM

    I am use follow xml,schema
    schema?xml

    ----------

    I find follow command
    update delete input()/bib/book[editor/last=“Gerbarg”]

    ----------

    modify it
    update delete input()/schedule/otime/affair[editor/title=“vb”]

    ----------

    get the error message

    <?xml version="1.0" encoding="Big5" ?>
    - <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
    - <xq:query xmlns:xq=“http://namespaces.softwareag.com/tamino/XQuery/result”>
    - <![CDATA[ update delete input()/schedule/otime/affair[editor/title="vb"]
    ]]>
    </xq:query>
    - <ino:message ino:returnvalue=“8552”>
    <ino:messagetext ino:code=“INOXME8552”>Not a valid request</ino:messagetext>
    ino:messagelineIt is not possible to open a cursor with XQuery Update Request.</ino:messageline>
    </ino:message>
    </ino:response>

    How can I modify it.
    -----------

    I use http://forums.tamino.com/3/OpenTopic?a=tpc&s=153292895 write the command

    ------------

    declare namespace tf=“http://namespaces.softwareag.com/tamino/TaminoFunction
    update for $i in input()/schedule/otime/affair[title=‘vb’]
    where tf:getInoId($i) = 2036
    do delete $i

    ----------------

    but get the error message

    <?xml version="1.0" encoding="Big5" ?>
    - <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
    - <xq:query xmlns:xq=“http://namespaces.softwareag.com/tamino/XQuery/result”>
    - <![CDATA[
    declare namespace tf="http://namespaces.softwareag.com/tamino/TaminoFunction"
    update for $i in input()/schedule/otime/affair[title='vb']
    where tf:getInoId($i) = 2036
    do delete $i


    ]]>
    </xq:query>
    - <ino:message ino:returnvalue=“8552”>
    <ino:messagetext ino:code=“INOXME8552”>Not a valid request</ino:messagetext>
    ino:messagelineIt is not possible to open a cursor with XQuery Update Request.</ino:messageline>
    </ino:message>
    </ino:response>

    Can you help me, get the right command


    #API-Management
    #webMethods
    #webMethods-Tamino-XML-Server-APIs


  • 6.  RE: how to delete xml, but i don't know ino:id?

    Posted Thu September 30, 2004 12:20 PM

    If you want to delete the WHOLE document rather than a node then the following answer is probably what you are after:

    http://tamino.forums.softwareag.com/viewtopic.php?p=2980


    #webMethods
    #webMethods-Tamino-XML-Server-APIs
    #API-Management


  • 7.  RE: how to delete xml, but i don't know ino:id?

    Posted Thu November 04, 2004 09:03 AM

    declare namespace tf=“http://namespaces.softwareag.com/tamino/TaminoFunction
    update for $i in input()/schedule/otime/affair[title=‘vb’]
    where tf:getInoId($i) = 2036
    do delete $i

    If I don’t know InoId,should I how to delete?


    #webMethods-Tamino-XML-Server-APIs
    #API-Management
    #webMethods


  • 8.  RE: how to delete xml, but i don't know ino:id?

    Posted Thu November 04, 2004 09:30 AM

    Either you will need to assign document names (docnames) to your documents or you will need a way of uniquely identifying the document (something similar to the primary key in SQL).


    #webMethods
    #webMethods-Tamino-XML-Server-APIs
    #API-Management


  • 9.  RE: how to delete xml, but i don't know ino:id?

    Posted Mon November 08, 2004 03:01 AM

    I say again.

    I know ino:id what is mean.But,if I don’t know ino:id’s value,how to know ino:id’s value.
    My English is very poor. Sorry ><"


    #webMethods-Tamino-XML-Server-APIs
    #webMethods
    #API-Management


  • 10.  RE: how to delete xml, but i don't know ino:id?

    Posted Mon November 08, 2004 03:17 AM



    Don’t tell me to look tamino’s db


    #API-Management
    #webMethods-Tamino-XML-Server-APIs
    #webMethods


  • 11.  RE: how to delete xml, but i don't know ino:id?

    Posted Mon November 08, 2004 10:08 AM

    A query of this form will return a list of matching ino:ids:

    declare namespace tf="http://namespaces.softwareag.com/tamino/TaminoFunction" 
    for $x in input()/DataDocs
    where $x/PHONE = "12345"
    return <id>{tf:getInoId($x)}</id>

    #webMethods
    #webMethods-Tamino-XML-Server-APIs
    #API-Management